Taking a deep dive into ADVANCE FILTER from basics to advance.

First see how normal filter works with sort features.

Filter by values, colors, icons.

Sort by color, column wise, row wise, value wise.

What is advance filter and why it is required in Excel so much.

What is the difference between Advance Filter and Filters. Are they same or totally different in terms of objectives and functionality.

Learn How to extract data using criteria's in advance filter - Get Fetch unique records

What is Filter in place and copy in advance filter.

How to make AND criteria's if you have multiple headers you like to filter.

Create OR Criteria's using Advance Filter. Rules to follow while fetching unique records.

How to use logic in advance filter using wild characters like * and ?

Using formulas to extract complex data points

Learning everything about conditional formatting - basic and advance

How to color cells based on values

How to color cells using formulas

How to insert icons using conditional formatting.

How to highlight duplicate or unique values

How to highlight values if they are repeating more than 2 times or any nth instance Learn every option given in conditional formatting.

How to set priorities level in conditional formatting's.

Assignments are added along-with classwork files to give you live exposure

I am here to support you . Write me your doubt and i will give you a solution