WHAT IS THIS PROJECT?

Learn, build and reinforce your Excel skills with this hands-on project that guides you through the creation of a dynamic and multifaceted retirement planner spreadsheet-based tool!

Ideal for both intermediate and advanced users, this project combines practicality with complexity, enabling you to go beyond Excel's basic functionality to build a genuinely useful, interactive tool - a perfect way to keep those Excel muscles active and growing.

WHY IS THIS PROJECT AWESOME?

This is a portfolio project. It involves about 3 hours of lessons.

Imagine developing a robust, interactive tool that brings together the power of Excel formulas, dynamic charts, and user-driven input controls - that's exactly what you'll be doing in this course project. This isn't just about learning Excel; it's about creating a retirement planning tool that can help you start planning that early retirement you've dreamed of. 

You'll build charts and other visual elements that instantaneously update as you smoothly change inputs with slider controls and drop-down lists, reflecting the impact of different retirement ages on your projected retirement savings. But as an equally important part of the project, you'll also engineer a formula-driven calculation engine that - while unseen to the end user - forms the heartbeat of the tool.

This project isn't just a learning exercise...it's a demonstration of your prowess with Excel and an asset for your portfolio.

The skills you hone here have real-world applications, enhancing your employability in roles that require data analysis, financial planning, and spreadsheet management. So get ready for a journey that combines education with excitement and practicality, as you transform a starter file into a fully-fledged Retirement Planning Tool.

You're not just learning Excel; you're mastering it.

WHAT ARE THE PREREQUISITES?

Required:

- Intermediate knowledge of Excel. Don't have that? Take our Excel Bootcamp now!

Note: knowledge of VBA and Excel’s Business Intelligence tools (Power Query, DAX, etc.) is NOT required for this project (but you should take our VBA Programming and Excel for Business Intelligence courses to learn them anyways, because they're awesome in-demand skills that will really take you to the next level!)

WHAT TOOLS WILL BE USED?

Microsoft Excel (virtually any version will work with this project).