Advanced Excel

How to Convert a Table to a List in Excel (3 Methods)

Method 1 - Using PivotTable and PivotChart Wizard to Convert a Table to a List in Excel Introduction to the Dataset: You have a dataset ...

How to Split a String by Length in Excel – 8 Methods

This is an overview. The dataset showcases students’ records. Method 1 - Using the Flash Fill Feature to Split a String by Length ...

How to Delete Blank Rows in Excel?

Method 1 - Delete a Couple of Blank Rows Manually Press & hold the Ctrl key and select the blank rows. Right-click > Go to the ...

How to Convert General Format to Date in Excel (7 Methods)

Note: General format in Excel means no specified format. Whenever you enter a numeric or alphanumeric value in a cell, Excel counts them in General ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo