Advanced Excel

How to Remove a Circular Reference in Excel – 2 Methods

Circular Reference: An Overview When a cell formula in Excel refers back to its own cell either directly or indirectly, it’s called a Circular ...

How to Find a Circular Reference in Excel (2 Easy Tricks)

Sometimes we input an Excel formula in a worksheet but it’s not working for some reason. It shows a warning prompt instead which mentions Circular ...

How to Remove Table in Excel (6 Easy Methods)

Here's a brief overview of deleting a table from Excel. Let's see the steps in more detail. Remove a Table in Excel: 6 Easy Methods ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo