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: Dynamic Array Functions in Excel
Available in
days
days
after you enroll
- Section Resources
- SEQUENCE (13:29)
- SORT (11:02)
- UNIQUE (7:32)
- CHOOSECOLS (8:55)
- FILTER I (13:51)
- Combining FILTER, CHOOSECOLS and SORT (12:59)
- FILTER II (13:25)
- FILTER III (11:02)
- Refactoring with Tables (12:44)
- Refactoring with LET (12:57)
- Project 1 - Introduction (3:48)
- Project 1 - Solution (8:55)
- Combining FILTER, UNIQUE and SORT (8:02)
- Referencing Dynamic Arrays I (10:02)
- Referencing Dynamic Arrays II (11:40)
- Creating Dynamic Drop - Down Lists (8:28)
- Project 2 - Introduction (3:47)
- Project 2 - Solution (11:34)
- GROUPBY - Part 1 (12:36)
- GROUPBY - Part 2 (14:03)
- GROUPBY - Part 3 (6:35)
- PIVOTBY (14:50)
- Project 3 - Introduction (9:21)
- Project 3 - Solution (12:07)
Module 14: Macros and VBA
Available in
days
days
after you enroll
Capstone Project: Build a Retirement Planner with Excel
Available in
days
days
after you enroll
- Capstone Project Demo (5:24)
- Capstone Project Resources + An Important Note!
- Introducing the Project Template (2:47)
- Applying Number Formats (2:53)
- Solution: Applying Number Formats (2:05)
- Creating Drop Down Lists (1:40)
- Solution: Creating Drop Down Lists (3:37)
- Creating the Retirement Age Slider (2:36)
- Solution: Creating the Retirement Age Slider (4:24)
- Applying Cell Styles (4:11)
- Solution: Applying Cell Styles (3:08)
- Defining Names (3:24)
- Solution: Defining Names (3:42)
- Fetching the Investment Return (3:43)
- Solution: Fetching the Investment Return (5:22)
- Plan Year and Age (3:34)
- Solution: Plan Year and Age (2:10)
- Working Income (3:29)
- Solution: Working Income (3:38)
- Income Tax and Yearly Expenditures (2:00)
- Solution: Income Tax and Yearly Expenditures (2:50)
- Yearly Savings (1:20)
- Solution: Yearly Savings (2:32)
- Earned Interest and Retirement Savings Balance (2:25)
- Solution: Earned Interest and Retirement Savings Balance (2:24)
- Earned Interest and Retirement Savings Balance II (4:21)
- Solution: Earned Interest and Retirement Savings Balance II (5:06)
- Wrapping Up the Calculations Worksheet (4:44)
- Solution: Wrapping Up the Calculations Worksheet (5:40)
- Retirement Age and Years Calcs (3:42)
- Solution: Retirement Age and Years Calcs (2:49)
- The Banner Message (5:31)
- Solution: The Banner Message (4:23)
- The Retirement Balance Chart (1:51)
- Solution: The Retirement Balance Chart (4:56)
- Dynamic Charts with OFFSET I (8:35)
- Dynamic Charts with OFFSET II (14:28)
- Solution: Dynamic Charts with OFFSET (8:43)
- Formatting the Retirement Balance Chart (3:20)
- Solution: Formatting the Retirement Balance Chart (3:31)
- The Detail Worksheet (4:46)
- Solution: The Detail Worksheet (8:07)
- The End (a.k.a. Retirement) (1:00)
Where To Go From Here?
Available in
days
days
after you enroll