标签：Excel function
-
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 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 non-repeating data in a column? As the answer […]
-
How to Merge the Content in Different Cells Using Excel Function
Usually we insert different kinds of data (like number and text) into different Excel columns for better recording the information and doing calculations. But sometimes we may also need to merge the content from different cells in an existing table. If there isn’t a large amount of data for us to process in the table, […]
