Excel Advanced

Duration: 1 Day – 6 Hrs ( 2 @ 3 hr sessions )

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

Level – Excel Advanced

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

Live Excel - Training Dates

Check out below our scheduled Live Virtual Excel Training Dates

Microsoft Excel Advanced

Why not attend one of our scheduled Classroom Based Courses

 

Excel Advanced Course Details

Course Objectives

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

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

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

Course Content

∎ Advanced Conditional Formatting

∎ Creating and Managing Tables

∎ Date Formula – Today, Days, Networkdays

∎ Text Formula – Trim, Proper

∎ Lookup Formula – VLOOKUP, XLookup

∎ Array Formula – Sort, Filter, Unique

∎ Advanced List management incl Subtotals

∎ Pivot Tables and Power Pivot (Data Model)

∎ Intro to Power Query – Get and Transform

Classroom and Live Online Training Options - Scheduled Dates and Booking

∎ Currently delivering Classroom based Excel training courses in regional training locations.

∎ We also offer the Excel courses on a Live Virtual Training basis and Onsite Training for your Business.

∎ Please see below for scheduled dates and information.

∎ If you can complete a course enquiry form to let us know you are interested, we will get back to you with the training options.

Live Virtual Excel Training Bookings

Dates, Fees & Group Discounts

September

Tuesday 22nd – Full Day (6 Hrs)

9.15 am to 4.30 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)

October

Wednesday 21st – Full Day (6 Hrs)

9.15 am to 4.30 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

Tuesday 24th – Full Day (6 Hrs)

9.15 am to 4.30 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)

Classroom Based Excel Training Bookings

Dates, Fees & Group Discounts

September

Tuesday 22nd – Full Day (6 Hrs)

9.15 am to 4.30 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Training Certificate Upon Completion

(prices below discounted for group booking)

October

Wednesday 21st – Full Day (6 Hrs)

9.15 am to 4.30 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Training Certificate Upon Completion

(prices below discounted for group booking)

November

Tuesday 24th – Full Day (6 Hrs)

9.15 am to 4.30 pm

Full training pack included for each attendee

Training Pack includes:

Excel Course Manual

Course Practice Files

Training Certificate Upon Completion

(prices below discounted for group booking)

 

Why Excel with 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

4 + 1 =