Advanced Excel

How to Highlight Active Row in Excel (3 Methods)

If your Excel dataset has a lot of columns, it becomes quite difficult to find data from one end to another end of a row. But if you generate a ...

How to Add Filter in Excel (4 Simple Methods)

Adding filter in Excel is the process of applying a filter to a range of data to selectively display only the rows that meet certain criteria. It ...

How to Filter Unique Values in Excel (8 Easy Ways)

Filter Unique is an effective way to get around with numerous entries in a dataset. Excel offers multiple features to filter unique data or remove ...

How to Make a Price List in Excel (Step by Step Guidelines)

Displaying product information such as Unit Price, Product Name, Total Price Price List plays a pivot role, and this article will give you the scopes ...

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Let’s say we have the following dataset: Sales Representative's Name, their Sales Area, and the Number of Units Sold in each month of the first ...

Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

In this tutorial, I will discuss how to highlight cells that contain text from a list in Excel. I will use Conditional Formatting to highlight cells. ...

Shortcut for Excel Filter (3 Quick Uses with Examples)

Application of the Excel filter shortcut in Microsoft Excel is a very convenient approach to use the filtering option. It not only saves our time but ...

How to Use Text Filter in Excel (5 Examples)

Filter in Excel is a great tool that you can use in a large worksheet to find out all the information that matches the criteria of the Filter very ...

How to Perform Custom Filter in Excel (5 Ways)

Excel sheets with massive datasets are hard to deal with. But if you can filter the dataset according to your specific need, then the task becomes ...

How to Filter Horizontal Data in Excel (3 Methods)

This article explains three methods to filter horizontal data in Excel. Filtering data vertically is easier with the default Filter feature, pivot ...

Filter Multiple Criteria in Excel with VBA (Both AND and OR Types)

In this article, I’ll show you how to filter multiple criteria from a dataset with VBA in Excel. You’ll learn to filter both AND type and OR type ...

How to Compare Two Excel Sheets and Highlight Differences

If you are looking for some of the easiest ways to compare two Excel Sheets and highlight differences, then you will find this article useful. By ...

How to Remove Filter in Excel (5 Easy & Quick Ways)

In the Excel sheet, we do apply Filter to do an analysis of particular data. While showing the required data Filter hides other data. Anyone may need ...

How to Create Drop Down List with Filter in Excel (7 Methods)

In Microsoft Excel, data entry becomes faster when we use a drop-down list filter. Filters may be used to filter down and conceal sections of our ...

How to Fix Circular Reference Error in Excel (A Detailed Guideline)

While trying to enter a formula in your Excel sheet, it doesn’t function for some reason. Rather, it informs you of a circular reference. Millions of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo