归档： Sandra
-
Simple Excel Tutorial–How To Sum Multiple Excel Tables Across Sheet
Let’s say you are a class teacher, and the math teacher and chemistry teacher have each given you a report card. You need to sum up the class’s grades in math and chemistry. How to do this quickly? Highlight cell C2 and go to the Formulas tab. Click on the arrow of Math & Trig, […]
-
How To Batch Modify The Format Of Headings In Word
A lot of people still do not know how to bulk modify the title format, such as writing a paper, if you find your title format and requirements are wrong. Would you choose to adjust one by one or format brush? There’s actually a very quick way to do it. Even if you have thousands […]
-
How Do I Add 10 To All The Cells in Excel
Do you know how to add or subtract 10 from all the cells? I mean at the same time. If you haven’t mastered this technique yet, read on. Now we open an Excel sheet and enter some random numbers. Let’s take 10 as an example. Just type 10 in any cell. Select 10 and press […]
-
How To Change Mouse Sensitivity In Windows 10
Mouse sensitivity can directly affect the user’s experience, especially when playing some competitive games on the sensitivity of the requirements is higher, so how to adjust mouse sensitivity? Press the Win key or just click the Start option, then choose Settings. Or you can just press Win and I keys to quickly open the Windows […]
-
How to Use Data Validation for Entering Dates in Excel
When we want to enter data in Excel, in order to reduce data entry errors, we can use the data validation function to set the valid range of the data. Let’s take the below pic as an example. The picture shows the grades of the students. The score must be between 0 and 100. To […]
-
How to Use Excel Text Function in Microsoft Excel?
The TEXT function is one of the very frequently used functions, it can be used as a worksheet function in Excel. You can use the TEXT function to embed formatted numbers inside text. Syntax =TEXT (value, format text) Value: Value you want to format Format text: Format code you want to apply Now, Let’s learn […]
-
How To Create Certificate In Batch In Microsoft Word
Do you want to create unique certificates for your children or students or even your excellent staff? Usually, you’re sure to go to the store and buy a certificate and fill in the name of the winner. Or you may choose to download the certificate from the Internet, and then type the name to print […]
-
How To Export/ Convert a Word Document to PowerPoint File?
Sometimes, we need to convert Word and PPT files to each other, and there are many methods. Today we will introduce the most convenient one. Open the Word document and go to the File tab, click on Options. Go to Customize Ribbon and choose All Commands first, find the Send to Microsoft PowerPoint button to […]
-
How to Enter An ‘±’ Sign in Microsoft Excel
Today I saw someone on Quora asking how to enter the sign’±’ in Excel. He said that he copied and pasted it from the Internet every time. so, maybe this is very easy for you, but I guess some people still don’t know. Today, the author would share with you guys two common methods. Method […]
-
How to Declare Variables and Assign Them Value in VBA
Actually, declaring the variables and assigning them value is the starting and basic part of running a code. A good declaration way and a correct assignment process are fundamental to writing accurate and efficient code. This article will share with you what’s the declared variables and some basic syntax. In the previous article, we have […]
