Categories：Excel Tips
-
Four Ways To Extract Unique Values In Excel
Today, we are going to learn four tips to extract unique values in Excel, or you can think of this as removing repeating data. Let’s get started. The following list contains many recurring names. Now, we are going to extract all the non-repeating names from it. No.1 Advanced Filter Select the name area and go […]
-
How To Use The FIND Function In Excel (Easy Understanding)
The FIND function can find a specified text string and return number that represents the starting position of the string. Syntax =FIND(find-text, within-text, [start-num]) Find-text: It means the text or string that you want to find. Within-text: It means the text within which you want to find the find-text argument. Start-num: it means the position […]
-
How to Use the RANDBETWEEN Function in Excel?
How do you generate a random number between two numbers in Excel? The best answer would exactly be the RANDBETWEEN function. So, how to use the RANDBETWEEN function in Excel? Let’s get started. Syntax =RANDBETWEEN (bottom, top) Bottom- The smallest value (starting value) of the range. Top- The largest value (ending value) of the range. […]
-
Five Ways To Find Day Of Week From Date In Excel
If you want to quickly find out what day of the week it is, are you ready to turn on your phone calendar right away? In Excel, there are actually five ways to quickly figure out what day of the week any date is. Let’s get started. No.1 Format Cells Select the area of dates […]
-
Two Tips For Data Management In Excel
My cousin Nancy is learning Chinese recently. So she put together an Excel worksheet and prepared to print it out to study. Oh, I guess Nancy is not learning Chinese, but falling in love with some Chinese guy. Ok, let’s return to the subject. Tip No.1 How to adjust the order of English and Chinese? […]
-
VBA Data Type Basic Tutorial
In the tutorial about VBA variables shared before, maybe you have initially learned the knowledge about data types. Although the data type is not mandatory in VBA, the correct use of the data type can make the program easier to understand and improve the operating efficiency of the program. Today, we will learn more about […]
-
MAX Function VS MAXA Function？
We are very similar to the MAX Function. But do you know the MAXA Function? And what’s the difference between the MAX Function and MAXA Function? Let’s check it out. At first, we need to know the syntaxes of the MAX Function and MAXA Function. MAX =MAX (number 1, [number 2],…) MAXA =MAXA (value1, [value2],…) […]
-
How to Use the CLEAN Function in Excel?
We are going to get a new skill again! That’s CLEAN Function. What is the CLEAN Function and how to use it? This tutorial will answer these questions. The CLEAN function helps you remove all unprintable characters from text. The CLEAN function can remove the first 32 non-printed characters of 7-bit ASCII code (numeric codes […]
-
How to Use the SUMPRODUCT Function in Excel -Super Easy Tutorial?
In our today’s tutorial, we’ll learn about a new Function. That’s SUMPRODUCT Function. Understanding the syntax is essential if you want to master the use of the function. Syntax =SUMPRODUCT (array1, array2, array3,…) How does this function get the result? There is a sheet that contains product names, unit prices, and sales. If you […]
-
Three Ways To Quickly Fill/ Populate Data
Populating data or Auto-fill data is an essential step in our daily work. I guess many people will choose to drag and fill. Actually, this kind of way is simple to operate. But it is only suitable for the case of relatively few data. In today’s tutorial. We will get to learn three more useful […]
