Microsoft Excel Hot Tip - Formulas

Microsoft Excel Formulas

Formulas are a great way to quickly automate something to save time and effort.

To enter a formula to a cell, select the cell and type = before typing out the formula. 

To include another cell in the formula (after the first), either select the cell and type , before continuing the formula or type the cell name (e.g. D17). If you want to show a range, use this format: D17:D25
With this, the formula will look at all of the cells between D17 and D25 (inclusive). 

Common Formulas

SUM()

Gives the total sum of the selected range of cell values 

e.g.

AVERAGE()

Calculates the average of the selected range of cell values

e.g.

UPPER() or LOWER() or PROPER()

The UPPER() function converts any text string to uppercase. In contrast, the LOWER() function converts any text string to lowercase. 

The PROPER() function converts any text string to proper case, i.e., the first letter in each word will be in uppercase, and all the other will be in lowercase. 

e.g.

NOW()

Will always show the current date and time

TODAY()

Always shows the current date

To find how many days are between two dates, use the following formula structure =C20-B20

e.g. 

To find how many working days are between two dates, follow these steps:

• Select the cell you want the calculation in 
• Click to the Formulas tab and select Insert Function 
  
• In the pop-up box search for the function NETWORKDAYS, select and click OK 
  
• In the next pop-up, click the box next to Start_date then click the cell with your first date – repeat the same for End_date
  
• Click OK for the result
  

More Formula

https://www.simplilearn.com/tutorials/excel-tutorial/excel-formulas 

https://excelfind.com/tutorials/top-10-basic-excel-functions-and-formulas/