Create a Retirement Planning Tool with Excel
2h 51m 33s
English
Paid
In this project-based course you'll be developing a robust, interactive tool that brings together the power of Excel formulas, dynamic charts, user-driven input controls, and more!
Read more about the course
This isn't just any Excel practice project - it's a true portfolio project that teaches you how to build a robust, interactive tool that brings together your Excel skills into one comprehensive project!
Watch Online Create a Retirement Planning Tool with Excel
Join premium to watch
Go to premium
# | Title | Duration |
---|---|---|
1 | Project Demo | 05:25 |
2 | Introducing the Project Template | 02:48 |
3 | Applying Number Formats | 02:54 |
4 | Solution: Applying Number Formats | 02:06 |
5 | Creating Drop Down Lists | 01:41 |
6 | Solution: Creating Drop Down Lists | 03:38 |
7 | Creating the Retirement Age Slider | 02:37 |
8 | Solution: Creating the Retirement Age Slider | 04:25 |
9 | Applying Cell Styles | 04:12 |
10 | Solution: Applying Cell Styles | 03:09 |
11 | Defining Names | 03:25 |
12 | Solution: Defining Names | 03:43 |
13 | Fetching the Investment Return | 03:44 |
14 | Solution: Fetching the Investment Return | 05:23 |
15 | Plan Year and Age | 03:35 |
16 | Solution: Plan Year and Age | 02:11 |
17 | Working Income | 03:30 |
18 | Solution: Working Income | 03:39 |
19 | Income Tax and Yearly Expenditures | 02:01 |
20 | Solution: Income Tax and Yearly Expenditures | 02:51 |
21 | Yearly Savings | 01:21 |
22 | Solution: Yearly Savings | 02:33 |
23 | Earned Interest and Retirement Savings Balance | 02:26 |
24 | Solution: Earned Interest and Retirement Savings Balance | 02:25 |
25 | Earned Interest and Retirement Savings Balance II | 04:22 |
26 | Solution: Earned Interest and Retirement Savings Balance II | 05:07 |
27 | Wrapping Up the Calculations Worksheet | 04:45 |
28 | Solution: Wrapping Up the Calculations Worksheet | 05:41 |
29 | Retirement Age and Years Calcs | 03:43 |
30 | Solution: Retirement Age and Years Calcs | 02:50 |
31 | The Banner Message | 05:32 |
32 | Solution: The Banner Message | 04:24 |
33 | The Retirement Balance Chart | 01:52 |
34 | Solution: The Retirement Balance Chart | 04:57 |
35 | Dynamic Charts with OFFSET I | 08:36 |
36 | Dynamic Charts with OFFSET II | 14:29 |
37 | Solution: Dynamic Charts with OFFSET | 08:44 |
38 | Formatting the Retirement Balance Chart | 03:21 |
39 | Solution: Formatting the Retirement Balance Chart | 03:32 |
40 | The Detail Worksheet | 04:47 |
41 | Solution: The Detail Worksheet | 08:08 |
42 | The End (a.k.a. Retirement) | 01:01 |
Similar courses to Create a Retirement Planning Tool with Excel

Computer NetworkingOz Nova (csprimer.com)
Category: Others
Duration 23 hours 58 minutes 29 seconds
Course

Grow From Mid-Level To Senior Engineer: L4 To L5Alex Chiou
Category: Others
Duration 3 hours 50 seconds
Course

Modular Monolith ArchitectureMilan Jovanović
Category: Others
Duration 12 hours 48 minutes 50 seconds
Course

How to Build a Micro SaaS That Makes Money & Earns Recurring RevenueJamie Tam
Category: Others
Duration 7 hours 13 minutes 56 seconds
Course

LLM Engineer's HandbookPaul IusztinMaxime Labonne
Category: Others
Duration
Book

Lead Generation for SAASProdigies University
Category: Others
Duration 1 hour 10 minutes 34 seconds
Course

AI For Developers With GitHub Copilot, Cursor AI & ChatGPTAcademind Pro
Category: Others
Duration 4 hours 47 minutes 8 seconds
Course

SAAS Web DevelopmentProdigies University
Category: Others
Duration 43 hours 32 minutes 12 seconds
Course

Fundamentals of Operating Systemsudemy
Category: Others
Duration 21 hours 41 minutes 1 second
Course