Essentials and Intro to Formulas and Functions
  • Introduction and the Ribbon
  • Interactive Guides
  • Navigating
  • QA Toolbar
  • More QA Toolbar Part
  • Formulas
  • Saving Files
  • Functions
  • Continued Formuli
  • Troubleshooting Issues
  • Compatibility Issues
  • Course Check List
Formatting, Spreadsheet Design, Page Setup and Printing
  • Fill Handle
  • Copying and Pasting
  • Auto-fill Series Formatting and Styles
  • Styles and Themes
  • Templates
  • Working with Worksheets
  • Copying Entire Worksheets
  • Custom View
  • Spell Check in Excel
  • Working with Large Worksheets
  • Split Screen
  • Printing
  • Page Layout View
  • Course Check List
List/Table Essentials and Charting
  • Flash Fill
  • Well Defined List
  • Sorting
  • Sort by Then
  • Formatting
  • Format as Table
  • Filtering
  • Multi-Field Filtering
  • Remove Duplicates
  • Inserting Automatic Subtotals
  • Column Line Charts
  • Pie Chart
  • Formatting Charts
  • Chart Templates
  • Recommended Charts and Quick Analysis Tools
  • Printing Charts
  • Sparklines
  • Review
  • Course Check List
Importing Data, Pivot Tables, Protecting and Linking Data
  • Importing Data from Sources
  • Importing Database File
  • Pivot Tables
  • Custom Pivot Tables
  • Advanced Pivot Tables
  • Pivot Table Exercise
  • Formatting Pivot Tables
  • Slicer Tool
  • Pivot Charts
  • Filtering Charts
  • Data Validation
  • Rules
  • Conditional Formatting
  • Advanced Conditional Formatting
  • Manage Rules of Conditional Formatting
  • Conditional Formatting Data Validation
  • Protecting Worksheets
  • Comments
  • Printing Comments
  • Linking Data Between Worksheets
  • Course Check List
Creating Functions
  • Named Ranges
  • Logical Functions
  • If Functions
  • Nested Functions
  • Lookup Functions
  • V Lookup
  • Database Function Sumif
  • Database Function Averageif
  • Database Function Sumifs
  • If Error Functions
  • V Lookup Range
  • Date Functions
  • Course Check List
Advanced Tools
  • Consolidate Data
  • Consolidate with Different Layouts
  • Intro to Goal Seek Tool
  • Goal Seek Tool
  • Installing Solver Tool Add-In
  • Solver Basic Sheet
  • The Solver Tool
  • PMT Data Table Worksheet
  • Data Table Command
  • Two Variable Data Table
  • Scenario Manager
  • Adding Developers Tab
  • Recording a Macro
  • Running Your Macro
  • Recording Macros with Relative References