Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later
HTML-код
- Опубликовано: 11 сен 2024
- Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Download Excel Start & Finished File: people.highlin...
Download Full Written Notes: people.highlin...
Class web page link: people.highlin...
Learn about how to set Default Layout for a PivotTable in Excel 2016 Office 365 or later versions.
You always do an excellent job not only explaining how to use Excel features and formulas, but also explaining the advantages of one method over another and providing solid real world examples of how and when to use the features and formulas in Excel. Thank you for being so generous with your knowledge and thorough in your teaching technique. You are appreciated. ~ Lennox
You are welcome, Lennox!!!
Thank you!
Small detail but have a big impact, appreciate you sharing this Michael!
Thank you Mike for another EXCELlent video
So I have the 2007 version of Office which means I dont have that feature but I added the "Show in Tabular" button to the quick access and now just pressing "Alt + 2" works B-) You made me smart!
Yes, that version is over 10 years old. The "Office 365" version is the one you want. It is the only one with ALL the nex features.
Thank you for the fantastic tip! All the time this saves will add up fast.
You are welcome, Sir!
Sir,
Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. You are the best. Thanks a lot to keep love and patience in your teaching field.
Thank you so much, Md. Monirul Islam!!! Thanks for the kind words : ) Thanks for the support with your Thumbs Ups, comments, Subscription and for telling all your friends about the free education at excelsifun : )
It's nice to be able to set the pivot table default.
This feature has made so many people happy :)
Happiness is good : )
Very short video but really useful ! Thanks
Thank you as always!!!
You are welcome, Sun K!!!!
Thanks a lot for this time saving trick 😊👌
Thank you Sir for your important lectures
You are welcome!
new versions of Excel keep making my old macros obsolete. LOL this is a prime example. Thanks much for sharing some of the new features I had not yet realized.
You are welcome : )
It's great how Microsoft listens to it's customer base.
They have changed a lot!!!!
Oh My God. You've just saved an amazing amout of time and clicks for me every day.
I love your channel and recomend you to everyone :-D
Very happy that my university hooked me up with a free copy of Excel ProPlus 365! Althought since i'm graduated I think the license will expire soon, but so far it hasn't.
The version that you want is Office 365 after you graduate. It will have everything.
Thank you mike!
Aw Man, all the awesome features are in 2016!!
Yes, that version is over 10 years old. The "Office 365" version is the one you want. It is the only one with ALL the nex features.
Hello and thank you for all this wonderful information. I’ve been enjoying learning. Looks like in options you can refresh each time you open a report. Is this an option you like?
Yes, yes!!! That is a great option : )
THANK YOU VERY MUCH SIR MIKE
Awesome vid, man! Thanks!
You are welcome, Rad Dude!
Thanks, Mike
You are welcome, Elmar! Are you using Office 365, so you can make this setting change?
great video, thanks sir
You are welcome!
Interesting as always :)
Glad it is interesting!!!
Thanks Mike! What a time-saver...terrific. Just to be clear, I think this PT default setting is for Excel overall, not just the current workbook, right?
Yes it is a setting for your computer.
Thank youuuuuu
You are welcome!!!!!
Thank you for all of your helpful videos. Is there a way to prevent Excel 2016 (Office 365) from creating sub fields for date fields when you drag a date field into the row or column section of a pivot table. For example, when dragging a date field the pivot table will automatically create a month, quarter and year sub field. As handy as it may be, I would like to turn it off as the default. Thank you.
The setting to turn it off in in Data Tab in Excel Options.
Thank you for the information. For some reason I do not have the Data tab in the Excel options area. When looking at your options in this video, I also noticed I don't have the "Ease of access" tab either. Is there another way to access the data tab without going to File\Options\Data? Maybe my ability to access the data options has been disabled? Any idea? Thank you for your help.
Dear Professor Girvin. First, thank you very much for the amazing videos.
I have a situation at work. I have a set of row data with about 32K rows and about 20 columns. It is not a continuous data. The data is scattered in different rows and columns. I tried to sort and filter it but it didn't work. When I tried to do a pivot table, the sum field doesn't' default to sum. Instead it does a count. I learned from you that that happens when there is a text. In this case it is not the case. Please advise on how to handle this project. Thank you very much.
Not sure. try this great Excel question site: mrexcel.com/forum
wow this will let us control our pivotable it's so cool i have 365 i can get it right?
Yes, only Office 365.
Hi Mike. Link to Full Written Notes says 'Page Not Found'. Thanks for all you do :)
Fixed! Thanks for helping me to edit : )
Dear Sir can I get from you copy for the "Slaying.Excel.Dragon" book .... thank you too much
I don't have digital version. I have only paper copy on my self. The publisher, Holy Macro Books sells them.
Sir,I'm unable to download the excel start and finished file ...has it been taken down?..i used to be able to but now i checked i coudn't .please dont remove them 😭😭😭😭😭
Hi, I am keep hearing about this new feature of setting default layout of pivlt table, but it doesn't work for me... I am using Excel 2016 (professional version) and it automatically updates itself, but I simply do not have this section in settings. Do you have an idea where the problem is?
It is Microsoft being Microsoft - by making it so confusing and hard for all of us. They have about 20 different options. I have no idea any more...
ExcelIsFun Ok, thank you for your response anyway
Good morning sir why I don't have data option in excel options is there any other way
Becasue that feature is only in Microsoft 365 Excel.
@@excelisfun I have EXCEL 365 but still i do not see Data option in excel options
Dear sir this my email ... if you can send me copy of Slaying.Excel.Dragon book
I don't have digital version. I have only paper copy on my self. The publisher, Holy Macro Books sells them.
REPLY