# Excel Level I: Fundamentals

Canonical URL: <https://www.creativelive.com/classes/basic-excel-classes>

## Overview

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, charts, formatting, and printing. This basic Excel class is perfect for those with limited experience who want to expand their proficiency. Our Excel course includes practical exercises that guide you through the basics. Learn the concept, watch an example, and complete an activity using the new concept on your own. At the end of the course, you’ll keep your training guide for reference whenever using Excel.

After completing the Excel Level I course, you’ll receive access to our companion video suite, featuring beginner-level video lessons viewable on desktop, mobile, and tablet. These video tutorials explain popular Excel concepts in easy-to-follow steps.

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

#### 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 — Live Online
- Jun 16, 2026 10:00am–5:00pm — Live Online
- Jun 22, 2026 10:00am–5:00pm — Live Online
- Jun 29, 2026 10:00am–5:00pm — Live Online
- Jul 7, 2026 10:00am–5:00pm — Live Online
- Jul 13, 2026 10:00am–5:00pm — Live Online
- Jul 20, 2026 10:00am–5:00pm — Live Online
- Jul 29, 2026 10:00am–5:00pm — Live Online
- Aug 2, 2026 10:00am–5:00pm — Live Online
- Aug 4, 2026 – Aug 6, 2026 — Live Online
- Aug 11, 2026 10:00am–5:00pm — Live Online
- Aug 24, 2026 10:00am–5:00pm — Live Online
- Sep 1, 2026 10:00am–5:00pm — Live Online
- Sep 8, 2026 10:00am–5:00pm — Live Online
- Sep 8, 2026 – Sep 10, 2026 — Live Online
- Sep 27, 2026 10:00am–5:00pm — Live Online
- Oct 13, 2026 10:00am–5:00pm — Live Online
- Oct 19, 2026 10:00am–5:00pm — Live Online
- Nov 9, 2026 10:00am–5:00pm — Live Online

## FAQ

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

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

## Pricing

**Tuition:** $249