Example Curriculum
Introduction
Available in
days
days
after you enroll
Module 1: Excel 101
Available in
days
days
after you enroll
- Hello Excel Part 1 (10:02)
- Hello Excel Part 2 (12:10)
- Data Entry Part 1 (11:54)
- Data Entry Part 2 (10:38)
- Autofill (10:54)
- Working With Ranges (11:28)
- Working With Rows and Columns (9:40)
- Resizing Rows and Columns (9:35)
- Freezing Rows and Columns (9:47)
- Working With Multiple Worksheets (10:33)
- Find and Replace (14:01)
- Working With Multiple Workbooks (10:23)
- Intro to Formatting (4:35)
- Formatting Numbers (11:06)
- Formatting Dates and Times (11:27)
- Font Styles (11:30)
- Text Wrapping and Alignment (10:38)
- Cell Borders and Merging (9:19)
- Exercise: Excel 101
- Let's Have Some Fun (+ Free Resources)
Module 2: Filtering and Sorting Data
Available in
days
days
after you enroll
Module 3: Excel Formulas 101
Available in
days
days
after you enroll
- Intro to Formulas (8:28)
- Arithmetic Formulas (9:50)
- Applying Formulas to Text (7:48)
- Applying Formulas to Dates (9:03)
- Copying and Cutting Formulas (12:20)
- Cell References (13:36)
- Hiding Rows and Columns (2:49)
- Exercise: Formulas 101
- Budget Project: Introduction (1:52)
- Budget Project: Formulas 101 (6:21)
- Course Check-In
Module 4: Crunching Numbers With Excel Functions
Available in
days
days
after you enroll
- Intro to Excel Functions (10:45)
- Arithmetic Functions (14:36)
- Counting Functions (6:03)
- The Status Bar (2:23)
- Rounding and Truncation (9:10)
- Median (8:22)
- Standard Deviation (7:53)
- Exercise: Crunching Numbers With Excel Functions
- Budget Project: Crunching Numbers With Excel Functions (5:34)
- Implement a New Life System
Module 5: Conditional Calculations
Available in
days
days
after you enroll
Module 6: Date and Time Functions
Available in
days
days
after you enroll
Module 7: Text Functions
Available in
days
days
after you enroll
Module 8: Logical and Lookup Functions
Available in
days
days
after you enroll
Module 9: Modeling in Excel
Available in
days
days
after you enroll
Module 10: Data Visualization in Excel
Available in
days
days
after you enroll
Module 11: Working With Structured Data in Excel
Available in
days
days
after you enroll
Module 12: Pivot Tables
Available in
days
days
after you enroll
Module 13: Macros and VBA
Available in
days
days
after you enroll
Where To Go From Here?
Available in
days
days
after you enroll