PivotTables - Set Default Layouts & Formatting And SAVE TIME!

Tired of changing the layout of each new PivotTable? With default PivotTable layouts you can eliminate the time wasted with formatting.

0:23 Creating and formatting PivotTables
1:35 Setting the default PivotTable
3:03 Setting default PivotTable Styles
3:18 Setting the default number format
4:30 Knock on effects of using the Data Model for PivotTables

[iankr]

Thanks, Mynda. Anything that makes pivot tables less of a faff to set up is great.

[wayneedmondson]

Hi Mynda. Great Pivot Table advice and tips! Thanks for sharing :)) Thumbs up!!

[olivierissaverdens]

Thank you (again) a lot Mynda for another clear and useful video!

[aiasaiascon]

Thank you a lot Mynda for another clear and useful video! super cool!

[joebaker]

Thanks, Minda! Really looking forward to analyzing my GL data, instead of reformatting it!

[genechicago]

I couldn't agree more that having to set the number format for each new pivot table is the most annoying time wasters there is so I was really looking forward to seeing how I can get around that. Then you mentioned that it's only available in Excel 2019 or Ofiice 365 and I was darn it---I knew there was a catch! :( Oh well, maybe one day we'll come up with a Macro that can do that. :)

[raulcisneros]

Wow this is great!!! Thanks a lot! I even had to have a VBA macro to run and change the number formats. Need to get more familiar with the Data Model

[HaydenHendersen]

Thank you! I set my pivot tables to also be in tabular format and repeat row labels. So I have a column with 2022 and then January, and then 2022 and then February, etc. But I want the year and month columns to automatically show together, so it is Jan 2022 in one column. Is there a pivot table setting to auto merge the month and year columns into one?

[markfarrow]

Mynda. As always a very informative video

[UpExcel]

I never realised I could set pivot table defaults in options....great news 👍 Thank you very much.

[bhupinderbuttar]

Thanks so much for this tutorial, is there is a way to put 2 number formats? For example Revenue in $ and units as numbers ?

[darrylmorgan]

Hi Mynda!Really Great Tips..Thank You :)

[ExcelWithChris]

Got to this video by chance. Is there a way to save a style (I often use a current style, then duplicate and then I like to add borders to all cells). But the new style is only available in this workbook. How can I make sure it is available in all future workbooks?

[diannedrechsler]

Thanks Mynda, I've done your Power Pivot course and just started using it in earnest in my job. I went to create a calculated field and what?!? It was greyed out. Now I know to use the Add Column feature in the PP Manager

[alterchannel]

Thankyou. Is it possible to save a custom TABLE style to use in other workbooks, I can't beleive it's not possible!

[rachaelhanna]

Great Video Mynda, I've also found the Group function isn't available in Pivot Tables based on the Data Model

[amyjain]

how do you change the data format when you double click on pivot data to show details, it opens in new sheet but data is not arranged properly means the column width.

[thierrybernot]

Thank you Mynda. Well, when I'll be back on a PC one day, I'll use these, but on Mac, MS 365 is not so rich, the least to say.

[paddington]

Hi, Is it possible to create an hyperlink to another document inside a pivot table?

[dhun]

is there a way to do the same in excel for Mac?