Microsoft Excel Pivot Tables Training Course Beginners Leicester

Leicester Beginners Microsoft Excel Pivot Tables Course Overview

Beginners Microsoft Excel Pivot Tables Training Course training course Leicester

Leicester boasts a multicultural atmosphere and is famous for its association with King Richard III.

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Beginners Microsoft Excel Pivot Tables Training Course.

Alternatively if you live in and around Leicester and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

There are many other computer training courses in Leicester. Please take the time to look through them.

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