Advanced Excel with Copilot elements

Date

18/03/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

This course covers a wide range of advanced Excel functionalities and techniques, designed to enhance your data management, analysis and automation skills. Learn the best ways to use Microsoft Excel for data analysis, reporting and modeling for decision making using real-world business scenarios. More importantly, specific aspects of the syllabus will be executed using copilot in excel, further enhancing efficiency.

The course is composed of 5 modules, as per below:

  • Advanced Functions
  • Working with Data and Real-Time Collaboration
  • Advanced Data Analysis and Presentation
  • Power Query
  • Integration with other tools

Course Structure

This course is split over the following 5 modules:

Advanced Functions

  • Name Manager, Naming Ranges and Using them in Formulas
  • Formula Auditing
  • SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS

Working with Data and Real-Time Collaboration

  • Advanced Relative & Absolute Cell References
  • Restricting Cell Entries to Certain Data Types
  • Data Validation Tools
  • Real-Time Collaboration Features

Advanced Data Analysis and Presentation

  • Using Sparklines
  • Advanced PivotTables
  • Grouping Data to analyse data by Year/Quarter/Month
  • Summarise/calculations embedded in Pivot Tables
  • Introduce, create, and manage Slicers
  • Create and manage multiple PivotCharts
  • Manipulating options in existing PivotCharts
  • Multiple PivotTables linked to the same slicer
  • Building a BI Dashboard
  • Advanced Charting Techniques

Power Query

  • Get Data
  • Transform Data
  • Load Data
  • Create relationships between tables

Integration with other tools

  • Integration with Power BI
  • Using Excel with Power Automate
  • Data Import and Export

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.