Excel Pivot Table Tutorial - [10 TIPS You Don't Know]

preview_player
Показать описание
In this video, we will learn the top 10 Pivot Table Tips & Tricks that Everyone MUST KNOW. These tips help you to create Pivot Tables in just 10 minutes.

00:00 Introduction of Pivot Table Tutorial
01:17 Understanding the Layout
02:24 How to Sort Data in Excel
04:25 Mathematical Calculation in Excel Pivot Table
05:10 Drill down the details in Pivot Table
05:22 Pivot Chart Shortcut - F11
05:33 Grouping (Dates) in Excel Pivot Table
06:03 Grouping (Numbers) in Excel Pivot Table
07:33 Slicers and related settings in Pivot Table
08:40 Conditional formatting in Excel Pivot Table
09:25 Refresh and change Data Source

Excel Pivot Table Tutorial - 10 TIPS You Don't Know
#PivotTable #pivotabletutorial #Exceltips

Let's Connect:

Рекомендации по теме
Комментарии
Автор

many things i learnt from this .. thank you sir ...

rajeshn
Автор

The 'Recap' very important for learners. TY

bczaru
Автор

Beautiful explanation in a simple way...Expecting more things in a same way...Keep it up.

apn
Автор

I really appreciate your great simple explanation

alaaalhajjar
Автор

Videos was helpful, but I want to make 1 pivotable with 2 different worksheet with different dataset, please help

chandanprasad
Автор

Converting to a table can eliminate one step of maximising the new added ranges '&' refreshing as well.

dynamicdesyr
Автор

Hello sir, can we have the soft copy of this raw data for practice?

iamankurjain.
Автор

Hi Rishab, I always follow all ur videos. Now, shud I b checking Yoda or excel superstar? Which one is more active?

dumm
Автор

Sir, how to do repeat all rows in MS Excel 2007.

ajitpal
Автор

Hi In group option im facing some issue, If i group the rows for values as 50 diff it sipposed to 1-50 then 51-100 right but its showing as 1-50 and 50-100 so ... can u please let me know the trick

rajeshreddy