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

Statistics FundamentalsLunarTech
Category: Others
Duration 2 hours 4 minutes 10 seconds
Course

Your training programs | MR ANATOLY (MEN PRO WORKOUT)Vladimir Shmondenko aka Mr Anatoly
Category: Others
Duration 32 minutes 2 seconds
Course

Systems Design Fundamentalsalgoexpert
Category: Others
Duration 10 hours 2 minutes 52 seconds
Course

Sound Design with Cubasedesigncode.io
Category: Others
Duration 1 hour 57 minutes 34 seconds
Course

Algorithms and Data StructuresOz Nova (csprimer.com)
Category: Others
Duration 26 hours 32 minutes 19 seconds
Course

Parsing AlgorithmsudemyDmitry Soshnikov
Category: Others
Duration 4 hours 27 minutes 33 seconds
Course

The Many Hidden Worlds of Quantum MechanicsWondrium by The Great CoursesSean Carroll
Category: Others
Duration 11 hours 56 minutes 32 seconds
Course

Refactoring UI - Complete Packageadamwathan
Category: Others
Duration 40 minutes 42 seconds
Book