Create a Retirement Planning Tool with Excel

Name: Create a Retirement Planning Tool with Excel
Price: 9 USD
Availability: InStock

2h 51m 33s

English

Paid

May 23, 2024

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!

Watch Online

0:00

#1: Project Demo

All Course Lessons (42)

#	Lesson Title	Duration
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?

Similar courses

Learning to Learn [Efficient Learning]: Zero to Mastery

Sources: zerotomastery.io

Become an Efficient Learner that is able to outperform others by using the strategies and techniques developed by the world's top performers and using the lates

5 hours 7 minutes 28 seconds

100 MENTAL MODELS & THINK BETTER

Sources: Wisdom Theory

100 Mental Models & Think Better. This book series is a true navigator in the world of thinking. It offers 200 powerful mental models borrowed from...

38 hours 58 minutes 27 seconds

How to Build a Micro SaaS That Makes Money & Earns Recurring Revenue

Sources: Jamie Tam

his step-by-step academy shows you how to build, scale, and profit from your own micro software as a service (SaaS) product with no funding needed. So you can achieve financial...

7 hours 13 minutes 56 seconds

How to Open Source: The missing open source handbook for new contributors

Sources: Richard Schneeman

Contributing to open source can be scary, but it doesn't have to be. This is the missing handbook that will guide you from making your first contribution to building a sustainab...

Computer Systems

Sources: Oz Nova (csprimer.com)

As software engineers, we study computer systems (or computer architecture) to understand how our programs ultimately work and how...

28 hours 15 minutes 48 seconds