Loading Events

« All Events

  • This event has passed.
Event Series Event Series: Pivot Tables Deep Dive

Pivot Tables Deep Dive

January 4 @ 9:30 am - 4:30 pm

In this ‘Deep Dive’ topic, we will devote the full day to exploring Pitvot Tables and how they can be used for Data Analysis. We recommend that you have a basic to intermediate understanding of Microsoft Excel but no prior knowledge of Pivot Tables is required.

What you will learn:

  • Introduction to pivot tables
  • Convert data to tables
  • Adjust field list settings
  • Create multiple reports with one click
  • Add data bars to pivot tables
  • Master pivot table settings
  • Add and remove calculated fields to pivot tables
  • Calculate the difference between columns
  • Add smart custom number formatting
  • Create custom groupings to pivot tables
  • Group dates as unique
  • Add slicers to easily filter data
  • Add dynamic charts
  • Add a timeline to pivot tables
  • Introduction to Microsoft Power Pivot

This seminar is also available on demand by virtual classroom. Contact us for more details. 

Details

Date:
January 4
Time:
9:30 am - 4:30 pm
Series:
Event Categories:
, ,

Organiser

Pitman Training Centre – Glasgow
Phone
0141 223 0090
Email
glasgow@pitman-training.net

Venue

Glasgow
First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
+ Google Map
Phone
0141 223 0090