Modules

1: Intro to Excel

Intro to Excel

What’s New In Excel 2019?

Course Overview

Overview of the Excel window

Mouse Features

Back Stage View

2. Creating Workbooks

Entering Text and Numbers

Creating Basic Formulas

Relative References

Order of Operations

Working with Ranges

Practice Exercise

3. Saving Workbooks

Working with the Save and Save As Commands

File Extensions, Share, Export, and Publish Files

Practice Exercise

4. Navigating Workbooks

Opening a File

Working with Larger Files

Freeze Panes Option

Split Screen Option

Practice Exercise

5. Page Setup and Print Options

Headers and Footers

Print Titles

Comments

Page Setup Options

Fit to Print on One Page

Printing Workbooks

Practice Exercise

6. Working with Rows, Columns, and Cells

Adding and deleting rows columns and cells

Changing Column and Row Widths

Practice Exercise

7. Moving Data

Cut, Copy, and Paste

Copying Formulas

Practice Exercise

8. Formulas and Functions

Overview of Formulas

Create Formulas Using Functions – part1

Create Formulas Using Functions – part 2

Absolute Values

Practice Exercise

9. Working with Sheets

Adding, Deleting, and Renaming Sheets

Additional Sheet Tab Options

3 Dimensional Formulas

Practice Exercise

10. Formatting Worksheets

Formatting Cells – part 1

Formatting Cells – part 2

Formatting Numbers

Borders and Shading

Format as Table

Using Styles

Using Format Painter

Protecting Sheets

Fill Handle and Custom Lists

Practice Exercise

11. Charts

Creating Charts

Types of Charts

Editing Charts – Part 1

Editing Charts – Part 2

Using Graphics to Enhance Charts

Linking Chart Titles

Module 11 – Practice Exercise

12. Working with Names
Creating Range Names

Managing Names

Using Names in Formulas

Practice Exercise

13. Sorting and Filtering

Remove Duplicates

Sort Data

Filter Data

Advanced Filters

Practice Exercise

14. Outlining and Subtotaling

Creating an Outline

Subtotals

Practice Exercise

15. Working with Views

Arranging Files

New Window Option

Custom Views

Practice Exercise

16. Linking Files

Creating Formulas between Files

Working with Links

Consolidating Data

Practice Exercise

17. Advanced Formula Creation

If Statements

VLookups

Data Validation

Formula Auditing

Practice Exercise

18. PivotTables

PivotTables

Pivot Charts

Practice Exercise

19. Additional Excel Features

Slicers

Goal Seeker

Text to Columns

Watch Window

Customizing Ribbons and Tabs

Practice Exercise

20. Shortcuts

Excel Shortcuts Every User Should Know

21. Closing

Closing Video