标签：formula

How to Process Data with Units Using Functions in Excel
Some people tend to input the data with units into Excel spreadsheet considering it will be more clear and intuitive. But unfortunately, the data with manually entered units can’t be calculated correctly with Excel functions. It means you can only do the summation or subtraction manually as well. To avoid this situation and use functions […]

25 Microsoft Excel Tips for Beginners Who Work at Office
For an office worker, it’s very important to grasp some commonly used Excel skills to process the data in a spreadsheet. Only in this way they can save the time to do more constructive work and improve themselves. So, how to use Microsoft Excel smartly to boost the working efficiency? In this post I collected […]

How to Count the Non Repeating Data in MS Excel
Sometimes you want to count a long list of data in Excel, but there are many duplicates interfering with your statistics, and you can’t just delete them. At this point, is there a way to get rid of the influence of repeated data and count only the nonrepeating data in a column? As the answer […]

5 Cases to Use Microsoft Excel IF Function in Practice
IF function, also known as conditional function, enables you to get corresponding results in Microsoft Excel spreadsheets when meeting the specific conditions. How Does IF Function Work The function syntax of IF function is: IF(logical_test,[value_if_true],[value_if_false]). If the specified conditions evaluate to true, this function will return a value; If the specified conditions evaluate to false, […]

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data
VLOOKUP is a very useful Excel function which can easily search through a column and find the corresponding data. For example, you can search for the score of a student in class quickly according to his or her name. The basic formula for VLOOKUP is: =VLOOKUP (lookup_value,table_array,col_index_num,range_lookup) “lookup_value” refers to the keyword for searching; “table_array” […]

How to Insert a Random Number in Excel
Random numbers are quite useful in many situations of life and work. And it’s very simple to generate them with Excel function. Here’s the method. 1. Open the Excel file, click a cell and type the formula in it. If you want to generate a number in the range of 1100, then input “=RANDBETWEEN(1,100)” . […]

How to Copy Excel Formulas to Multiple Cells or Entire Column
If you have tons of data to deal with in a spreadsheet, it’s much more convenient to use Excel functions instead of manual calculations. But inputting formulas in each cell can also take a lot of time. Is there a way to enter it just once and apply the formula to multiple cells within seconds? […]