How to create a custom validation rule based on a Formula in Tamil
Excel What if Analysis in Tamil
This tutorial explains the simplest way to forecast you data using What IF Analysis
Excel Problem Solving – Removing only Zeros from an Excel file
This tutorial explains the simplest way to forecast you data using What IF Analysis
Downloadable Excel Supporting Files – Archived 2
Downloadable supporting file for Prabas MS Office YouTube videos
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