Microsoft Excel Pivot Tables Training Course Beginners Cambridge

Cambridge Beginners Microsoft Excel Pivot Tables Course Overview

Microsoft Excel Pivot Tables Training Course Beginners Kings College chapel Cambridge

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Beginners Microsoft Excel Pivot Tables Training Course at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with Pivot Tables preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.

Course Duration: 1 Day

Complete Course Outline

Pivot Table Formulas

If Function
SUMIF
Flash Fill
VLookup
Index Match Function

Tables

Creating Tables
Using Functions with Tables
Sorting Data in Tables
Adding & Deleting Rows
Converting a Table back to a Range

Pivot Tables

Creating a Pivot Table from existing data in Excel
Formatting Pivot Table Data
Filtering and Sorting Data in Pivot Tables
Dates and Pivot Tables
Slicers and Timelines
Connecting Pivot tables using Slicers
Timelines
Pivot Charts

PowerPivot

Installing PowerPivot
Adding a Table to PowerPivot

Performing Basic DAX calculations

Inserting a column in PowerPivot
Creating a calculated column
Formatting data in columns
Adding data from a text file
Creating relationships
Pivot Tables the PowerPivot way
Date calculations in DAX
Setting a Date Order
Calculated Fields
Year to Date function in DAX
Viewing Sales from previous day
Using a Calendar Table

Although this course is designed with Excel 2013 in mind, the principles used could be applied to 2010 & 2016 as well.

You may also be interested in the following courses:

Or the following training courses may be of interest:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel PowerPivot training course intermediate