Basic to Advance Excel - Series4

Basic to Advance Excel - Series4

• 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

Filter, Advance Filter and Conditional formatting - Complete madness . Achieving new heights - Super Advance stuff

Url: View Details

What you will learn

• You will be able to work around on complex data structures - extracting the required information from it .
• Learn how to extract data using Filters and Advance Filters - Basic to Advance
• For eg. How to extract unique values, how to extract items which contains specific criteria

Rating: 4.94444

Level: All Levels

Duration: 4.5 hours

Instructor: ajay parmar