Part 1
Module 1: Introduction to Excel
The Excel 2019 Window; Mouse Basics in Excel; Backstage View
Module 2: Creating Workbooks
Entering Text and Numbers; Creating Basic Formulas; Relative References; Order of Operations; Working with Ranges
Module 3: Saving and Sharing Workbooks
Saving a Workbook; File Extension; Sharing, Exporting, and Publishing Files
Module 4: Navigating Workbooks
Opening Files; Working with Larger Files; Creating Freeze Panes; Split Screen
Module 5: Page Setup and Print Options
Headers and Footers; Print Titles; Working with Comments; Page Setup Options; Printing Workbooks
Module 6: Working with Rows, Columns, and Cells
Adding and Deleting Rows, Columns, and Cells; Changing Column Width and Row Height
Module 7: Moving Data
Cut, Copy, and Paste; Copying Formulas
Module 8: Formulas and Functions
Overview of Formulas; Creating Formulas Using Functions; Using Absolute Values
Module 9: Working with Sheets
Adding, Deleting, Renaming, and Grouping Sheets; Additional Sheet Tab Options; 3-Dimensional Formulas
Module 10: Formatting Worksheets
Formatting Cells; Formatting Numbers; Borders and Shading; Formatting a Range of Cells as a Table; Using Styles and the Format Painter; Protecting Sheets; Using the Fill Handle and Creating Custom Lists
Part 2
Module 1: Using Charts
Creating Charts; Types of Charts; Editing Charts; Using Graphics to Enhance Charts; Linking Chart Titles; Creating Sparklines
Module 2: Working with Names
Creating Range Names; Managing Names; Using Names in Formulas
Module 3: Sorting and Filtering Data
Removing Duplicate Rows; Sorting Data; Filtering Data; Using Advanced Filters
Module 4: Outlining and Subtotaling Data
Creating an Outline; Adding Subtotals
Module 5: Working with Views
Arranging Files; New Window Feature; Custom Views
Module 6: Linking Files
Creating Formulas Between Files; Working with Links; Consolidating Data
Module 7: Advanced Formula Creation
Using IF Statements; Using Functions to Look Up Data; Working with Data Validation; Formula Auditing; Using the Watch Window
Module 8: Overview of PivotTables and PivotCharts
PivotTables; PivotCharts; Slicers
Module 9: Customizing Excel
Excel Options; Customizing the Ribbon; Modifying Workbook Properties
Module 10: Additional Excel Features
Text to Columns; Conditional Formatting; Hyperlinks; the Spell Checker and Translate Features; Quick Analysis Tool; the Document Inspector; Import Data from a Text / CSV File