Take a Guess to Win Windows 10 Pro Key!
Categories: Excel Tips
-
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 […]
-
How To Create A Dynamic Countdown Timer In Excel？
How was your Christmas? We had a delicious and fancy Christmas dinner. Festivals always make me happy, birthday too. My family and friend never forget my birthday. Still, I want to make a countdown timer to remind my brother but in an unobvious way. We first enter the time of today and the target date. […]
-
Take You To Know 6 Excel Paste Tips
We usually copy and paste something into Excel. But just Ctrl +C and Ctrl + V. In fact, there are many other paste categories as well. So in our today’s tutorial, the author would like to share all of them with you. No.1 Adds The Same Number To A Region If we need to add […]
-
How to Use VLOOKUP with CHOOSE Function in Excel?
You definitely know the VLOOKUP Function or CHOOSE Function. VLOOKUP Function can help us to search for a certain value in a column. But in fact, there are often many cases that need to search according to multiple conditions, and there is no ready-made function at present. So, we can use the composite functions, that’s […]
-
How To Lock Excel Formulas To Protect Them?
Sometimes, we just want others to see the number, but couldn’t see how the number came from. There is a nice way that works. Click on the green triangle to select the whole sheet. Then right-click and choose Format Cells in the list. Go to protection, and uncheck the Locked box. Press F5 to quickly […]
-
How to Use the COUNTBLANK Function in Excel?
Have you ever used COUNTBLANK Function? Do you know how to use it. today’s tutorial is about COUNTBLANK Function. You can use this function to get the total number of blank cells. Formula: =COUNTBLANK (range) Range refers to the range of cells in which we want to count blank cells. Let’s take an example. The […]
-
How to Use the ISTEXT Function in Excel?
The ISTEXT function can help us to test if a cell contains a text value or not. When a cell contains a text value, it will return TRUE, and FALSE when contains other value or empty. Syntax: =ISTEXT (value) So we can use ISTEXT function to check if a cell contains a text value. By […]
-
How to Import Data From One Sheet To Another in Excel?
The following two pictures are Shee1 and Sheet2 from the same Excel workbook. Now we need to import the English scores in Sheet 2 into Sheet 1, but it can be seen from the figure that the names of Table 1 and Table 2 do not correspond one-to-one. So, how to quickly import data? Now […]
-
How to Determine the Number of Days of any Month in any Year？
If I now ask you how many days there are in this month, you should be able to answer 31 days right away. Then let me ask you how many days are there in February 2050? You may need to think about it for a while and answer 28 days. So how do we use […]
