Advanced Excel for Professionals

Date

22.03.2024 (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

Learn the best ways to use Microsoft Excel for data analysis, reporting and modeling for decision making using real-world business scenarios. Designed for supervisors, managers or team members who need to summarise, report and analyse data, this course will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarise data using histograms and PivotTables, estimate business variables using trend curves and present the data.

Course Structure

This course is split over the following modules:

Advanced Functions:

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

What-If:

  • Scenarios and Scenario management
  • Goal Seek

Working with Data:

  • Advanced Relative & Absolute Cell References
  • Restricting Cell Entries to Certain Data Types
  • Data Validation Tools

Using Formulas:

  • Introduce XLOOKUP function
  • Advanced Date Functions (take into consideration weekends & PHs)

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

Power Query:

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

Should Attend

This course is ideal for any person interested in enhancing their Excel skills.

Prerequisites

Applicants should have completed Excel Intermediate Level.

Assessment

There is no final assessment. Students will be guided during the course.

Key Features

There are no key features

Course Structure

This course is split over the following modules:

Advanced Functions:

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

What-If:

  • Scenarios and Scenario management
  • Goal Seek

Working with Data:

  • Advanced Relative & Absolute Cell References
  • Restricting Cell Entries to Certain Data Types
  • Data Validation Tools

Using Formulas:

  • Introduce XLOOKUP function
  • Advanced Date Functions (take into consideration weekends & PHs)

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

Power Query:

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

Should Attend

This course is ideal for any person interested in enhancing their Excel skills.

Prerequisites

Applicants should have completed Excel Intermediate Level.

Assessment

There is no final assessment. Students will be guided during the course.

Key Features

There are no key features

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.