Work Faster with these Microsoft Excel Tips

M_Excel.png

In the information age of today, data entry and analysis is a part of almost every employees job description. Why not spend less time painstakinly inputing and computing data with these Microsoft Excel Tips.  

Original article from Better Cloud Monitor

 

"IF" Function 

The “IF” function, which checks whether a condition is met and then returns different values based on whether it’s TRUE or FALSE. 

The first is going to be the condition – this is the value that needs to be true or not, and its status is what will determine what value is returned. 

Next, in brackets, you’re going to enter the value that should be returned from the cell if the condition is met, followed by a comma, followed by the value that you want returned if the condition is false. Then you can close the parenthesis. 

Let’s look at a simple version of how this works. For example, you could use this function to organize students’ test scores by pass/fail. 

Let’s say a student passes if he scores above 50 on his exam, but fails if his score is below 50. So we’re going to say if the value of cell A1 is greater than 50, we want to return the value “Pass,” and if it is less than 50, we want it to say “Fail.” If.png

 

"SUM"

SUM can provide a handy shortcut and save you from doing math or making mistakes when working manually. However, it’s when working with large data sets that the SUM function really becomes invaluable.

All you have to do to execute a SUM in Excel is type =SUM and then an open parenthesis.Then, select the range of cells that you wish to sum, close the parentheses, and hit Enter.The cell will return the total of all the numbers in the selected cells. =sum.png

 

If you’re dealing with a large data range, highlighting data for the SUM might not be practical, so instead, just type the cell references in manually, separating them by a colon.

Percent Change

Percent Change
 

The percent change formula is used very often in Excel. For example, to calculate the Monthly Change and Total Change. percent change.png

Image from Excel-Easy.com

In a similar way, we can calculate the Total Change. This time we fix the reference to cell B2. Select cell D3 and enter the formula shown below. 

total .png

Image from Excel-Easy.com

New Call-to-action

We suggest reading: 6 Excel Tips for Clean, Concise Data

Creative Commons License: https://creativecommons.org/licenses/by-sa/2.0/legalcode

Topics: Microsoft Excel

View the original article from Better Cloud Monitor  

Have technology questions or want to learn more about how Tech Impact can help your nonprofit? Give us a call 1-888-798-1350 or browse our Technology Services For Nonprofits.


Tech Impact provides hands-on technology support to nonprofits. Learn More