Courses Microsoft Excel Power Pivot Course in London

Audience: For basic Excel users who need an overview of the power of Pivot Tables. Excel Pivot Tables give you the power to analyse raw data stored in worksheets with ease. If you only know how to do aggregate calculations with functions like SUMIF then you are missing out on a major element of Excel

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office Suite.

Course Types: Group Bookings, Public Scheduled Courses, 1-2-1 Sessions, Bespoke Tailored Courses and Saturday Club.

Course Costs:

Public Courses : £125 +VAT      Next Scheduled Course Please call for details
Group Rate: £ 695 + VAT
1-2-1 Rate £ 450 + VAT
Saver Discount 3 for 2 on all public courses.

MOS Excel Specialist / Expert Exam Costs ( optional )

New Prices from 19th February 2018

All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs 

View Scheduled Public Courses

Course Location: This Microsoft Excel Pivot Tables  Course is delivered at our training centres our London Venues; training can also be delivered at your offices. 

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

• Navigate the Power Pivot window
• Specify source data for Power Pivot
• Preparing data for analysis
• Format data
• Create Power Pivot Relationships
• Enter Power Pivot Calculations using DAX
• Create Key Performance Indicators (KPI's)
• Visualise data using Power View
• Create Power View Charts and Maps

Detailed Course Outlines

Office 2010 Excel PowerPivot 2010
Office 2010 Excel 2010 DAX (Data Analysis Expressions) formulas for PowerPivot


Office 2013 Microsoft Excel 2013 Power Pivot and Power View
Office 2013 Microsoft Excel 2013 DAX formulas for Power Pivot

Office 2016 Microsoft Excel 2016 Power Pivot and Power View
Office 2016 Microsoft Excel 2016 DAX (Data Analysis Expressions) formulas for Power Pivot

Charis Alexandra Training Course Index

Contact Email 

For Further Course Details Visit Our Homepage

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London