Advanced Excel

How to Split One Column into Multiple Columns in Excel

Here's an overview image of splitting a column into multiple ones. Method 1 - Using Text to Columns to Split One Column into Multiple ...

How to Delete Row If Cell Contains Specific Values in Excel?

We will be using a sample dataset that contains the Name and Age of some people. Method 1 - Using Find and Replace to Delete a Row If a ...

How to Sum Colored Cells in Excel (4 Ways)

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. However, there are a few ways to implement this kind of ...

How to Lookup Across Multiple Sheets in Excel (3 Easy Methods)

Suppose a bookshop sells books both online and in stores. However, they have two booklists, one featuring books available for online sale and the ...

How to Insert Subtotals in Excel: 7 Unique Methods

Method 1 - Insert Subtotals in Excel Automatically Select a random cell > go to the Data tab > click Sort. The Sort dialog box ...

How to Make a Table in Excel (2 Simple Ways)

In Excel, we need to make a table where we must arrange a data range in a structured form. So that we don’t need to format each cell every time. In ...

How to Merge Rows Based on Criteria in Excel (4 Easy Ways)

We'll use the following dataset consisting of 3 columns named Author, Books, Price, and 9 rows contained in the Cell range B4:D12. We'll merge rows ...

How to Link a Table in Excel to Another Sheet – 2 Methods

There are 2 worksheets: Sheet1 and Sheet2. In Sheet1, you have students' marks in Physics. In Sheet2, students' marks in Chemistry . ...

How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)

We have a worksheet called Sheet1 with the names of some students and their marks. We will add hyperlinks to this sheet in another worksheet of the ...

How to Remove External Links in Excel (8 Easy Methods)

  Method 1 - Using Edit Links Feature to Remove External Links from Cells Steps: Go to the Data tab. From the Queries & ...

How to Create Multiple Dependent Drop Down Lists with Excel VBA – 3 Methods

What Are Dependent Drop Down Lists in Excel? Using a dependent drop-down list, you can change the value of a drop-down list and it will show the ...

How to Make Multiple Selection from Drop Down List in Excel

We'll use a simple dataset to create a multi-selection drop-down. Method 1 - Making Multiple Selections from an Excel Drop-Down List with ...

How to Extract Data From Table Based on Multiple Criteria in Excel

We have a dataset of movies, their genres, leading actors, and years of release. We will provide the Genre and Actor name as criteria in a ...

How to Generate List Based on Criteria in Excel (5 Methods)

We have a dataset of several people from different locations along with their vehicles. Using this data, we will form a list based on criteria. ...

Create a Unique List in Excel Based on Criteria (9 Methods)

Method 1 - Create a List of Unique Rows with Multiple Column Criteria In the following dataset, we have a list of players, their ages, and what ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo