Microsoft Excel Basement Reno Project P2
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.80 GB | Duration: 1h 21m
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.80 GB | Duration: 1h 21m
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.