Excel MIS Training Advance-Filter, Cond Formatting) Series 4
Filter, Advance Filter and Conditional formatting - Complete madness . Achieving new heights - Super Advance stuff
Created by ajay parmar
30-Day Money-Back Guarantee
What you'll learn
- You will be able to work around on complex data structures - extracting the required information from it . For eg. How to extract unique values, how to extract items which contains specific criteria , how to extract date ranges data having sales number greater than 100 $ from City A,B,C. You will learn how to make graphs using conditional formatting, How to use great ICONs in Conditional formatting and make your boss droll over you. So much to learn. Come and fall in love with Excel.
Requirements
- Good Understand of basic Excel Formulas and good hold on the variations one can bring in Formulas using $ sign.
Description
- Taking a deep dive into advance filter from basics. From basic level of advance filter to using criteria in it .
- 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 adavance
- 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
Who this course is for:
- Learn about Advance Filter and Conditional formatting and be good in Data mining and representation. These two topics will help you in Data visualization and extraction.
Course content
1 section • 6 lectures • 4h 41m total length
- Preview01:10:13
- 59:18Introduction to Advance Filter
- 26:56Introduction to Advance Filter
- 53:58Introduction to Conditional Formatting
- 01:10:17Introduction to Conditional Formatting
- Preview00:55
Instructor
Instructor - Advance Excel, Excel Vba ,Access, Access Vba
![ajay parmar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 430 Reviews
- 1,909 Students
- 43 Courses
I have been teaching online from 7 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.