标签:Excel
-
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 Quickly Enter a Long Number with Multiple Zeroes in Excel
When making the table about financial capital in Excel, we often enter some long numbers such as amount ninety thousand, fifty million or others contain more zeroes. They might make give you a headache and it is also very easy to cause input problems. So how can we quickly enter a long number with multiple […]
-
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 Customize and Unify the Date Format in Excel Quickly
It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]
-
How to Add a Drop-down List in Excel
You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel. 1. Select the cell you want to add drop-down menu. Click Data Validation in Data […]
-
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 […]
-
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 […]
-
How to Use Function Keys F1 to F12 in Windows and Office
You may already know pressing [F5] key in Windows system can refresh the current page, and pressing [F11] can enable the full screen mode. But do you know the specific functions of all the keys from F1~F12? They do have different functions in Windows system (like the desktop, system folders, browsers, etc.) and Microsoft Office […]
-
How to Sort Data by Multiple Columns in Microsoft Excel
An Excel spreadsheet is often composed of multiple columns with various data, and they are all related in some way. You probably need to take more than one columns into consideration while sorting. So how to do it? The Sort feature in Excel allows you to add multiple levels as the criteria to sort the […]