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?
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
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
Excel
Excel Guru
MS Office