Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel PivotTables - Change the default layout by Chris Menard. That video is uploaded by Chris Menard at 2019-11-10T10:07:56-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [j_dCfsElr_0]
| Name | Excel PivotTables - Change the default layout by Chris Menard |
| Video Uploader | Video From Chris Menard |
| Upload Date | This Video Uploaded At 10-11-2019 18:07:56 |
| Video Discription | Change the default layout for PivotTables in Excel as follows. You can add blank rows, show subtotals at the bottom, and only show grand totals for rows or columns. This is only available with an Office 365 subscription or Office 2019. It is not available with Office 2016. If you go to File - Options and see the Data category, this feature is available. If not, this feature is not available. Here is a screenshot of the data category. https://drive.google.com/file/d/1_20IxpAjPIjg2gtxt8cnAkyNVr9r0sRs/view?usp=drivesdk Chris Menard will be speaking to The Georgia Society of CPAs about this feature in detail on November 19. 2019 at the Cobb Gallery Energy Center. Chris Menard is a featured speaker for the GSPCA and will do two (2) sessions at the Business & Industry Conference. Conference webpage for registration: http://www.gscpa.org/Public/Catalog/CourseDetails.aspx?courseID=1913046 #pivottables #excelpivottables #exceltutorial Chris Menard's Website is https://chrismenardtraining.com And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week! j_dCfsElr_0 |
| Category | Howto & Style |
| Tags | pivottables | office 365 | o365 | blank row | excel tutorial | pivot table | office 365 pivottables | pivottable default layout | office365 | office 365 tutorial for beginners | office 365 tutorial | excel pivottables layout | excel pivottables tutorial | excel | pivot tables | display options | pivottable layout | pivot table layout options | pivot table layout | pivot table layout change | pivot table layout columns | design the layout and format of a pivot table |
