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

Lead Generation for SAAS

Lead Generation for SAASProdigies University

Category: Others
Duration 1 hour 10 minutes 34 seconds
Master System Design and Design Pattern

Master System Design and Design Patternudemy

Category: Others
Duration 11 hours 33 minutes 6 seconds
Communication Masterclass 2.0

Communication Masterclass 2.0Ganesh Prasad

Category: Others
Duration 11 hours 49 minutes 3 seconds
Master Gorgeous UI Design

Master Gorgeous UI Designtogether.art (Pablo Stanley)

Category: Others
Duration 10 hours 56 minutes 16 seconds
NativeScript + Angular: Build Native iOS, Android & Web Apps

NativeScript + Angular: Build Native iOS, Android & Web Appsudemy

Category: Angular, Others, NativeScript
Duration 20 hours 11 minutes 23 seconds
OpenSSL Training

OpenSSL TrainingPractical Networking (practicalnetworking.net)

Category: Others
Duration 1 hour 46 minutes 2 seconds
Systems Design Fundamentals

Systems Design Fundamentalsalgoexpert

Category: Others
Duration 10 hours 2 minutes 52 seconds