Microsoft Excel Pivot Tables Training Course Beginners Heathrow

Heathrow Beginners Microsoft Excel Pivot Tables Course Overview

Microsoft Excel Pivot Tables Training Course Beginners training Heathrow

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a Microsoft Excel Pivot Tables Training Course Beginners training course near Heathrow airport could be the ideal solution.

The Microsoft Excel Pivot Tables Training Course Beginners course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Beginners Pivot Tables training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.

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