# Excel Level I: Fundamentals Course Online (Self-Paced)

Canonical URL: <https://www.nextgenbootcamp.com/classes/excel-fundamentals-self-paced>

## Overview

This beginner Excel workshop introduces high school learners to essential Microsoft Excel skills, including basic calculations, common functions, charts, formatting, and printing. Through guided, hands-on exercises, you'll learn each concept step by step, practice it on your own, and build confidence using Excel for school projects and everyday tasks. You'll also have access to beginner-friendly video lessons and a training guide you can keep for reference as you continue working with Excel. The workshop also touches on how AI is changing the way people use spreadsheets. AI assistants are now built into tools like Excel to help with formula writing, data analysis, and pattern recognition, so the foundational skills you're picking up here set you up to take advantage of those features as they continue to grow.

## What you'll learn

- Become familiar with the interface and data entry
- Learn essential formulas and functions
- Format and print your work
- Create charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Review key concepts in a final project

## Curriculum

### Introduction

#### Interface

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

#### Worksheets

- Manage elements of worksheets

#### Data Entry

- Examines and describes multiple means of entering data

#### Rows & Columns

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

### 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

#### Cell Styles

- Apply consistent formatting to specific types of cells or values

#### Conditional Formatting

- Apply a predetermined format based on specified rules

### Charts & Tables

#### Tables

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

#### 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

### 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

## Pricing

**Tuition:** $249