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
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 |
Comments
0 commentsSimilar courses
The SaaS Launchpad
Sources: Rob Walling
The SaaS Launchpad - everything you need for a successful launch of your SaaS project. This course is a step-by-step guide from entrepreneur, author, and...
9 hours 59 minutes 36 seconds
The Software Designer Mindset (COMPLETE)
Sources: ArjanCodes
"The Software Designer Mindset" is a course that teaches all aspects of software architecture and offers practical advice on creating scalable software...
14 hours 32 minutes 58 seconds
Smart Interface Design Patterns
Sources: Vitaly Friedman, smashingmagazine.com
Master essential design patterns for modern interfaces. Learn best practices through examples and live projects to tackle real-life challenges effectively.
13 hours 18 minutes 5 seconds
AlgoExpert | Become an Algorithms Expert
Sources: algoexpert
Become an Expert in Algorithms. 65 videos explaining popular interview questions with solutions in JavaScript, Python, C ++, Java, and Go. Practice with popular questions. Topic...
116 hours 40 minutes 8 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...
Want to join the conversation?
Sign in to comment