About this course
A pivot table is a reporting tool that produces 3D reports from spread sheet data. This session covers the more advanced features of Pivot Tables. Participants should be able to create a basic Pivot Table or have attended the Introduction virtual session.
Duration: 1 hour
Method of Delivery: Virtual
What you will learn
· Review of the steps to create a Pivot Table
· Pivot Table Options for Formats, Totals and Filters, Display, Printing and Data options
· Update and refresh a pivot table when the source data is changed
· Sorting Field Items
· Grouping Fields (Date fields / Numeric fields)
· Turning on / off subtotals in the Table
· Create a Pivot Chart
· Field Settings for data analysis within the Table
· Creating Formulas in the Table – Calculated Fields / Calculated Items
· Drilldown options
· Using the Design options
· Creating a Pivot Chart
· Chart options
· Using Slicers and Timelines with a Pivot Table
Recent reviews
Very informative, great course, learned a lot.
Advanced functions explained really well, easy to step through.
Well explained and asked plenty of questions