14 ways to analyze data - Show Values As - Excel Pivot Tables

Опубликовано: 14 Октябрь 2024
на канале: Efficiency 365 by Dr Nitin
1,390
62

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