PivotTables - Set Default Layouts & Formatting And SAVE TIME! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 8
Gene
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. :)
reply
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. :)
reply
Jeremy
For the life of me I cannot find this Edit Default Layout button. In fact there isn't even a Data menu and it goes directly from Formulas to Proofing. In the Advanced menu, there is a Data section, but no Edit Default Layout button.
reply
For the life of me I cannot find this Edit Default Layout button. In fact there isn't even a Data menu and it goes directly from Formulas to Proofing. In the Advanced menu, there is a Data section, but no Edit Default Layout button.
reply
Dianne
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
reply
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
reply
Jesus
Why Pivot Table BOX after clicking on (Pivot Table in Insert ribbon) is different.
This box is shorter than other.
My Box is just Box showed (0:40) before you click (OK).
I have the 2019 Office Version.
reply
Why Pivot Table BOX after clicking on (Pivot Table in Insert ribbon) is different.
This box is shorter than other.
My Box is just Box showed (0:40) before you click (OK).
I have the 2019 Office Version.
reply
itech
Can you save these pivot tables? Every time I close my file, they replace with my original sheet and I can only see the pivot table being replaced by it.
reply
Can you save these pivot tables? Every time I close my file, they replace with my original sheet and I can only see the pivot table being replaced by it.
reply
Raul
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
reply
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
reply
Bhupinder
Thanks so much for this tutorial , is there is a way to put 2 number formats? For example Revenue in $ and units as numbers ?
reply
Thanks so much for this tutorial , is there is a way to put 2 number formats? For example Revenue in $ and units as numbers ?
reply
Thierry
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.
reply
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.
reply
Add a review, comment
Other channel videos
