Course subjects
Lesson 1: Getting Started
TOPIC A: Getting to Know Excel
Microsoft 365 Excel
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
The Excel Interface
Navigating in Excel
Keyboard Navigation Options
TOPIC B: Creating Workbooks
The Ribbon
The Backstage View
Data Types
Excel 365 File Formats
The Save and Save As Commands
Saving to Microsoft OneDrive
Compatibility Mode
The Convert Option
The Compatibility Checker
Checking for Accessibility Issues
TOPIC C: Getting Help in Excel
Lesson 2: Working with Data
TOPIC A: A Closer Look at Formulas
TOPIC B: Using Formulas and Functions
About Functions
Creating a Function with AutoComplete
Using the Insert Function Dialog Box
Using AutoSum
Viewing AutoSum Calculations in the Status Bar
Automatic Workbook Calculations
TOPIC C: Working with Data
Selecting Cells
The Cut, Copy, and Paste Commands
Using Paste Options
Live Preview
The Transpose Option
Moving Data with Drag and Drop
The Undo and Redo Commands
Using AutoFill
Using Flash Fill
TOPIC D: Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Clearing Data from Cells
Changing Column Width and Row Height
The Hide and Unhide Options
TOPIC E: Sorting and Filtering Data
Lesson 3: Modifying a Worksheet
TOPIC A: Formatting Text
TOPIC B: Formatting Cells
Applying a Border
Applying a Fill
Changing the Number Format
Formatted Numbers and Cell Width
Customising Number Formats
TOPIC C: Aligning Cell Content
Alignment Options
The Indent Commands
The Wrap Text Command
Merge and Centre Options
TOPIC D: Search For and Replace Data
TOPIC E: Spell Check a Worksheet
Lesson 4: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
Topic Objectives
The Print Options in Backstage View
The Page Setup Dialog Box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
TOPIC B: Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Titles
Scaling Options
Lesson 5: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
Renaming Worksheet Tabs
Changing Tab Colour
TOPIC B: Manage Worksheets
Grouped Worksheets
Repositioning Worksheets
Inserting or Deleting Worksheets
Hiding and Unhiding Worksheets
Worksheet References in Formulas
TOPIC C: Manage the View of Worksheets and Workbooks
Lesson 6: Customising the Excel Environment
TOPIC A: Customise General and Language Options
TOPIC B: Customise Formula Options
TOPIC C: Customise Proofing and Save Options
The Proofing Category
The Save Category
Version Control
TOPIC D: Customise the Ribbon and Quick Access Toolbar
TOPIC E: Understanding and Enabling Add-Ins
What Are Add-ins?
The Add-Ins Category
The Developer Tab
TOPIC F: Customise Advanced and Trust Center Options