Microsoft Excel Basement Reno Project P2

When it comes to managing a basement renovation project, staying organized is key. Using Excel to track all aspects of the project—from budgeting to progress updates—helps ensure everything is on track and stays within budget. Here’s how I structured the basement renovation project and how Excel became an essential tool for keeping things organized.

We will track the materials needed for each basement section.  We have two bedrooms, a bathroom, a common hallway area, and a combo kitchen/dining/living area.  Each area will have a list of materials for renovation and products for decorating the area, with respective labor cost for each area.  The dates listed are for reference of when the project costs was retrieved and can be updated to when the project has actually been completed.  It is your choice. 

1. Welcome

2. P2.1 - Adding Images and using the Picture Menu.  Defining cells by naming them.

3. P2.2 - Hyperlinking Product Descriptions.  Total Row and its usage.

4. P2.3 - Filter Functionality - By Color.  Color coding cells.  Multiple filtering.

5. P2.4 - Color Picker (Choosing Custom Colors).  Summary Totals:  Copying IFSUM Formula and updating with custom cell names.

6. P2.5 - Summary Totals: Continuation of creating formulas for the top summary portion (Cost of Remodel and Projected Value Increase).