Skip to content Skip to footer

Loading Results

Intermediate Data and Analytics courses

at PwC's Academy


The intermediate course offered is ideal if you are familiar with the basic spreadsheet tools and entry-level concepts in analytical functions found in Microsoft Excel. The course provides you with the relevant tools and techniques to solve data problems more efficiently. This course also introduces the new features in the latest Microsoft Excel version. The topics covered include conditional formatting wizard, flash fill, name manager, various functions, pivot tables, slicers and pivot charts. As part of this course you will practice new skills extensively within the PwC's Academy lab environment. The intermediate course you enable you to return to work environment using data more proficiently.


Intermediate Excel for Professionals

By the end of this course candidates will master the techniques of using the right excel tools to solve problems more efficiently. Also new features in the current Excel version will be highlighted.

Topics covered include Conditional Formatting wizard, Flash Fill, Name Manager, various functions (string, maths, logical, lookup), pivot tables, slicers and pivot charts to build a BI dashboard.

Having practiced all of these new skills extensively during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more proficiently.

Starting: 23 September 2021

View course details

Book a free consultation

Explore more course levels

In collaboration with

Follow us