• views: 90
• date: 17 March 2025
• posted by: voska89

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/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.