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