Advanced users of Excel are very familiar with various features of Pivot tables & can use them really well.

Some of the advanced pivot table features are – grouping, slicers, calculations & summary by different type of metrics.

Advanced: Collaborate with others using workbooks; Audit worksheets; Work with multiple workbooks; Import & export data; Use Excel with the web; Structure workbooks with XML.

consolidating multiple excel workbooks-16consolidating multiple excel workbooks-75consolidating multiple excel workbooks-8

They can combine formulas with conditional formatting to highlight data that meets almost any condition.

Introduction 5 Tips on CF Highlighting Duplicates More There is no use if all your analysis is buried in a massive spreadsheet.

Courses can also be presented at an off-site venue according to the client’s needs. VAT) Workshop 1: Unravelling BI & SQL Basics: 1 Day; R2 250 per delegate Workshop 2: From Pivots to Power Pivots: 2 Days; R4 500 per delegate Workshop 3: Dashboarding, Reporting & Share Point Collaboration: 1 Day; R2 250 per delegate *Workshop 2 is a prerequisite for Workshop 3 All 3 Workshops R9 000 per delegate per booking Group bookings receive 10% discount!

While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas.

But by using formulas, you can crunch data, analyze it and get answers to most complex questions.

Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion (and they also know few alternatives for any given formula problem).

Each class day: Informal discussion with instructor about your projects or areas of special interest p.m. This course is approved by PMI® for 11 professional development units (PDUs).

This course is offered in a series of three levels with the objective to increase the level of skills required in the workplace or for a particular job.

Technical : 7 PDUs Business & Strategic : 4 PDUs Read more ...