Basic to Super Advance Excel Training Part2 ( 21 Hours)

Advance Filter, Conditional formatting. INDIRECT ,Data Validation , CountIFs,SumIfs,Offset,Charts,Form Controls,Arrays

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• Students will be able to learn dynamic functions like INDIRECT data validation Count Sum family functions with the live exposure of working on excel.
• One of the most advance and complex function atleast appears in first sight is INDIRECT. Let us understand it from its root.
• How to use INDIRECT Function in different ways , Understand the indirect by definition and when it should be used and when can it throw an error.
• Deep dive into Count and Sum Family functions like Count, Sum, Count if, Sum if, CountIFs, SUMIFs,MAXIFs
• Difference between CountIFs, AverageIFs and SUMIFs with practical examples.
• Use of Wild Characters like ? and * - their meaning and use in these functions.
• I have added a project as well which uses INDIRECT with data validation together. It is an automation you can use to add and remove stock items.
• Data Validation rules and customization of error alerts using drop down.
• How to prevent data entry in excel spreadsheet using custom formula in data validation.
• How to use Name managers and mix it with INDIRECT Function. Basic to Advance
• How to create dynamic drop downs using INDIRECT plus data validation plus name managers. All in one.
• Normal Filters, Sort features plus advance Filter, Conditional Formatting - basic to advance
• Active X controls and form Controls

Requirements

• Good Understanding of Excel functions like Vlookup Match Index Text functions is a must.
• You may check Part1 and Part2 if you like to learn everything mentioned above.

Target audience

• Students who want to make career in analytics field. Require advance excel knowledge
• If you like to take your excel knowldegE to a new level, this 8 hours tutorial fits for you. See how complex tasks can be solved in a simple way
• Incredible functions like INDIRECT ,SUMIFS,COUNTIFs and other dynamic features like name managers and data validations is discussed.