Come and learn how to go “above and beyond” the basics of creating a PivotTable.  Learn how to customize PivotTable fields.  Use Grouping and Filtering to arrange data in ways to meet your business needs.

Please complete all the parts of this self-assessment and based on the outcome, decide for yourself whether or not you have the pre-requisite knowledge to take this course.  If you have any questions or wish to register, email:  rob@ppical.com  or call Rob at:  (403) 269-6619.

You will find the course description below.

Should I Attend
This Workshop?

I can type a list in a spreadsheet?

^Yes  

^No  

I can add a column or row using the Sum function?

^Yes  

^No  

I can create formulas that add, subtract, multiply or divide?

^Yes  

^No  

Result: If you answered no to any of these questions, the Power Series Workshop will be too advanced for you. We recommend that you attend the Productivity Point Advanced course before this workshop.

My job requires me to summarize information stored in a list or a database?

^Yes  

^No  

My job requires me to compare data by category or group?

^Yes  

^No  

I need to summarize data by groups of dates or times?

^Yes  

^No  

Result: If you answered yes to any of these questions, you have the required skills and will benefit from attending this workshop.

 1/2 day Instructor-Led Course

Who should attend?

• Users who need to create reports based on data that is stored in a database or a list.
• Users who need a quick and easy way to summarize financial data, statistical data, or lists of transactions
• Users who need to explore complex data relationships quickly and easily

In this course we will:

• Discuss Data Preparation for PivotTables

• Create and Reorganize PivotTables

• Format a PivotTable

• Set up a Custom Sort Order

• Customize the PivotTable Fields

• Filter and Hide Data

• Use Grouping

• Insert Calculated Fields

• Create PivotCharts Reports

• Use the GETPIVOTDATA Function

What students receive

Each student receives a copy of the Power Series Student Manual and/or handouts for post-class reference.