Categories：Excel Tips
-
How to use the BAHTTEXT Function in Excel?
Do you know what’s the BAHTTEXT function? I don’t think many people use this function, and I haven’t used it in my daily office so far. But today, we are going to learn this. It’s very easy to understand and use. The BAHTTEXT function converts a number to Thai as a text value and appends […]
-
How To Create The Multiplication Table In Excel
Why Chinese people are good at math. That’s because they memorized the multiplication tables in primary school. Knowing the multiplication table will help you do math more efficiently. So if you have kids, make sure they learn multiplication tables at an early age. It will definitely make them smarter. Today, we are going to learn […]
-
How To Insert Tick And Cross Mark Quickly In Excel
There are at least 6 ways to insert tick and cross symbols in Excel or Word. I guess you know at least one or two of these methods. But the method I want to talk about is the very unusual one. Let’s take the table below as an example. Select the area from cell B2 […]
-
How To Convert The Content On One Line Into Multiple Lines In Excel
When we are processing data, sometimes we need to change one line of content into multiple lines of content. Most people will use the copy and paste method to complete, but if you encounter a lot of content, it will be very troublesome and waste time. So is there a way to achieve this effect […]
-
How To Quickly Switch Worksheets In Excel
If there are multiple worksheets in an Excel workbook, we will need to switch these worksheets when using them. So how to switch worksheets quickly? In fact, there are several different types of switching worksheets in Excel. Let’s take a look. No.1 Just Click Most people use the mouse to click directly when switching between […]
-
How Do I Create Multiple Excel Workbooks Quickly
We have learned how to create multiple sheets in Excel, and how to batch create folders. Now, it turns to multiple Excel workbooks. If you are familiar with VBA, it’s a no-brainer for you. If you don’t, that’s okay. You can just save this post and take it out when you need it anytime. Let’s […]
-
How To Use Clipboard To Copy And Paste Multiple Items In Excel
If your superior asks you to copy from one worksheet to a specific location on another worksheet. What would you do? Will you choose to copy and paste one by one? Come on, that’s just a waste of time. There is a choice called Clipboard, I’ll show you how to use it. If we need […]
-
VBA Program Structure Tutorial
Today, the author would share something new about the VBA program structure In this article. It’s also a very important part of VBA. The concepts of variables, data types, and operators learned in the previous articles are the “static” part of VBA. In contrast, the program structure is the “dynamic” part of VBA. After learning […]
-
Four Ways to Insert Hyperlinks Quickly in Excel
Inserting hyperlinks into cells to link to other cells, worksheets, web pages, etc., is a common operation. There are actually four ways to insert hyperlinks in Excel, so let’s take a look. No.1 Suppose we need to insert a hyperlink in the green cell. Just right-click and choose the Link option in the list. Now, […]
-
How To Calculate The Total Score Like The Olympics?
The Tokyo 2020 Olympics just ended. As an audience, I saw many wonderful performances. My favorite Olympic events to watch are diving and gymnastics. How about you? We all know that the athlete’s score is calculated on average after removing the highest and lowest scores from the judges. So, today we are going to learn […]
