Introductory Excel
  • Introduction to Excel and the Excel Layout
Financial Statement Analysis
  • Financial Statement Analysis: Projecting Revenue Increases
  • Financial Statement Analysis: Calculating Percentage Change
  • Financial Statement Analysis: Calculating Gross Profit
  • Financial Statement Analysis: Calculating Gross Margin
Hotkeys
  • Hotkeys - Creating a New Workbook
  • Hotkeys - Toggling Worksheets in a Workbook
  • Hotkeys - Sending Print Instructions
  • Hotkeys - Using the COPY and PASTE Formatting Shortcuts on Excel
  • Hotkeys - Using the CUT and PASTE Formatting Shortcuts on Excel
Functions
  • Understanding the Structure of a Function
  • Function: Using the AVERAGE function to Calculate Average Revenue
  • Function: Using the SUM Function to Add Revenues
  • Quick Quiz #2
  • Function: Using the MEDIAN Function in Excel
  • Function: Using the MIN and MAX functions to calculate ranges
  • Function: Using the ABSOLUTE VALUE Function in Excel
  • Quick Quiz #3
  • Function: Using the RANDOM Function in Excel
  • Function: Using the COUNT Function in Excel
  • Quick Quiz #1
  • Function: Using IF and THEN on Microsoft Excel
Excel Application into Advanced Business Situations
  • Advanced - Currency Exchange Rate Calculations: Using Absolute Cell Referencing
  • Advanced - Compensation Structure: Using Data to Create Sensitivity Analysis
  • Advanced - Analyzing Cost Drivers via Common-Size Income Statements in Excel
  • Advanced - Goal Seek in Basic Business Case Scenario
  • Advanced - Goal Seek in Advanced Business Case Scenario
  • Bonus Lecture - Coupon Codes