Advanced Excel

How to Split Excel Sheet into Multiple Sheets Based on Column Value

Here's an overview of using slicers to filter a table by specific value. Read on to learn more. Split Excel Sheet into Multiple Sheets ...

How to Split a Sheet into Multiple Sheets Based on Rows in Excel

Observe the GIF. The sample dataset (B4:C10) showcases  employees and their working hours in Sheet1. To split the sheet into multiple ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo