Microsoft Excel Basement Reno Project P2

Part 2

What you'll learn

Managing Tables

Formulas

Hyperlink

Drop Down Menu

Requirements

For Beginners and Intermediate to Follow Along

Description

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.  WelcomeP2.1 - Adding Images and using the Picture Menu.  Defining cells by naming them.P2.2 - Hyperlinking Product Descriptions.  Total Row and its usage.P2.3 - Filter Functionality - By Color.  Color coding cells.  Multiple filtering.P2.4 - Color Picker (Choosing Custom Colors).  Summary Totals:  Copying IFSUM Formula and updating with custom cell names.P2.5 - Summary Totals: Continuation of creating formulas for the top summary portion (Cost of Remodel and Projected Value Increase).

Overview

Section 1: Welcome

Lecture 1 Welcome - Course Overview

Section 2: Basement Remodel P2.1

Lecture 2 Basement Remodel P2.1

Section 3: Basement Remodel P2.2

Lecture 3 Basement Remodel P2.2

Section 4: Basement Remodel P2.3

Lecture 4 Basement Remodel P2.3

Section 5: Basement Remodel P2.4

Lecture 5 Basement Remodel P2.4

Section 6: Basement Remodel P2.5

Lecture 6 Basement Remodel P2.5

Anyone who wants to keep track of their remodeling costs.