Course Content
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