Excel Pivot Table Course, The Magic Cube for Excel Data, 1 Hour Online

Excel Pivot Tables is most likely the easiest and quickest way to get brilliant insight to your business KPI's by analysing data.
About this Event

EXCEL PIVOT TABLES IN 45 MINUTES COURSE

Powerfule data insight in minues:

Pivot Tables are really very easy to create, but very very powerful. By using Excel Pivot Tables, one can get very interesting and valuable business intelligence from your data, in very little time.

This short session aims to give you the techniques to use this valuable Excel tool creatively.

It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.

The session runs every Friday morning, and hopefully won't distract too much from your working day.

Course Outline:

• Create an Excel Pivot Table in 10 Minutes 
• Changing a Pivot Table 
• Formatting a Pivot Table 
• Sorting by values or categories
• Grouping Dates
• Filter
• Slicers to add interactive filters
• Creating additional formulae 
• Create a Pivot Charts 
• Changing a Pivot Table and more...

You will have time to discuss and ask questions

WHAT IS INCLUDED:

• Certificate on completion 
• Course notes, Practical Class exercises, Homework Excercises
• After the course, 1 free online revision / questions session 
• Max group size is 4. 

Agenda
Excel Pivots to Visualise the Key Achievements of your Business
🕑: 09:00 AM - 09:05 AM
Intro's
🕑: 09:05 AM - 09:50 AM
Excel Pivot tables training sessions and demos
🕑: 09:50 AM - 10:00 AM
Questions