Date: 3rd and 4th June 2021
Time: 09:00 – 12:00
Location: Online | Virtual instructor-led
CPE Hours: 6 hours total – Professional
Price: EUR 230
Registration Link: www.pwc.com/Mt/academy or mt.academy@pwc.com
Prerequisites
A foundation in basic Excel techniques is advised.
Objectives
In two days, 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.
Certifications
Attending delegates will be presented with a Certificate of Attendance upon completion of training.
Training Methodology
We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our delegates and can be applied directly in the training. Training sessions are conducted as hands-on workshops.
Each delegate will be given a digital courseware manual to refer to after the course.
Apply Fill Tools, Conditional Formatting and Filtering
Working with Data
Using Formulas
Data Analysis & and Manipulation using PivotTables & PivotCharts