归档: Sandra
-
How to Batch Add Units to Cells in Excel
There is a list of numbers, and you need to add units to each cell. Will you add these units one by one? However, if there are too many cells, the manual method will be cumbersome. Now, we are going to learn a trick to batch add units to cells. Let’s take “kg” as an […]
-
How to Use the YEARFRAC Function in Excel?
How time flies. Do you know how long has 2022 passed? There is a built-in function in Excel called the YEARFRAC function. so, let’s explain how to use the Excel YEARFRAC function. Syntax =YEARFRAC (start_date, end_date, [basis]) start_date: This is the start of the period. It should be entered as a serial date, not a […]
-
How To Reset Network Settings in Windows 10?
If there is something wrong with your network or when you encounter a networking issue. Maybe you can try to reset network settings. Find the internet icon at the bottom of your computer and right-click on it to choose open Network & Internet settings. Or you can also open this window in Windows Settings. Scroll […]
-
Powerful Word Templets for You
We always search for free templates like flyers resumes or business cards online. Actually, we can find almost every kind of templets just in Microsoft Word. Click on File. Choose the second one [New]. You can search for online templates here. Click on the Pizza Menu and create it. Now we got a Pizza Menu, […]
-
How to Show Duplicates in Excel?
Sometimes we want to count the times of repeated data in Excel. So, we need to show duplicates in Excel, and quickly find duplicates in Excel, not remove them. Do you know how to quickly show duplicates in Excel? Let’s take an example. Here is a list of names in column A. We can use […]
-
How to Speak Cells in Excel?
Have you ever met such a situation that you need to input a lot of data? You need to check every cell you type. So, you look at your date book and Excel table at the same time to make sure of the correctness. Here is a way to help you check your data efficiently. […]
-
How to Change Text Direction in Excel?
We can easily change text direction in Excel to make it look better or save space. For instance, here is a table of fruit sales in 2022. If we need to print this table at the end of 2022. The width of this table would be too long to print, so we can change the […]
-
How to Disable Microphone in Windows 10?
Some malicious websites or malware would ask permission to use your microphone or camera. Therefore, your need to do something to stop this. So, how to turn off microphone on our device to protect our personal privacy. Press the Windows key and click on the settings to open up the Windows Settings box. Now you […]
-
How To Create A Dynamic Graph In Microsoft Excel
Why can the data in the Excel chart made by other people be selected? And the corresponding chart will change along with it. Today we will learn how to make this kind of chart that can switch data in one second. Let’s first create a table to give an example. We first copy and paste […]
-
How to Batch Underline Numbers in Word?
We’ve learned how to batch insert underlines and how to underline specific text automatically in Word in our previous tutorials. Today, we are going to learn how to batch underline numbers in Word. Here are several paragraphs, now we add some numbers. Now we press Ctrl and H to quickly open the Find and Replace […]