Course Information
  • Screen Settings
  • Screen Settings Quiz
  • The Quizzes Are Optional
  • The Quizzes Are Optional
  • Getting Your Certificate of Completion
  • Getting Your Certificate of Completion
  • Course Files
Quick Start
  • Excel Quick Start
  • Relative References
  • Absolute References
  • Functions
  • Creating Charts
  • Calculating A Grade Example
  • Gathering Data With Google Forms
Getting Started
  • Introduction To Excel
  • Introduction To Excel
  • Writing Formulas
  • Writing Formulas
  • Formula Essentials
  • Formula Essentials
  • Relative, Absolute, & Mixed References
  • Relative, Absolute, and Mixed References
Working With Functions
  • Introduction to Functions
  • Introduction to Functions
  • Payment Function & Loans
  • Payment Function & Loans
  • Future Value Function & Pensions
  • Future Value Function & Pensions
  • VLOOKUP Function & Gradebooks
  • VLOOKUP Function & Gradebooks
  • IF, Concatenate, & Evaluation
  • IF, Concatenate, & Evaluation
  • Conditional Formatting
  • Conditional Formatting
  • IFERROR Function & Dynamic Amortization Tables
  • IFERROR Function & Dynamic Amortization Tables
Creating Charts & Graphs
  • Visually Representing Data
  • Visually Representing Data
  • Creating Charts
  • Creating Charts
  • Formatting Charts
  • Formatting Charts
  • Scatter Charts
  • Scatter Charts
  • Combo Charts
  • Combo Charts
  • Pivot Charts
  • Pivot Charts
Harvesting Data From The Web
  • Finding Data
  • Finding Data
  • Copying Data From The Web
  • Copying Data From The Web
  • Transposing Data
  • Transposing Data
  • Copying Data From The Web II
  • Copying Data From The Web II
  • Parsing Data
  • Parsing Data
  • Web Scraping Software
  • Web Scraping Software
Manipulating Data
  • Freeze Panes
  • Freeze Panes
  • Filtering Data
  • Filtering Data
  • Removing Duplicates
  • Removing Duplicates
  • Sorting Data
  • Sorting Data
  • Subtotaling Data
  • Subtotaling Data
  • Data Tables
  • Data Tables
Advanced Filtering
  • Exploring The Find Function
  • Exploring The Find Function
  • Exploring Filters Further
  • Exploring Filters Further
  • The Advanced Filter
  • The Advanced Filter
  • The Find Function II
  • The Find Function II
Going Pro With Pivot Tables
  • Introduction to Pivot Tables
  • Introduction to Pivot Tables
  • Creating a Pivot Table
  • Creating a Pivot Table
  • Exploring Pivot Tables
  • Exploring Pivot Tables
  • Recommended Pivot Tables
  • Recommended Pivot Tables
  • Grouping in Pivot Tables
  • Grouping in Pivot Tables
  • Using "Slicers" in Pivot Tables