# Excel for Business Fundamentals

Canonical URL: <https://training-nyc.com/courses/excel-fundamentals>

## Overview

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print-ready spreadsheets while learning tricks to accelerate your workflow.

### Save 15% on Enrollment with our Excel Bootcamp

Do you want to become an advanced Excel user in just three days? Sign up for our [Microsoft Excel Bootcamp](/courses/excel-bootcamp-nyc) and get a 15% package discount. 

### Class Notes

- **Prerequisites:** Prior experience with Excel is not required; however, attendees must be comfortable with computer basics.
- A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.

## What you'll learn

- AutoSum functions
- Calculations and data entry
- Absolute cell references
- Formatting and printing
- Multi-input functions
- Line, column, and pie charts
- Tables

## Curriculum

### Introduction

#### Interface

- Provides a brief description of the user interface for Microsoft Excel

#### Data Entry

- Examines and describes multiple means of entering data

#### Rows & Columns

- Insert, delete, hide, and group rows and columns

#### Worksheets

- Manage elements of worksheets

### Formulas

#### Autofill

- Explores Excel's amazing ability to predict and extrapolate patterns

#### Calculations

- Perform mathematical expressions and review the Order of Operations rule

#### AutoSum Functions

- Review the five key functions: Sum, Average, Max, Min, and Count Numbers

#### Absolute Reference

- Changing a cell reference into a constant, which is necessary for certain calculations

#### True or False

- Tests to see whether criteria is true/false

#### Text Functions

- Introduces functions used to modify text in Excel

#### Multi-Input Functions

- More advanced functions that require more than one input

### Formatting

#### Formatting

- The addition of effects to an Excel document to provide visual instruction

#### Conditional Formatting

- Apply a predetermined format based on specified rules

### Charts & Tables

#### Column Chart

- Create a Column chart to visually examine data

#### Line Chart

- Create a Line chart and Spark lines to visually examine data

#### Pie Chart

- Create a Pie chart to visually examine data

#### Tables

- Explore the special functionality created when data is converted to a Table

### Workbook Management

#### Freeze Panes

- Enable a portion of the screen to stay visible at all times

#### Printing

- Rules and strategies to make printing easy

#### Windows

- Change how your worksheet displays data

#### Templates

- Use prefabricated templates to build a spreadsheet

#### Excel Tricks

- Fundamental keyboard shortcuts and other Excel tricks

### End of Class Projects

#### Projects

- End of class projects to review key concepts from the class

## Schedule
- Jun 9, 2026 10:00am–5:00pm — NYC
- Jun 16, 2026 10:00am–5:00pm — NYC
- Jun 22, 2026 10:00am–5:00pm — NYC
- Jun 29, 2026 10:00am–5:00pm — NYC
- Jul 7, 2026 10:00am–5:00pm — NYC
- Jul 13, 2026 10:00am–5:00pm — NYC
- Jul 20, 2026 10:00am–5:00pm — NYC
- Jul 29, 2026 10:00am–5:00pm — NYC
- Jul 29, 2026 10:00am–5:00pm — NYC
- Aug 2, 2026 10:00am–5:00pm — NYC
- Aug 2, 2026 10:00am–5:00pm — NYC
- Aug 3, 2026 – Aug 5, 2026 — NYC
- Aug 4, 2026 – Aug 6, 2026 — NYC
- Aug 11, 2026 10:00am–5:00pm — NYC
- Aug 11, 2026 10:00am–5:00pm — NYC
- Aug 24, 2026 10:00am–5:00pm — NYC
- Sep 1, 2026 10:00am–5:00pm — NYC
- Sep 8, 2026 10:00am–5:00pm — NYC
- Sep 8, 2026 10:00am–5:00pm — NYC
- Sep 8, 2026 – Sep 10, 2026 — NYC

## FAQ

### What version of Excel does this course cover?

The instructors typically present using Excel 2019 or Office 365. However, you can also use Excel 2013 or 2016; the exercises and interface are compatible with what we teach (with some minor differences that the instructor will explain).

## Pricing

**Tuition:** $249