Basic to Advance Excel Series3

Basic to Advance Excel Series3

• This series-3 you should watch if you are good with V-lookup ,Match and other basic formulas of excel. 

• This tutorial will take you to new level as we are discussing so many 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.

INDIRECT ,Data Validation ,Name manager, Address, Count and Sum family functions, wild characters - Super Advance

Url: View Details

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.

Rating: 4.8125

Level: All Levels

Duration: 8 hours

Instructor: ajay parmar