Audience: This course is intended for Excel users who are seeking 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 do not know how to do aggregate calculations with functions like SUMIF then you are missing out on a major element of Excel.
Course Duration: I-day day
Course Types: Group Bookings, Public Scheduled Courses, 1-2-1 Sessions, Bespoke Tailored Courses.
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
View Scheduled Public Courses
Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.
Course Location: This Microsoft Excel Pivot Tables Course is delivered at our training centres in London Venues; training can also be delivered at your offices.
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
Discount 4 for 3 on MOS Exam Packs
View Scheduled Public Courses
Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.
Course Location: This Microsoft Excel Pivot Tables Course is delivered at our training centres in London Venues; training can also be delivered at your offices.
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
Course Outlines
Excel PowerPivot 2010
Microsoft Excel 2010 DAX (Data Analysis Expressions) formulas for PowerPivot
Microsoft Excel 2013 Power Pivot and Power View
Microsoft Excel 2013 DAX formulas for Power Pivot
Microsoft Excel 2016 Power Pivot and Power View
Microsoft Excel 2016 DAX (Data Analysis Expressions) formulas for Power Pivot
Excel PowerPivot 2010
Microsoft Excel 2010 DAX (Data Analysis Expressions) formulas for PowerPivot
Microsoft Excel 2013 Power Pivot and Power View
Microsoft Excel 2013 DAX formulas for Power Pivot
Microsoft Excel 2016 Power Pivot and Power View
Microsoft Excel 2016 DAX (Data Analysis Expressions) formulas for Power Pivot
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
No comments:
Post a Comment