Rating 4.81 out of 5 (8 ratings in Udemy)
What you'll 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 …
Rating 4.81 out of 5 (8 ratings in Udemy)
What you'll 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.
- Full time support is available for you .
DescriptionThis series-3 you should watch if you are good with V-lookup ,Match and other basic formulasof excel.
This tutorial will take you to new level as we are discussing somany advance excel functions .As always, not just basic functions but their combinations as well - how it works in real excel life. You will then see some mini exercises as well that are going to make you crazy about advance Excel.
Introduction to INDIRECT Function, Use of indirect in real life.It is considered the most dynamic and powerful function when it comes to linking the data in a structured manner.
Introduction to ADDRESS function. What happens when indirect and address functions come together. It is mind blowing.
Using INDIRECT how we can solve complex data problems like data wrong alignments and even in dashboards you can use it.
What is a NAME MANAGER. How to create name managers. Their use with Indirect function
Learn how to make simple drop downs and dynamic powerful drop downs using indirect and name managers
Learn how to link one drop down with another drop down. Dynamic drop downs and use them in your dashboards.
Discussing about Count and Sum family Functions - COUNT,COUNTA,COUNTBLANK,COUNTIF,COUNTIFS,SUMIF,SUMIFS,MAXIFS
Combination of these functions with each other by solving the real excel problems like how to combine Vlookup with SUMIF or COUNTIF - Fully practical scenarios.
Use of wild characters in Count Sum functions - use of * and ? . Unbelievable magic happens here.
Assignments are added to support you and help you in monitoring the progress. Write me back if you will have questions. I will love to help you.
