A combination of Filter and Unique formula for dynamic ranges
Excel Short VIDEOS
A combination of Filter and Unique formula for dynamic ranges
0:50
Custom sorting Excel function to arrange data in a specific order.
Excel Short VIDEOS
Custom sorting Excel function to arrange data in a specific order.
0:58
Unique formula - Find Unique items in the table column
Excel Short VIDEOS
Unique formula - Find Unique items in the table column
0:49
Remove unnecessary space in the cells
Excel Short VIDEOS
Remove unnecessary space in the cells
0:59
Clean the unwanted space in your data
Excel Short VIDEOS
Clean the unwanted space in your data
0:59
Evaluate your Excel formula
Excel Short VIDEOS
Evaluate your Excel formula
0:48
Evaluate your own formula step by step
Excel Short VIDEOS
Evaluate your own formula step by step
0:48
Fun with ChatGPT
Excel Short VIDEOS
Fun with ChatGPT
0:14
Dynamic header for your chart!
Excel Short VIDEOS
Dynamic header for your chart!
0:44
Extract multiple table from single pivot table using Show report filter option.
Excel Short VIDEOS
Extract multiple table from single pivot table using Show report filter option.
0:42
Pivot Table default view to Tabular format
Excel Short VIDEOS
Pivot Table default view to Tabular format
1:00
Quick way to format the Pivot Table
Excel Short VIDEOS
Quick way to format the Pivot Table
0:51
Dates in Pivot table value field to get First & Last date using MIN and MAX option in Field settings
Excel Short VIDEOS
Dates in Pivot table value field to get First & Last date using MIN and MAX option in Field settings
1:00
Convert Date format in few clicks (US to INDIAN format using Text to Column function)
Excel Short VIDEOS
Convert Date format in few clicks (US to INDIAN format using Text to Column function)
0:45
Quick Analysis tool
Excel Short VIDEOS
Quick Analysis tool
1:01
Forecast with Historical data
Excel Short VIDEOS
Forecast with Historical data
0:54
Evaluate your Formula
Excel Short VIDEOS
Evaluate your Formula
0:56
Quick Pivot table
Excel Short VIDEOS
Quick Pivot table
0:46
Week Number of the Month
Excel Short VIDEOS
Week Number of the Month
1:00
Unique IDs using Advance Filter
Excel Short VIDEOS
Unique IDs using Advance Filter
0:57
Week Number of the Month
Excel Short VIDEOS
Week Number of the Month
1:53
Extract Unique values using advanced filter function
Excel Short VIDEOS
Extract Unique values using advanced filter function
1:02