Categories：Excel Tips
-
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 time-consuming 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 Copy a Table from Microsoft Word to Excel Perfectly
Copying a ready-made Word table to Excel may lead to some unexpected mistakes and takes a lot of your time to re-edit it. So is there a way to perfectly copy Word tables to Excel without splitting cells nor disturbing the order? 1. As an example, I open a new document in Word and create a […]
-
How to Capture a Screenshot with Microsoft Office Apps
Addition to those screenshot tools on the market, do you know Microsoft Office itself has the function of capturing pictures? No matter in Word, Excel or PowerPoint, you can always find the “Screenshot” button. 1. Go to Insert tab and click Screenshot. 2. There are 2 modes of capturing pictures. In Available Windows you can see […]
-
How to Merge Existing Cells in Excel Spreadsheet
When editing a spreadsheet in Excel, a wide header which takes up the width of several cells is often needed. In practice, we often merge some existing cells to fulfill this kind of demand. Let’s see the detailed steps. 1. Select the range of cells you want to merge. Please note that they must be […]
-
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 Insert a Line Chart in Excel to Show the Data Changes
If you need to make a chart reflecting the changes in specific data, line chart is a good choice. In this post I’ll introduce the way to insert a line chart in Excel. Here’s a table records the incomes of A and B from January to December. 1. Now I want to make a line […]
-
How to Add or Remove Cell Borders in Excel
To add or remove cell borders in Excel, the quickest way is using shortcuts in your keyboad. Try following steps: Add Cell Borders in Excel 1. Select the cell or the range of cells you want to add borders. 2. Then press [Ctrl]+ [Shift] +[&] in your keyboard. 3. Now you can see the borders […]
-
How to Round Numbers Up or Down in Microsoft Excel
In the actual mathematical operations especiall financial calculations, you may often encounter the problem of rounding numbers. Although Excel allows you to define the decimal places in cells, the number itself is not really rounded. It could lead to some minor errors in financial operations. So is there any really easy way to round the […]
