Basic to Super Advance Excel Training Part2 ( 21 Hours)
Advance Filter, Conditional formatting. INDIRECT ,Data Validation , CountIFs,SumIfs,Offset,Charts,Form Controls,Arrays
4.79 (14 reviews)
93
students
22 hours
content
Mar 2023
last update
$59.99
regular price
What you will 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
Screenshots
Related Topics
1686238
udemy ID
5/10/2018
course created date
2/8/2020
course indexed date
Bot
course submited by