Intermediate Excel with Copilot elements

Date

24/04/2025 (1 day)

Time

09:00 till 16:00

CPE Hours

6 hours

Competency

Professional

Location

The Hub, PwC Academy or online

Price

€275

Course Description

Candidates will unlock the potential of Excel with our NEW Intermediate Excel for Professionals Course. This course is designed to take your Excel skills to the next level, covering advanced techniques and tools that will enhance your data analysis and visualisation capabilities. Moreover, specific aspects of the syllabus will be executed using copilot in excel, further enhancing efficiency.

The course is divided into four modules, as follows:

  • Advanced Visualisation Techniques
  • Data Cleaning and Preparation
  • Advanced Formulas and Functions
  • Power Query and Power Pivot

Having practiced all of these new skills extensively to handle complex data tasks 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 and with ease.

Course Structure

This course is split over the following 4 modules:

Advanced Visualisation Techniques

  • Custom Data Visualisations
  • Advanced Charting Features (Power Charts)

Data Cleaning and Preparation

  • Removing Duplicates
  • Text Functions to standardise text data
  • Date and Time Fixes
  • Power Query to automate data cleaning tasks
  • Implementing a Data Quality FRamework

Advanced Formulas and Functions

  • Mastering Lookup Functions
  • Using Array Formulas
  • Applying Statistical Functions
  • Applying Text Functions
  • Error Handling

Power Query and Power Pivot

  • Data Import and Transformation using Power Query
  • Creating and managing data models in Power Pivot
  • DAX Functions for Data Analysis
  • Building Interactive Reports and Dashboards with Power Pivot and Power Query
  • Applications in Real-World Scenarios to drive Business Intelligence

Register Your Interest:

    I would like to receive more information about PwC’s Academy training.

    Funding Schemes Available

    Funding for Individuals

    Find out how you could get up to 70% of your course fees back.

    Funding for Corporates

    Discover our funding options for businesses and find out how you and your employees could benefit.