Hello, and welcome to our website!

Just a heads-up, we're close to rolling out a shiny new website and we've had to make some changes which may affect the way our current course information is displayed. If you have any questions, please get in touch.


Advanced Microsoft Excel 2016

Call Student Services on 01539 814700 for information.
09:30 - 16:30

This course is aimed at the more experienced Excel user who wishes to consolidate their knowledge and learn some new features.

If your job involves working with Excel manipulating and analysing data in Excel, you will find this course very useful. This course is aimed to help you fill in gaps in your knowledge.

During the day we will look at many advanced functions such as Lookups, COUNTIFS, SUMIFS, What IF functions and Scenario building. You will also be shown short cuts and tips on creating spreadsheets quickly including the use of macros. We will build on skills to import data into Excel, prepare it and set up pivot tables to analyse it.
Topics covered include:
- Data Validation and Data Validation Lists
- Countif/ Countifs, Sumif & Sumifs
- Array Formula
- Importing External Data & Working with Data Lists
- Working with Pivot Tables & Pivot Chart Reports
- Creating Macros
- Scenarios

- Protecting Cella and Work Books

The course is workshop based and can be adapted to your personal requirements.

There is no assessment with this course, however, you will receive a certificate of attendance.

How will I be assessed?


Next: Career Opportunities?

Career Opportunities

This is a useful course for all working in the administration and IT industries.

Next: Entry requirements

Entry requirements

You should have some prior experience of Excel. This is not a course for the IT beginner nor is it suitable for learners who have only recently completed the Introduction to Excel course. Some consolidation of learning needs to take place before attending this course.

Next: Fees

Adult fees


Please note: If you are an adult student you may be entitled to financial support to cover the cost of your course, dependent on your circumstances. Please contact Student Services on enquiries@kendal.ac.uk for details. More about Student Finance.

Next: Enquire

Enquire about Advanced Microsoft Excel 2016

Ready to apply for this course? Complete an Enrolment Form today

About You



Want to know more? Check out our FAQ, otherwise contact us