Create a Retirement Planning Tool with Excel

2h 51m 33s
English
Paid

Course description

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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 42 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Project Demo

All Course Lessons (42)

#Lesson TitleDurationAccess
1
Project Demo 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

Unlock unlimited learning

Get instant access to all 41 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

ZTM Campus Event Recordings

ZTM Campus Event Recordings

Sources: zerotomastery.io
While it's always best to attend an event live so that you can ask your own questions and engage with instructors and students, we do record some events held...
17 hours 29 minutes 37 seconds
Modular Monolith Architecture

Modular Monolith Architecture

Sources: Milan Jovanović
This in-depth course will transform the way you build modern systems. You will learn the best practices for applying the Modular Monolith architecture in a real-world scenario. ...
12 hours 48 minutes 50 seconds
Statistics Fundamentals

Statistics Fundamentals

Sources: LunarTech
Master statistics for data-driven careers. Build a strong statistical foundation for data science, analysis, and decision making.
2 hours 4 minutes 10 seconds
Lightspeed Deployments

Lightspeed Deployments

Sources: newline (ex fullstack.io)
This workshop is a continuation of the courses "Overnight Fullstack Applications" and "How To Connect, Code & Debug Supabase With Bolt." In the recording of...
16 minutes 45 seconds