归档： Sandra
-
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 […]
-
A Perfect Slide Effect Sharing In PowerPoint
Today, sandra would like to teach you guys a funny slide effect. The final slide show looks like below. It’s cool and easy to make. Prepare a new slide and right-click to open Format Background. Pick a color you like. I choose pink here. Now we need to insert a shape. Use your hands-on skills […]
-
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 To Batch Delete English In Word Document
In our last tutorial, we already know how to batch delete Chinese in Word. So, how to delete English in batches and leave only Chinese? The method today is similar to the last tutorial. We actually do not delete all the English Words or sentences, we just replace text. So press Ctrl and H to […]
-
How To Batch Delete Chinese In Word Document
More and more people all over the world are learning Chinese. Many countries have even incorporated Chinese into the national education system and set it up as an examination subject. If you are also learning Chinese, this Word skill really needs to be mastered. When you are learning Chinese, you can look at the Chinese […]
