Categories：Excel Tips
-
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 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 Combine Two Columns into One in Excel?
How do we combine data from two columns into one? I’m gonna show you guys two easy ways. Let’s check this out. There are names from two columns A and B, now we need to combine these names into column E. No.1 Powerful Equal Sign No.2 Pivot Table Select the data area and go to […]
-
Ten Tricks for AutoFill in Excel You Should Know
I want to ask you guys a question at the beginning of this tutorial. How do you enter a serial number from 1 to 10 in Excel? Type 1, 2, 3… one by one? If you do so, the ten hidden tricks are tailored for you. No.1 Enter A Serial Number from 1 to 10 […]
-
How to import XML File into Excel in Seconds?
XML is the abbreviation of Extensible Markup Language. It’s a markup language and file format for storing, transmitting, and reconstructing arbitrary data (From Wikipedia). We can usually see the XML file format on the web, so we can’t use this file directly. What we are going to learn today is how to import XML file […]
-
How to Set the Excel Background?
Setting a picture as your Excel background can add some personality to your worksheet. It’s quite easy. Let’s get started. Go to the Page Layout tab and click on Background. There are three ways to insert pictures. Choose the picture you like to be the worksheet background. This step can just change the current worksheet, […]
-
How To Create Small Multiple Line Charts in Excel?
Creating a line chart in Excel is easy. Just select the data area and go to the Insert tab to choose the insert line chart. There is a worksheet of fruit prices for five months. We can get the line chart. But we are going to learn another kind of line chart to show the […]
-
How to Add Borders in Excel Automatically in Two Conditions
We usually select the cell(s) where we want to add the border firstly, then click the border list arrow from the Home tab to add borders. And click No Border to remove borders. Today, we are going to learn a totally different and useful way to add or remove borders automatically. We first select the […]
-
How to Use the UNIQUE Function in Excel? ——Easy Tutorial
Time to learn a new function. Today, we are going to learn the UNIQUE function. The UNIQUE function can help us returns a list of unique values in a list or a range. So, if you need to extract unique values from the range, you can use this function. Syntax: =UNIQUE(array,[by_col,[exactly_once]) Array: It represents a […]
