Tutorials > Udemy – Microsoft Excel Basement Reno Project P2

Udemy – Microsoft Excel Basement Reno Project P2


Date: 17 March 2025 | Posted by: voska89
Udemy – Microsoft Excel Basement Reno Project P2

Free Download Udemy – 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
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

Description

s. 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.

Homepage: 
https://www.udemy.com/course/microsoft-excel-basement-reno-project-p2/






DOWNLOAD LINK



No Password - Links are Interchangeable

See full article