Introduction
  • Introduction
  • Navigating Excel
Excel Functions
  • Case Study 1: Barney's Investment Management Firm
  • Formulas 101
  • Basic Formulas
  • Transposition
  • Absolute Verse Relative
Data Analysis
  • Case Study 2: Wood Floors Depot
  • Manipulating Data
  • If Analysis
  • Vlookup
  • Custom Inputs
  • Pivot Tables
Use Excel For
  • Use Excel For..
  • Excel For Finance Data Set
  • Excel for Finance
  • Excel for Marketing Data Set
  • Excel for Marketing
  • Spreadsheet Download: Accounting
  • Excel for Accounting
Workpaper Preparation
  • Case Study 3: Wood Floors Depot Part 2
  • Secret for Success
  • Formatting
  • Labeling
  • Referencing
  • Conditional Formatting
Course Wrap Up
  • Spreadsheet Download: Excel Hacks
  • Excel Hacks
  • Conclusion
Take Action!
  • Translating your skills to real life