Microsoft Excel - Advanced
Presentation Style: | Tutor-led Training Course: Face-to-Face or Online |
Duration: | 1 Day |
Course Time: | 09:30 - 16:30hrs |
Course Location: | Face-to-Face in Althorp, Northampton or Online from any location |
Cost: | Public Courses: £225 + VAT per delegate, £200 each + VAT for two delegates on the same day (call for group discounts) Closed Courses: please enquire |
Click a date to book: |
What will you learn on this Microsoft Excel Advanced Training Course?
By the end of this Excel course delegates will have gained skills; giving them a solid understanding of advanced tools and concepts in order to increase their knowledge and productivity
Excel Advanced Course Content
Module One – Paste Special Options
Using Paste Special to Add, Subtract, Multiply & Divide, Using Paste Special ‘Values’, Transpose.
Module Two – Functions and Formulas
Nested Functions, Consolidating Data Using a 3-D Reference Sum Function, Mixed References within Formulas.
Module Three – Mathematical and Statistical Functions
Round, Rounddown, Roundup, Sumif, Counta, Countif, Rank.
Module Four – Database Functions
Dsum, Dmin, Dmax, Dcount, Daverage.
Module Five – Pivot Tables
Creating and Using a Pivot Table, Filtering and Sorting Data, Automatically Grouping Data, Manually Grouping Data.
Module Six – Validating
Whole Number, Decimal Number, List, Date, Time, Text Length, Input Messages, Error Alerts, Removing Data Validation.
Who should take this Advanced Excel course?
This Excel course is designed for delegates with Knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Intermediate course and who wish to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, create pivot tables and pivot charts and incorporate multiple data sources.
Additional Information
- Buffet lunch included and free parking (only for courses held at Paradise Training Centre, Northampton)
- Joining instructions will be sent prior to attending the course
Course Dates
Excel Introduction (Face-to-Face) | 01/07/2022 |
Excel Introduction (Online) | 13/07/2022 |
Excel Intermediate (Online) | 14/07/2022 |
Excel Intermediate (Online) | 15/07/2022 |
Excel Intermediate (Face-to-Face) | 19/07/2022 |
Excel Advanced (Face-to-Face) | 26/07/2022 |
Excel Advanced (Online) | 28/07/2022 |
Excel Introduction (Face-to-Face) | 01/08/2022 |
Excel Intermediate (Face-to-Face) | 16/08/2022 |
Excel Advanced (Face-to-Face) | 18/08/2022 |
Free PDF Download
Sign-up to our mailing list and get a free Sneak Peek of our 'Excel Introduction' Training Course Manual: