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

Advanced SAAS Sales Course

Advanced SAAS Sales Course

Sources: Prodigies University
A sales system for high-quality products for your SAAS project or business. Learn how to effectively sell expensive products and services using...
1 hour 31 minutes 8 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
Microservices: Clean Architecture, DDD, SAGA, Outbox & Kafka

Microservices: Clean Architecture, DDD, SAGA, Outbox & Kafka

Sources: udemy
Hi there! My name is Ali Gelenler. I'm here to help you learn microservices architecture while applying Clean and Hexagonal Architectures and using Domain Drive
18 hours 2 minutes 34 seconds
Decision Making & Principles

Decision Making & Principles

Sources: Logic Room
"Principles and Methods of Decision Making for Lead Engineers" is an advanced course for developers aiming to enhance their skills in team collaboration...
1 hour 13 minutes 30 seconds
Bug Bounty - An Advanced Guide to Finding Good Bugs

Bug Bounty - An Advanced Guide to Finding Good Bugs

Sources: udemy
Bug bounties are evolving year after year and thousands of infosec enthuasiasts are looking to join the boat. Having a great place on that boat requires dedicat
10 hours 26 seconds