Work Faster with these Microsoft Excel Tips


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

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

New Call-to-action

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

Creative Commons License:

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?