Excel - Pivot Table Defaults: Episode 1461
2,067 views · Published 1 November 2011 · 6:24 · Indexed 1 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Introducing the Ultimate Solution for Pivot Table Defaults | MrExcel Podcast. Welcome to episode 1461 of the MrExcel podcast, where we will be discussing the common frustration of pivot table defaults. Have you ever wondered why there are chart templates, but not pivot table templates? Well, after receiving numerous requests from my seminar attendees, I decided to take matters into my own hands and create a solution. Introducing the MrExcel Labs, a collection of small programs designed to make your life easier. In this episode, I will be sharing my progress on the new add-in that aims to solve all your pivot table annoyances. But first, I want to hear from you. What drives you crazy about pivot tables? Is it the compact view, the empty cells showing as blanks, or the incorrect formatting? Send me your ideas at [email protected] and if your suggestion is included in the add-in, you will receive a free copy upon its release. So far, the add-in includes features such as creating pivot tables with tabular view instead of compact layout, automatically filling in item labels, and showing empty cells as zero. But the most controversial feature is the option to resize columns and carry over formatting from the original fields. I'll be discussing the pros and cons of these features and would love to hear your thoughts on them. In this episode, I will also be giving you a sneak peek of the add-in in action. With just a click of a button, you can create a pivot table with your preferred default settings. No more wasting time changing the layout or formatting. And for just a few bucks, this add-in will save you from all the frustration and annoyance caused by pivot table defaults. So, whether you're using Excel 2003, 2007, 2010, or even a Mac, this add-in will work for you. Just make sure to let me know your Excel version when you send in your suggestions. I am excited to hear your feedback and make this add-in the ultimate solution for all your pivot table woes. Thank you for tuning in and don't forget to subscribe to the MrExcel podcast for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Pivot Table Defaults (00:19) Need for Pivot Table Templates (00:51) Goal of Add-In and Request for Feedback (01:25) Current Features of Add-In (02:12) Demonstration of Add-In (03:20) Controversial Features and Request for Feedback (05:00) How to Provide Feedback and Free Copy of Add-In (05:50) Compatibility and VBA Considerations (06:06) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Annoyances with Pivot Tables Applying Formatting Carrying Formatting from Original Fields Compact View Default Pivot Table Format Empty Cells Show Zero Less Stupid Pivot Defaults Makin' Excel Easier MrExcel Labs Pivot Table Template Resizing Columns Tabular View Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153139/ 1. Why can't we do a Pivot Table Template? 2. Why can't we turn off the annoying Compact Layout? 3. Why do I keep asking these questions when it is so easy to override them with a tiny add-in? The MrExcel Labs is coming out with a tiny add-in to solve Pivot Table Annoyances. This is your chance to weigh in with what 'Pivot Things' annoy you most and you can win a free copy of the add-in. Watch the podcast [Episode #1461] and find out all of the details! ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920