Excel Advanced

Duration: 6 Hrs ( 2 @ 3 hr sessions )

This course explains how to use Microsoft Excel for Advanced spreadsheet tasks and operations.

Level – Advanced

This course is intended for those who are experienced in Excel or have completed the Intermediate level course.

Live Virtual Training Dates

Why not attend one of our scheduled Live Virtual Training Dates

 

Excel Advanced Course Details

Course Objectives

This course explains how to use Microsoft Excel for Advanced spreadsheet tasks.

This course is intended for those who are experienced in Excel or have completed the Intermediate level course.

We learn how to work with Excel Formula and Functions, analyse spreadsheets with tools such as Pivot Tables, What If Analysis, etc

Course Content

 The Excel Environment

Creating and Managing Tables

 Advanced formulas and functions

 Database Functions

 Text Functions – Trim, Proper

 Lookup formula – VLOOKUP, XLookup

 Array Formulas

 Advanced List management

 Intro to Power Query – Get and Transform

 Pivot Tables and Power Pivot

 What If Analysis – Scenarios, Goal Seek

 Working with Macros

Classroom Training - Scheduled Dates and Booking

Due to Current Covid-19 restrictions we have postponed all classroom-based training courses.

We will reschedule Excel training courses as soon as it is practical to resume in-class training.

In the meantime we offer the same Excel courses on a Live Virtual Training basis.

Please see below for scheduled dates and information.

Live Virtual Training Bookings

Dates, Fees & Group Discounts

October

Tuesday 19th & Friday 22nd

9.30 am to 12.45 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Video Recordings of Course

Training Certificate Upon Completion

(prices discounted for larger groups)

November

Monday 22nd & Tuesday 23rd

9.30 am to 12.45 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Video Recordings of Course

Training Certificate Upon Completion

(prices discounted for larger groups)

December

Monday 20th  &  Tuesday 21st

9.30 am to 12.45 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Video Recordings of Course

Training Certificate Upon Completion

(prices discounted for larger groups)

 

Why Progressive Training

Z

Live On Demand Virtual Training

Z

Experienced Professional Trainers

Z

Customised Training Solutions for business

Z

Free 12 Months Support

Z

Major Discounts for Group Bookings

The training exceeded our expectations. The way that John interacted and engaged with our colleagues meant that they received a lot from the course. Thank you for ensuring the training was delivered so professionally.

Anne Kelly – Irish Windows

From the First point of contact we found Progressive Training to be very helpful in assessing our training needs and delivering a range of Excel training courses to meet our staff needs.

Paul Wilson – HR manager, Gourmet Ireland

 

Make an Enquiry

6 + 2 =