Microsoft Excel 2013 PowerPivot Training Course Beginners Cambridge

Cambridge Beginners Microsoft Excel 2013 PowerPivot Course Overview

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 2013 PowerPivot 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 PowerPivot 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

Getting Started with Microsoft Excel 2013 PowerPivot

• Explore the PowerPivot 2013 Application
• Import Data from Various Data Sources
• Refresh Data from a Data Source
• Create Linked Tables

Manipulating PowerPivot Data

• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Create and Manage Table Relationships

Creating PowerPivot Reports

• Create a PivotTable
• Create PivotCharts
• Filter Data Using Slicers
• Present PivotTable Data Visually
• Creating Hierarchies

Using DAX Functions in PowerPivot

• Manipulate PowerPivot Data using DAX Functions
• Extract Data from Tables Using Functions
• Work with Time Dependent Data

Distributing PowerPivot Data

• Protect Reports
• Save Reports in Different File Formats

Have a look at our range of Excel Training Courses

Other Microsoft Excel training days you may be interested in:

Microsoft Excel 2013 PowerPivot Training Course - Intermediate Advanced

Microsoft Excel 2013 Training Course - Advanced

Microsoft Excel 2010 PowerPivot Training Course

Microsoft Excel 2010 Training Course - Advanced

Microsoft Excel 2010 VBA Training Course