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
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.
∎ 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
∎ 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 Training - Scheduled Dates and Booking
∎ We are currently delivering Classroom based Excel training courses in regional training locations.
∎ we also offer the Excel courses on a Live Virtual Training basis.
∎ 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 Training Bookings
Dates, Fees & Group Discounts
March
Tuesday 27th – 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)
April
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)
May
Thursday 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)
Classroom Based Training Bookings
Dates, Fees & Group Discounts
March
Thursday 20th – Full Day (6 Hrs)
9.15 am to 5 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)
April
Thursday 3rd & 24th – Full Day (6 Hrs)
9.15 am to 5 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)
May
Wednesday 28th – Full Day (6 Hrs)
9.15 am to 5 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 Progressive Training
Live On Demand Virtual Training
Experienced Professional Trainers
Customised Training Solutions for business
Free 12 Months Support
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