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


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap