Downloadable supporting file for Prabas MS Office YouTube videos
Category: Excel
How to use #Timeline in Excel to Pivot Table
This tutorial explains the simplest way to filter your excel data using Slicer
How to use #Slicer in Excel to Filter a Table or Pivot Table
This tutorial explains the simplest way to filter your excel data using Slicer
Excel Round Function in Tamil – Some tips are included
This tutorial explains the simplest way to develop multiple report from a master pivot table
Aggregate – New Functions
This tutorial explain the method to perform the aggregate function in tamil
PDF to Excel using Power Query
This tutorial explains the simplest way to develop multiple report from a master pivot table
MaxIFs vs. MinIFs – Excel New Functions
This tutorial explains the simplest way to develop multiple report from a master pivot table
Excel Shortcuts to Make Quick Data Entry
This tutorial explains the simplest way to develop multiple report from a master pivot table
Excel Formula WorkDay & WorkDay.INTL
This tutorial explains the simplest way to develop multiple report from a master pivot table
VLOOKUP and XLOOKUP – Approximate Match
This tutorial explains the simplest way to develop multiple report from a master pivot table
Native Consolidation option in Excel
This tutorial explains the simplest way to develop multiple report from a master pivot table
Excel Data Table
Excel Data Table in Tamil
Pivot Table – Show Report Filter Page
This tutorial explains the simplest way to develop multiple report from a master pivot table
Excel Function EDATE vs. EOMONTH
The basics of EDATE and EOMONTH Excel functions are explained in this Excel tutorial
Recover Broken Data from a Pivot Table
Data is the back bone of any pivot table in Excel, this tutorial explains the simple method to recover the broken data of a pivot table