5 Pivot Table Productivity Tricks

Pivot Tables are great. You can create summary reports with just a few clicks. But there’s a bunch of annoyances in there too and in this video I show you just how simple it is to fix them. Specifically I cover how to…

• Stop your custom column widths resetting
• Prevent end-users getting access to the underlying data
• Generate multiple Pivot Tables with a single click
• Avoid retyping custom headings when you change the layout
• Customize the default settings for future Pivot Tables
  

Links to the video and individual sections below:

Introduction

Stop your custom column widths resetting

Prevent end-users getting access to the underlying data

Generate multiple Pivot Tables with a single click

Avoid retyping custom headings when you change the layout

Customize the default settings for future Pivot Tables