14 ways to analyze data - Show Values As - Excel Pivot Tables
Get amazed by the 14 different ways of analyzing data available right within the humble Pivot Table in Excel. Show Values As is a very powerful set of analytical tools. Dr Nitin covers all the 14 ways of viewing the data in this in-depth video.
Download the sample file from here https://efficiency365.com/wp-content/...
Contents
----------------------------------
00:00 - Intro
02:49 - Pct of grand and column total
03:37 - Pct of row total
06:56 - Pct difference
10:35 - Parent totals
14:05 - Running total and Pct
16:45 - Ranking
17:20 - Index option
Blog articles about Show Values As by Dr Nitin
https://efficiency365.com/2017/01/21/...
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
https://efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Created using Camtasia: https://www.techsmith.com/video-editor
