#8 Advanced Pivot Tables Round 2

Learn and discuss Excel tips and techniques with Actuarial Info
Post Reply
User avatar
Site Admin
Posts: 253
Joined: 06 Oct 2017, 11:19
Status: Offline

05 Feb 2018, 13:10

This lesson picks up right where the last Pivot Table lesson left off.
 In this tutorial, you will learn:
  • How to use multiple levels of data within row or column labels.
  • Expand / collapse all functionality through right-click (Expand / collapse entire field)
  • Advanced filtering options including: right-click, row label, column label, and report filters. Includes multiple simultaneous filters, and using search/filter functionality within each data level.
  • ‘Defer Layout Update’ option which allows for changing fields without pivot table automatically updating.
  • Fields Section / Areas Section Stacked vs. Other Pivot Field List Formats.
Make sure to download the Advanced Pivot Tables – Round 2 workbook to follow along with the lesson!

Content From: Excel Exposure

If unwatchable, please click here.
Mayank Goyal

Post Reply
Actuarial Blogs Insurology

icon icon