归档: Sandra
-
How To Hide Files and Folders in Window 10
If you mind other people seeing some files on your computer, we can choose to hide the files or folders. This is not only very useful, but the steps are also very simple. Step 1 First, we put all the content like pictures, videos, or anything that needs to be hidden in the same folder. […]
-
How To Make Microsoft Word Be A Grid Photo Maker?
We are now used to sharing our photos and videos on various social platforms. And I think girls like to make pictures look better. Today, we are going to learn how to get grid Photo just in Word. We first insert a 3*3 table and adjust its size. Then we insert a pic and set […]
-
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 […]
-
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. […]
-
How To Go Back To Win10 From Win11
If you are not familiar with Windows 11 and having problems or even you just don’t like it. so, how to roll back to Windows 10 from Windows 11? There is a very simple way. We can go back to Windows 10 just via Settings. Open Settings. Find Update & Security and click on it. […]
-
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 […]