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

3D Computer Graphics ProgrammingGustavo Pezzi
Category: Others
Duration 37 hours 55 minutes 2 seconds
Course

Supercharged Code Editing with Vim and Neovimzerotomastery.io
Category: Others, VIM
Duration 2 hours 55 minutes 8 seconds
Course

Computer SystemsOz Nova (csprimer.com)
Category: Others
Duration 28 hours 15 minutes 48 seconds
Course

Prompt Engineering Bootcamp (Working With LLMs): Zero to Masteryzerotomastery.io
Category: Others
Duration 14 hours 24 minutes 46 seconds
Course

Automata Theory: inside a RegExp machineDmitry Soshnikov
Category: Others
Duration 1 hour 48 minutes 5 seconds
Course

Macroeconomics Made ClearWondrium by The Great CoursesAkila Weerapana
Category: Others
Duration 12 hours 34 minutes 14 seconds
Course

The SaaS MasterClasssaasmasterclass.io
Category: Others
Duration 6 hours 8 minutes 14 seconds
Course

Master the Pathfinding Algorithms with JavaScript and Reactzerotomastery.io
Category: Others
Duration 2 hours 30 minutes 4 seconds
Course

System Design Courseget.interviewready.io (Gaurav Sen)
Category: Others, Preparing for an interview
Duration 92 hours 26 minutes 21 seconds
Course