Mastering Excel for Microsoft 365 Training Tutorial

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Course Introduction

Chapter 2: Getting Acquainted with Excel

Lecture 1: About Excel

Lecture 2: The Excel Environment

Lecture 3: The Title Bar

Lecture 4: The Ribbon

Lecture 5: The “File” Tab and Backstage View

Lecture 6: Scroll Bars

Lecture 7: The Quick Access Toolbar

Lecture 8: Touch Mode

Lecture 9: The Formula Bar

Lecture 10: The Workbook Window

Lecture 11: The Status Bar

Lecture 12: The Workbook View Buttons

Lecture 13: The Zoom Slider

Lecture 14: The Mini Toolbar

Lecture 15: Keyboard Shortcuts

Chapter 3: File Management

Lecture 1: Creating New Workbooks

Lecture 2: Saving Workbooks

Lecture 3: Closing Workbooks

Lecture 4: Opening Workbooks

Lecture 5: Recovering Unsaved Workbooks

Lecture 6: Opening a Workbook in a New Window

Lecture 7: Arranging Open Workbook Windows

Lecture 8: Freeze Panes

Lecture 9: Split Panes

Lecture 10: Hiding and Unhiding Workbook Windows

Lecture 11: Comparing Open Workbooks

Lecture 12: Switching Open Workbooks

Lecture 13: Switching to Full Screen Mode

Lecture 14: Working with Excel File Formats

Lecture 15: AutoSave Online Workbooks

Chapter 4: Data Entry

Lecture 1: Selecting Cells

Lecture 2: Entering Text into Cells

Lecture 3: Entering Numbers into Cells

Lecture 4: AutoComplete

Lecture 5: Pick from Drop-Down List

Lecture 6: Flash Fill

Lecture 7: Selecting Ranges

Lecture 8: Ranged Data Entry

Lecture 9: Using AutoFill

Chapter 5: Creating Formulas

Lecture 1: Ranged Formula Syntax

Lecture 2: Simple Formula Syntax

Lecture 3: Writing Formulas

Lecture 4: Using AutoSum

Lecture 5: Inserting Functions

Lecture 6: Editing a Range

Lecture 7: Formula AutoCorrect

Lecture 8: AutoCalculate

Lecture 9: Function Compatibility

Chapter 6: Copying and Pasting Formulas

Lecture 1: Relative References and Absolute References

Lecture 2: Cutting, Copying, and Pasting Data

Lecture 3: AutoFilling Cells

Lecture 4: The Undo Button

Lecture 5: The Redo Button

Chapter 7: Columns and Rows

Lecture 1: Selecting Columns and Rows

Lecture 2: Adjusting Column Width and Row Height

Lecture 3: Hiding and Unhiding Columns and Rows

Lecture 4: Inserting and Deleting Columns and Rows

Chapter 8: Formatting Worksheets

Lecture 1: Formatting Cells

Lecture 2: The Format Cells Dialog Box

Lecture 3: Clearing All Formatting from Cells

Lecture 4: Copying All Formatting from Cells to Another Area

Chapter 9: Worksheet Tools

Lecture 1: Inserting and Deleting Worksheets

Lecture 2: Selecting Multiple Worksheets

Lecture 3: Navigating Worksheets

Lecture 4: Renaming Worksheets

Lecture 5: Coloring Worksheet Tabs

Lecture 6: Copying or Moving Worksheets

Chapter 10: Setting Worksheet Layout

Lecture 1: Using Page Break Preview

Lecture 2: Using the Page Layout View

Lecture 3: Opening the Page Setup Dialog Box

Lecture 4: Page Settings

Lecture 5: Setting Margins

Lecture 6: Creating Headers and Footers

Lecture 7: Sheet Settings

Chapter 11: Printing Worksheets

Lecture 1: Previewing and Printing Worksheets

Chapter 12: Helping Yourself

Lecture 1: Using Excel Help

Lecture 2: Microsoft Search in Excel

Lecture 3: Smart Lookup

Chapter 13: 3D Formulas

Lecture 1: Creating 3D Formulas

Lecture 2: 3D Formula Syntax

Lecture 3: Creating 3D Range References

Chapter 14: Named Ranges

Lecture 1: Naming Ranges

Lecture 2: Creating Names from Headings

Lecture 3: Moving to a Named Range

Lecture 4: Using Named Ranges in Formulas