Power Pivot

This Pivot Tables and Power Pivot will provide the delegate with the necessary skills to analyse vast amounts of data efficiently and effectively. This course builds on the grounding which was learnt in our Excel Advanced courses. On completion the delegates will be in the top 5% of Excel users in Southern Africa.

Microsoft Excel 2016 – Using Pivot Tables and Power Pivot

If you have been using Excel for some time now and have looked at Pivot Tables which is covered in our Excel Advanced course also in Excel for Mac but don’t really know how to use them or take them further, then this two-day course covers features for experienced users of Microsoft Excel. It looks specifically at how to get the best from Excel’s Pivot Tables. It also looks at how to use Power Pivot, which is the add-in now included with Microsoft Excel.

Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area?

What This Course Covers

Create dashboards
Create row formulas in tables
Understand the difference the difference between an Excel Table and an Excel Range
Create PivotTables and PivotCharts
Work with slicers and timelines to filter information
Define table relationships
Create PivotTables connected to multiple tables
Work with Data Models
Use date tables for grouping pivot data
Invoke the RELATED and CALCULATE DAX functions
Create PivotTables hierarchies
Use Key Performance Indicators in PivotTables

Who would benefit from this course?

This course is designed for people who are looking to use Pivot Tables and Power Pivot to process large amounts of data into meaningful information for business intelligence and analysis. If you want to learn how to work with macros then the Automating Excel using Macros and VBA course would be more beneficial.

Pre-requisites

A good understanding of Microsoft Excel 2016 is required, or attendance onour Famous Executive Excel advanced user course. Johannesburg, Cape Town and Durban dates on request. Onsite training dates are flexible. Minimum of four delegates attending simultaneously. T&C’s apply.

Not your area? Please contact Arnold 083 778 4903 for a quotation.

R 6995 ex vat, including teas, light lunch, manuals and an electronic certificate. Group pricing is available.

Reasons to attend this Course

It is better than Vlookup
Lightning calculations. Nothing is Faster!
Billions of Rows
Data Feeds
DashBoards are easy to create.
You want to Discover your Potential

This courses will prepare the delegate for more advanced Excel and Power Pivot Courses. The delegate receives a manual and an electronic attendance certificate on completion of the relevant Excel and Power Pivot Course.

We almost run on demand as we try to accommodate the client’s work schedule when possible. Contact Arnold + 27 083 778 4903 or email [email protected] for dates in your area?

ON and OFFSITE training are offered. See our Specials for Gauteng & KZN, other areas call Arnold 083 7784903. Offsite includes teas, light lunch, and an electronic attendance certificate. Group discounts apply. ONSITE, YOUR VENUE, a minimum of three delegates attending simultaneously. Prices on request.

More resources about Power Pivot

Microsoft 

We provide training throughout Southern Africa and have offices in all the major cities.

Johannesburg, Pretoria, Sandton, Midrand, Centurion, Roodepoort, Edenvale, Durban, Umhlanga, Cape Town. "Other Areas on Request"

You May Also Like

MS Excel

Excel

MS Excel software package has different levels which cover many courses.
MS Excel

Excel Guru

Excel Guru software package has different levels which cover many courses.
MS Excel

MS Office

MS Office software package has different levels which cover many courses.
MS Excel

Soft Skills

Soft Skills software package has different levels which cover many courses.
Skip to content