How to Use Excel Formulas Part 2 | Combination of useful Excel formulas and Functions.

How to use excel formulas? Use of Arrays in Excel
In this video we can learn about the arrays formulas in MS Excel and how to use them in our day to day office life. Arrays formulas are combination of different excel formulas. These are very useful functions, by using them we can do our data work with no time.
Formulas like "Vlookup, Index, Match, Countif, Sumproduct & Max are very helpful and important in MS Excel.

Time Stamps
00:00 Intro
00:15 Scenario-1 Vlookup
02:10 Scenario-2 Sumproduct
05:10 Scenario-3 Day()
06:17 Scenario-4 Index & Match
11:38 Scenario-5 Countif
12:34 Scenario-6 Countifs
14:00 Scenario-7 Max & IF
15:08 Scenario-8 Sumif
16:08 Wrap up
---------------------------------------------------------------------------------------
For more Video like this please go through my Channel link is below :

   / @ajexcel  
---------------------------------------------------------------------------------------
‪@ajexcel‬
---------------------
Music from #Uppbeat (free for Creators!):
uppbeat.io/t/soundroll/tropicana
License code: TSCQX9N1U3OR7MPH
---------------------------------------------------------------------
Music from #Uppbeat (free for Creators!):
uppbeat.io/t/hartzmann/ocean-cruise
License code: G1QZWW48AAZR5DU0