# Beginner Microsoft Excel

Canonical URL: <https://www.careercenters.com/courses/excel-fundamentals>

## Overview

Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and complete beginners alike. Develop a command of time-saving Excel shortcuts and hotkeys.

### Practical Real-World Training

Our Excel course includes practical exercises that walk you through the basics. Learn the concept, watch an example, complete an activity with the new concept on your own. At the end of the course, you’ll keep your training guide for reference whenever you use Excel.

### Comprehensive Excel Video Suite

 Students in our Beginner Excel course receive access to our companion video suite, featuring beginner level video lessons available for viewing on desktop, mobile, and tablet. These video tutorials explain popular Excel concepts in simple steps. 

### Free Retake

Need a refresher? No problem! After you’ve signed up for the course, you can retake within one year of your original enrollment free of charge (and so long as there is an available seat in the class). 

### Get 15% Off by Enrolling in Bootcamp

Is your goal to become an advanced Excel user? Save money and sign up for our three-day [Excel Bootcamp](/courses/excel-bootcamp-nyc) and save 15% on your enrollment fees.

## What you'll learn

- Get started with Microsoft Office Excel 2016
- Perform Calculations
- Modify Text
- Format a Worksheet
- Create Charts and Tables
- Manage Workbooks

## 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 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
- Aug 2, 2026 10:00am–5:00pm — NYC
- Aug 2, 2026 10:00am–5:00pm — NYC
- Aug 4, 2026 – Aug 6, 2026 — 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 – Sep 10, 2026 — NYC
- Sep 27, 2026 10:00am–5:00pm — NYC
- Oct 13, 2026 10:00am–5:00pm — NYC
- Oct 19, 2026 10:00am–5:00pm — NYC
- Nov 9, 2026 10:00am–5:00pm — NYC

## Pricing

**Tuition:** $249