Take this course

Advanced Excel for Professionals

Date

13/4/2022

Time

Not Available

CPE Hours

6 hours

Competency

Professional

Location

The Hub, PwC Academy/ Hybrid

Price

€260

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 summarize, report and analyze data, this course
will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarize 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
  • INDEX & MATCH Lookup functions
  • What-If:
  • Scenarios and Scenario management
  • Goal Seek
  • Advanced Data Analysis and Presentation:
  • Using Sparklines
  • Create and manage PivotTables
  • Filters in PivotTables
  • Creating and managing Slicers
  • Create and manage PivotCharts
  • Manipulating options in existing PivotCharts
  • Multiple PivotTables on same WorkSheet
  • Grouping Data to analyse data by Year/Quarter/Month
  • Building a BI Dashboard
  • Trend Analysis:
  • Using Scatter Charts and Trend Analysis
  • Automating processes with Macros:
  • Recording and Running Basic Macros
  • Saving Work with Macros

Should Attend

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

Prerequisites

Applicants should have completed Excel Intermediate Level.

Assessment

Not Available

Key Features

Not Available

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
  • INDEX & MATCH Lookup functions
  • What-If:
  • Scenarios and Scenario management
  • Goal Seek
  • Advanced Data Analysis and Presentation:
  • Using Sparklines
  • Create and manage PivotTables
  • Filters in PivotTables
  • Creating and managing Slicers
  • Create and manage PivotCharts
  • Manipulating options in existing PivotCharts
  • Multiple PivotTables on same WorkSheet
  • Grouping Data to analyse data by Year/Quarter/Month
  • Building a BI Dashboard
  • Trend Analysis:
  • Using Scatter Charts and Trend Analysis
  • Automating processes with Macros:
  • Recording and Running Basic Macros
  • Saving Work with Macros

Should Attend

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

Prerequisites

Applicants should have completed Excel Intermediate Level.

Assessment

Not Available

Key Features

Not Available

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.