Basic to Advanced
Program Contents/Module Titles
A series of 50 downloadable tutorials, with workbooks, program guides, keyboard shortcuts and practice file.
You can work through each Level and Module according to the sequence below, or just run the module for a particular topic you would like to learn about.
Level 1 Modules:
- Terminology & Navigation
- The File Tab
- The QAT
- Right Click Formatting
- Entering & Editing Data
- Autofill
- Selecting Multiple Cells
- Core Keyboard Shortcuts
- Working with Rows and Columns
- Working with Worksheets
- Saving Files
- Formatting Basics
- Formula Basics
- Function Basics
- Database Basics
Level 2 Modules
- Charts & Graphs
- Conditional Formatting
- Custom Autofill Lists
- Formula Auditing
- Insert Function
- Printing
- Text Functions
- Paste Special
- Range Names
- Subtotals
Level 3 Modules:
- Options
- Worksheet Grouping
- Dates & Times
- Linking in Excel
- Linking to PowerPoint/Word
- Data Validation
- Functions – IF and DATES
- Functions – IF, AND, Nesting
- Functions – VLOOKUP
- Protection & Security
- Pivot Tables – Introduction
- What If – Scenario Manager
- What If – Goal Seek
- Macros — Introduction
Level 4 Modules:
- Pivot Table Basics
- Pivot Table Layout Options
- Pivot Table Summary Functions
- Pivot Table Report/Page Filters
- Pivot Table Slicers
- Updating Pivot Table Data
- Pivot Charts
- Macro Recording
- Macro Editing
- Macro Buttons