Introduction
  • Welcome!
  • IMPORTANT NOTE: Excel Versions
  • Introduction Outline
  • Opening Excel and Creating a New Excel Workbook
  • Workbooks and Worksheets
  • The Excel Ribbon Interface
  • Saving Your Work in Excel
  • Introduction Section Quiz
Functions and Cell References
  • Functions and Cell References Outline
  • 12 Essential Functions Every User Should Know!
  • Sample Sales Dataset
  • Inputting Data and a Basic Formula
  • The SUM, AVERAGE, and COUNT Functions
  • Notes on SUM, AVERAGE, and COUNT
  • MAX and MIN Functions and Status Bar Statistics
  • Cell References (Relative and Absolute References)
  • Section 2 Quiz
  • Section 2 Exercise
Working with Dates, Counts, and Visualizations
  • Working with Dates, Counts, and Visualizations Outline
  • Patient Dataset
  • How Excel Handles Dates
  • Date-Related Functions (WEEKDAY, DAYS, TODAY, and NOW)
  • COUNTIF, COUNTIFS, and SUMIF
  • Section 3 Quiz 1
  • Ice Cream Sales Dataset
  • Scatterplots
  • Bar (Column) Plots
  • Visualization in Excel: 3 Tips You Should Know
  • Section 3 Quiz 2
  • Section 3 Exercises
IF Statements, VLOOKUPs, and PivotTables
  • IF Statements, VLOOKUPs, and PivotTables Outline
  • Employee Dataset
  • Flash Fill
  • IF Statements
  • Section 4 Quiz 1
  • The VLOOKUP Function
  • VLOOKUP
  • PivotTables
  • Section 4 Quiz 2
  • Section 4 Exercise
Thank You
  • Thank You