标签：formula

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 the Data in the Same Cell with Excel Formula
Normally we use Excel formulas to calculate the data from different cells, but in some cases we may enter mulitple numbers with operational symbols in the same cell and want to calculate the result, can we still use formula to work it out? Look at this table, There are multiple numbers and operation symbols in […]

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 Quick Capitalize the First Letter or Each Word in Excel
When entering some specific information like company names or employee names into an Excel sheet, you may want to capitalize the first letter of each word in each cell. But instead of changing the text case one by one, can you do it in batch? 1. First of all, you can create a new column […]

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 […]

How to Multiply Numbers in Microsoft Excel Quickly
Multiplication and division are very common in mathematics as well as in Excel calculations. To multiply numbers in Excel, there’re 2 simple ways you can try. I’ll share the detailed steps in this post. Method 1: Using Formula to Multiply 1. Click the cell for outputting the calculation result. 2. Input the formula directly: =A2*B2 […]

How to Highlight All the Nonworking Days in Excel Spreadsheet
If you entered a series of dates into Excel spreadsheet, and want to highlight all the nonworking days. Do you have to pick out the weekends manually? In my previous post, I’ve introduced some uses of the powerful Conditional Formatting. It enables you to apply a format to multiple cells that meet the specific criteria. […]

How to Sum Multiple Excel Tables Across Sheets
It’s common to input data in different Excel spreadsheets by different people and sum them later. But as you know, if you copy a column of data and copy them into another table, the existing data will be overwritten. Is there a way to sum the data across multiple Excel tables in different sheets? How […]