Pragmatic Excel - Intermediate Pivot Tables

In this presentation Excel expert David Ringstrom, CPA, takes you beyond the basics of pivot tables, which are a report writing feature in Microsoft Excel. You'll see how to transform unwieldy reports into pivot table-ready lists. David will then show how you can drill down into the ...

On demand, 2 hour(s)

$99 ($199)

()

Register Now


Course Description

Who should attend:

Practitioners who can benefit from learning how to manipulate their pivot table data faster and more efficiently.

 Topics covered:

• Presenting the largest or smallest values in chart form by way of a Top 10 pivot chart.

• Adding fields to a blank pivot table to create instant reports.

• Filtering pivot table data based on a new dimension by using the Report Filter command.

• Managing information overload by collapsing or expanding pivot table fields.

• Utilizing the Tabular Format command to display pivot table data in two or more columns instead of a single column in Compact Form.

• Distinguishing the differences among pivot table-related menus in Excel 2013 and later versus older versions of Excel.

• Re-positioning or removing subtotals within pivot tables.

• Contrasting sorting data within worksheets to the nuances of sorting data within pivot tables.

• Identifying the ideal data for analysis with Excel’s PivotTable feature.

• Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook.

• Auditing the data source behind pivot tables in Excel spreadsheets.

• Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook.

Learning objectives:

• Identify the location of the Field List command within Excel's ribbon menu interface.

• Identify the location of the PivotTable command within Excel's ribbon menu interface.

• Recall the requirement that enables the Show Report Filter Pages command.

 

Level:

Intermediate


Course Walkthrough

  • Course: Pragmatic Excel - Intermediate Pivot Tables
  • CPD Quiz - Pragmatic Excel - Intermediate Pivot Tables
  • Intermediate Pivot Tables - Slides
  • Intermediate Pivot Tables - Sample File
  • Intermediate Pivot Tables - Participant Q&A
  • Feedback / comments
  • Certificate - Intermediate Pivot Tables

About the Instructor(s)

Picture of David Ringstrom
David Ringstrom