Excel Basics
  • Intro to Excel Tutorial
  • How to Configure Excel
  • How to Design and Format an Excel Spreadsheet
  • Sorting and Filtering Data in Excel
  • Text Formatting
  • Connecting Text Columns in Excel
  • Managing Tabs
  • How to Pull Data from Tabs in Excel
  • How to Use the Format Painter
  • How to Freeze the Top Row in Excel
  • How to Add a Header and Footer
  • How to Print an Excel Spreadsheet on One Page
Intermediate Excel Techniques
  • Excel Tips, Tricks and Shortcuts
  • How to Use Math Formulas
  • How to Use Formulas - Creating Sums
  • How to Create Tables Automatically in Excel
  • How to Round in Excel
  • How to Calculate Averages
  • How to Calculate Ages
  • How to Use Themes
  • Splitting Text Fields in Excel Automatically
Advanced Excel Techniques
  • How to Add and Manage Sparklines
  • How to Use Conditional Formatting
  • How to Use the Count Formula
  • How to Use If Then Statements
  • How to Add and Design Charts
  • Adding Comments
  • How to Create Financial Scenarios
  • How to Add SmartArt
  • How to Pull in Data from a Website into an Excel Spreadsheet
  • How to Create and Customize Pivot Tables