Intermediate Excel for Professionals

Date

04.10.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

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.

Course Structure

This course is split over the following modules:

Apply Fill Tools, Conditional Formatting and Filtering:

  • Using advanced Fill Series options (Flash Fill)
  • Advanced Filtering
  • Apply conditional formatting
  • Managing conditional formatting rules
  • Conditional Formatting with Sorting and Filtering

Working with Data:

  • Sorting Data on a Single and Multiple Criteria
  • Sorting Data Using Cell Attributes
  • Using AutoFilter
  • Filtering Data Using Cell Attributes

Using Formulas:

  • Apply functions in formulas
  • Functions Wizard
  • Absolute vs Relative Referencing
  • Using SUM, COUNT, SUBTOTAL
  • Using the IF, AND, and OR functions
  • Using the NOW and TODAY functions
  • Using text manipulation functions like LEFT, RIGHT, MID, TRIM, CONCATENATE
  • Using the VLOOKUP function

Data Analysis and Manipulation using PivotTables and PivotCharts:

  • Create and manage PivotTables
  • Modifying field selections and options
  • Filters in PivotTables
  • Create and manage PivotCharts
  • Manipulating options in existing PivotCharts
  • Multiple PivotTables on same Sheet
  • Applying styles to PivotCharts

Should Attend

Any person interested in enhancing their Excel skills is eligible for this course.

Prerequisites

A foundation in basic Excel techniques is advised.

Assessment

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

Key-Features

Objectives

By the end of this course 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.
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.

Course Structure

This course is split over the following modules:

Apply Fill Tools, Conditional Formatting and Filtering:

  • Using advanced Fill Series options (Flash Fill)
  • Advanced Filtering
  • Apply conditional formatting
  • Managing conditional formatting rules
  • Conditional Formatting with Sorting and Filtering

Working with Data:

  • Sorting Data on a Single and Multiple Criteria
  • Sorting Data Using Cell Attributes
  • Using AutoFilter
  • Filtering Data Using Cell Attributes

Using Formulas:

  • Apply functions in formulas
  • Functions Wizard
  • Absolute vs Relative Referencing
  • Using SUM, COUNT, SUBTOTAL
  • Using the IF, AND, and OR functions
  • Using the NOW and TODAY functions
  • Using text manipulation functions like LEFT, RIGHT, MID, TRIM, CONCATENATE
  • Using the VLOOKUP function

Data Analysis and Manipulation using PivotTables and PivotCharts:

  • Create and manage PivotTables
  • Modifying field selections and options
  • Filters in PivotTables
  • Create and manage PivotCharts
  • Manipulating options in existing PivotCharts
  • Multiple PivotTables on same Sheet
  • Applying styles to PivotCharts

Should Attend

Any person interested in enhancing their Excel skills is eligible for this course.

Prerequisites

A foundation in basic Excel techniques is advised.

Assessment

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

Key-Features

Objectives

By the end of this course 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.
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.

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.