Excel Intermediate
Duration: 6 Hrs (2 @ 3 hr sessions)
This course explains how to use Microsoft Excel
for intermediate spreadsheet tasks and operations.
Level – Excel Intermediate
This course is intended for those who have experience of Excel or have completed an Introduction course.
Live Virtual Training Dates
Why not attend one of our scheduled Live Virtual Training Dates
Excel Intermediate Course Details
Course Objectives
∎ This course explains how to use Microsoft Excel for intermediate 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, manage data with sort and filter and analyse spreadsheets with tools such as Pivot Tables,
Course Content
∎ Excel Productivity Tips
∎ Conditional Formatting
∎ Linking Excel Data
∎ Paste Specials
∎ Freezing/Hiding Rows/Columns
∎ Absolute Cell Referencing
∎ Working with Formulas (SumIF, CountIF, CountA)
∎ Working with Date Functions
∎ Sorting Data
∎ Filters & Advanced Filters
∎ Creating sub-totals
∎ IF and nested IF Functions
∎ V Lookup
∎ Intro to Tables
∎ Intro to Pivot Tables
Classroom Training - Scheduled Dates and Booking
∎ We are currently rescheduling Classroom based Excel training courses based on demand.
∎ 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.
∎ 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
April
Tuesday 11th – Wednesday 12th
9.15 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)
May
Wednesday 10th – Thursday 11th
9.15 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)
June
Wednesday 14th – Thursday 15th
9.15 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
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