About this Course

Pivot table is one of the most powerful features of Excel, yet few users use them in their Day-to-day activities. PivotTable reports are especially well-suited for taking large amounts of data and summarising it into useful reports.

For some, pivot tables have always been too intimidating and for others, pivot tables are still unknown. With a little instruction and guidance, you will be able to use pivot tables to accomplish routine analysis and reporting that you have never ever thought of.

This course will begin with basic pivot tables and progresses to advanced pivot table topics covering insights into the inner workings of Pivot Tables, enabling analysis and preparation of reports to solve pressing business needs.

Objectives

Upon completion of this workshop, participants will be able to;

• Understand how and when to use pivot tables
  
• Automate pivot tables by connecting them to external databases
  
• Create basic and advanced Excel pivot tables
  
• Create cross tabulations and other associated advanced features
  
• Customise fields in a pivot table
  
• Format and print your pivot table report
  
• Group and perform calculations and its associated advanced options
  
• Perform calculations within pivot tables
  
• Building and automating business performance dashboards
  
• Structure and format your tables of raw data to easily allow for data analysis using pivot tables and pivot charts
  

Target Audience

This course would benefit anyone who needs to use Pivot Table Analysis Techniques to more complex data sets. Managers and Executives who have to manage, analyse and prepare reports will find this course most beneficial. Participants should have a strong grounding in Excel basic to intermediate knowledge, i.e. Navigate around a worksheet, format Cells, Auto Filter, Sorting, Simple Template Creation and Enter Simple Formulas.

Duration

One day

Methodologies

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Rate this course:

Log in to submit

Comments