Categories：Excel Tips
-
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 […]
-
A Funny And Useful Conditional Formatting Trick Sharing
In the previous tutorials, we have mentioned the use of the Conditional Formatting function many times. I don’t know whether you have mastered it. But, today I am going to share with you an interesting technique. Let’s take a look at the effect first. Firstly, we need to type =LARGE(C2:C14, F2) in cell F3 and […]
-
How Do I Filter Weekend Days In Excel?
I’m always looking forward to weekend days. After all, few people like to work. In our previous tutorial. We can get all dates to show in Excel. So how to show only weekend days in Excel? Here are all dates in 2022. You can click here to know how to quickly get this table. Now […]
