Tags：Excel function

How to Calculate Ages from Birthdate Automatically in Excel
You may already know how to do simple calculations like summating and averaging in Excel. In fact, you can also use Excel formulas to solve some more practical problems. For example, if you’re registering the employees’ ages, but the only data you got are their birthdates, can you calculate their ages using Excel formula? The […]

How to Automatically Record the Data Entry Time in Excel
When making some financial or warehouse forms in Excel, we often need to record the time of entering different batches of data separately. And it can be very timeconsuming if we do it manually. So, is there a way to record the data entry time in Excel automatically? Like the answer to many other questions, […]

How to Calculate the Average Value of Data with Excel Function
Calculating the average value is a very common way to analyze data in Excel. To do the computations accurately and also rapidly, you can use Excel function to calculate mulitple, or even an entire column of data. Here’s the basic approach to use AVERAGE functin. 1. Select the E2 cell, Click Formulas – AutoSum – […]

How to Do Calculations with Power Function in Microsoft Excel
Other than addition, subtraction, multiplication and division, sometimes you may also need to calculate the third power or fifth power of the data in Excel spreadsheet. How will you do this kind of calculation? Using your calculator may be an answer, but not the best idea. If there are tons of data for you to […]

How to Create an Uninterrupted Sequence in Microsoft Excel
When inserting or deleting some rows to Excel spreadsheet, the sequence number will be interrupted and become incoherent, which could also affect your counting. In fact, you can use a very simple Excel formula to create an uninterrupted sequence in a column. 1. Enter the formula: =ROW()1 in the first cell of the sequence column. […]

How to Calculate the Time Difference Quickly Using Excel Functions
In practice, we often need to calculate the difference of years, months, weeks or days between 2 separate dates. And like many other calculations, Excel functions can help you calculate the time difference quickly and accurately. Let’s see how to do it. Case 1: Calculate the Difference of Years Formula: =DATEDIF(A2,B2,”y”) A2, B2 corresponds to […]

How to Calculate the Absolute Value with ABS Function in Excel
Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds. 1. Create a new column to output the […]

How to Calculate Running Total with Functions in Microsoft Excel
When processing data in Excel, there’s a chance that you need to do a running total for a series of numbers. If the data base is huge, it may not be the best idea to do the operation line after line, you can actually calculate the cumulative total with SUM function quickly. For Vertical Spreadsheet […]

How to Quickly Divide Numbers in Excel Cells Using Formula
Division, like multiplication, is a common operation in mathematics. And in practical work, you also need to do division sometimes when processing data in Excel. To divide numbers quickly and correctly, the quickest way is undoubtedly using Excel formula. Here’s a simple guide. 1. Create a new column to output the calculation result. 2. Enter […]

How to Sort Excel Cells by the Number of Characters
If most of the data in an Excel spreadsheet is text, and each cell has a different length of content, it may look untidy on the whole. For this situation, you can sort these cells by the number of characters. But as you know, there’s no such an existing sorting rule to use directly. Before […]