MS Excel : Sumproduct Function with Criteria by Excel Freak | Video 44

Learn to use Sumproduct function with or without criteria to find the sum of the products of two consecutive ranges[…]

Read More...

MS Excel : Count, Counta and Countblank Functions by Excel Freak | Video 43

Understand the difference between the three variations of Count functions namely, Count, Counta and Countblank. Count function is used to[…]

Read More...

MS Excel : Create Pivot Tables by Excel Freak | Video 42

Learn to create pivot tables to draw insights from raw data with just click of few buttons. If you find[…]

Read More...

MS Excel : Use Consolidate feature by Excel Freak | Video 41

Learn to use consolidate feature in excel to consolidate your worksheets (located in one workbook or multiple workbooks) into one[…]

Read More...

MS Excel : Recording Macro using Relative References by Excel Freak | Video 40

Learn to record macro using relative cell reference option to make your macro dynamic in nature. Such macros will be[…]

Read More...