Categories：Excel Tips
-
How to Use the Choose Function in Excel?
Powerful Excel functions can always save us much time, in our today’s tutorial, we are going to learn a new Excel function—the CHOOSE function. The Excel CHOOSE function returns a value from a list using a given position or index. Syntax: Choose (index_num, value1, [value2], …) index_num: The value to choose. A number between 1 […]
-
How to Add Borders Automatically to Cells in Excel?
We usually add borders to cells by clicking on the borders button. Have you ever tried to add borders automatically on your worksheet while you are entering values in a cell? This trick can improve your work efficacy and funny. Let’s check this out. Select the area where we need it and go to the […]
-
How to remove all hyperlinks in Excel?
In our today’s tutorial, we’ll learn how to remove multiple hyperlinks from an Excel worksheet at the same time. If we want to remove hyperlinks but keep the text. We can select all the links and right-click to choose Remove Hyperlink in the list. Or we can highlight the hyperlinks area and click on Remove […]
-
How To Use Advanced Filters In Microsoft Excel
When we talk about the filters in Excel, many people know that it can quickly find information or data that fits certain criteria in the clutter. In addition to the filter, there is a feature called an advanced filter. Someone may not have used it, but what does this advanced filter do? In our today’s […]
-
How To Create Dynamic Table in Excel
We’ve known how to create a dynamic graph in Excel. In our today’s tutorial, we are going to know how to create a dynamic table in Excel. Here is a fruit sale table from Monday to Friday. We first select the table area and press Ctrl + T to create the table dialog box. Go […]
-
How to Prevent Duplicate Entries in Excel?
Duplicates would be one of the reasons for wrong data entry. So, how should we prevent duplicate entries in Excel when entering data? Let’s take an example. Here is a school report. Now we need to prevent duplicate names in the Name column. Highlight the name column and go to the Data tab. Choose Custom […]
-
How to Compare Two tables in Excel
We have learned a tutorial on how to compare two Excel worksheets side by side. But if we want to compare two tables in Excel, I mean the two tables are in one Excel worksheet, is there a fast and simple method? There is. Let’s pick a simple example. Here are two monthly test reports […]
-
How to Batch Add Units to Cells in Excel
There is a list of numbers, and you need to add units to each cell. Will you add these units one by one? However, if there are too many cells, the manual method will be cumbersome. Now, we are going to learn a trick to batch add units to cells. Let’s take “kg” as an […]
-
How to Use the YEARFRAC Function in Excel?
How time flies. Do you know how long has 2022 passed? There is a built-in function in Excel called the YEARFRAC function. so, let’s explain how to use the Excel YEARFRAC function. Syntax =YEARFRAC (start_date, end_date, [basis]) start_date: This is the start of the period. It should be entered as a serial date, not a […]
-
How to Show Duplicates in Excel?
Sometimes we want to count the times of repeated data in Excel. So, we need to show duplicates in Excel, and quickly find duplicates in Excel, not remove them. Do you know how to quickly show duplicates in Excel? Let’s take an example. Here is a list of names in column A. We can use […]
