Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Create a Retirement Planning Tool with Excel
Introduction
Project Demo (5:24)
Project FAQ
Project Resources + An Important Note!
Exercise: Meet Your Classmates and Instructor
Set Your Learning Streak Goal
Time To Build!
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?
Review This Project!
Solution: Fetching the Investment Return
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures