Categories：Excel Tips
-
How to Quickly Save Each Page as Separate Word Document?
The tips or tricks we have shared before are useful, today’s skill is powerful! So, you should not be miss this article, this is really can save you much time, and improve your office efficacy. I will use the Employee Information Form as an example. We will save each employee’s information page as a Word […]
-
How to Create a Special Histogram in Excel
It’s very easy to create a normal histogram in Excel. But the author wants to share with you a special histogram style. Let’s take a look at the renderings first. Step1 : Create A Colorful Chart Select the data and create a colorful histogram first. Step 2: Insert Triangle Shapes Go to insert and click […]
-
How to Separate Numbers and Text From a Cell In Excel
Today, we are going to learn how to separate numbers and text from a cell in Excel. Let’s divide this tutorial into three parts below. Ok, let’s get started. Situation 1: Numbers are in front of Text. This formula allows you quickly get numbers from cell B3. =-LOOKUP(0,-LEFT(B3,ROW($1:$15))) ROW($1:$15) indicates the maximum length of the […]
-
How To Check The Checkbox To Change The Cell Color
This is a very cool effect in Excel. When you checked each checkbox, the color of the related row would be changed at the same time. Ok, let’s get started. The content of this tutorial may be a lot, but it is not complicated. The author suggests you open an Excel sheet to have a […]
-
How to Record Macro and View Macro Code in Excel
I believe that many of the previous tutorials have taught you a lot. In today’s article. The author will teach you something new. That is how to record macro and view macro code in Excel. Excel provides an automatic code generation function, which is to record macros. The recording macro function can record the user’s […]
-
Loop Structure in Microsoft Excel Visual Basic
Loop structure in Visual Basic allows you to run the same code repeatedly. Sometimes we want a section of code to run more than once. Then, the loop structure run the code again and again until a condition is True or False. Maybe This concept is very abstract to you. So now the author will […]
-
How to Create a Voting System in Microsoft Excel?
We all know the US election in 2020. Joe Biden defeats Donald Trump to win the presidency. The results of this election were obtained through voting by the American people. Ok, let’s end here, we don’t talk about politics, we only talk about Microsoft tips. In addition to the US election, you may also need […]
-
Useful Excel Tips & Tricks You Should Know
This is a perfect and excellent article If you still use Excel frequently in your work or study, The so-called multi-skills are not pressure. So, today, the author will share some useful Excel tricks. Come and learn! Skill 1:How to Make Your Excel Data More Intuitive? When you first look at this table, can you quickly find the […]
-
VBA Operator Basic Excel Formulas Tutorial
VBA provides many operators, which can be used to implement complex operations. Today, the author will share the basic operators and operations provided by VBA, and their basic usage. VBA operators can be divided into the following 6 categories: Assignment operator Arithmetic Operator Comparison operator Logical Operators Concatenation operator Other operators Assignment Operator The first […]
-
VBA Constant Basic Tutorial
VBA constants are relative to the concept of VBA variables. Unlike variables, once a constant is assigned, its value cannot be changed. During the entire process of the program, its value remains unchanged. If new data is assigned forcibly, VBA will report an error. Using VBA constants can make a value expressed in a more […]
