Take a Guess to Win Windows 10 Pro Key!
Categories: Excel Tips
-
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 […]
-
How To Use the SORT Function—Easy Tutorial
Today, we are going to learn the usage of the SORT function. The SORT function can help us to sort the rows and columns in a data range. Now, let’s check this out. Syntax: =SORT(array,[sort-index],[sort-order], [by_col] Array: The range of cells that is to be sorted. (Required) [sort-index]: The number of the specific row or […]
-
How To Use The SEQUENCE Function In Excel-Easy Understanding Tutorial
Today, we are going to learn the usage of the SEQUENCE Function. Learning to use functions can always make complicated things to be easier. The Syntax of SEQUENCE Function: =SEQUENCE (rows,[columns],[start],[step]) Rows: The number of rows to be returned. Columns: The number of columns to be returned. The default value is 1. (Optional) Start: Starting […]
