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


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap