Select Page

Advanced Microsoft Excel

Non-member price

£200.00 +VAT

Please login to purchase

Sold Out

Location: Cisco Webex, Online, Virtual Training, .

Start: 26th Nov 2020 9:00am to 4:00pm

SKU: e7867e2bfdc9 Categories: , ,


This is the big one but you don’t have to be an Excel genius to attend just a very good working knowledge of formulas, charts and sorts and filters.

We aim to make even the most clever functions of a complicated nature relatively easy to understand and put to use. Many people would like to get to grips with pivot tables and macros and we show you how it’s not rocket science but simply a great tool perhaps never explained in layman’s terms before. A course for you if you believe you are at Intermediate levels already.

Who should attend?
Users with a good understanding of Microsoft Excel 2010 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you would like to fill in any gaps in your knowledge.

Working knowledge of Microsoft Windows processes and minimum knowledge of computer usage is essential. A very good working knowledge of Excel or attendance on the Intermediate course.

Course Objectives
By the end of this course delegates will know:

• How to create complex charts and format them
• How to generate text and statistical functions to resolve problems
• What is advanced filtering are all about and how to determine unique records in a list
• How to use the Vlookups complex formula to resolve various business problems
• How to create a Pivot Table and Chart to simplify complex data sets
• The macro development is not complicated!

Your Feedback
Your Feedback
Questions? We're here to help you!
Thanks for using our brand new website. We would love to hear your thoughts and suggestions.
Our operators are busy. Please try again later
Have you got a question? Write to us!
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad