Abbi Hannah
Business & CIPD
Abbi studied Level 3 Extended Diploma in Business and Level 3 CIPD with us and is now a Degree Apprentice on the Project Management Scheme at BAE Systems.
Read More
Joe Donovan
Business
Joe studied a Level 3 Business qualification, which is equivalent to 3 A-Levels. He chose Kendal College mainly because of its reputation and links with employers and universities.
Read More
Harrison Brooks
Business and CIPD
Harrison studied Business and CIPD with us and was also a Student Ambassador and Student Governor. He is now a Management Consultant living in London.
Read MoreCourse Overview
You will spend a very practical day with a qualified Microsoft Expert Master watching demonstrations and then completing tasks to learn the various tools and techniques.
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
- Using VLOOKUP
- Using HLOOKUP
- Creating Macros
- Scenarios/Goal seek
- Goal Seek Add-in
- Power Query
- Power Pivot Add-in
Entry Requirements
It is essential to have a good sound working knowledge of Excel before embarking on this course and we would not recommend moving onto it if you have only recently done the Introduction to Excel course.
Progressing from Intermediate to Advanced shouldn't be a problem. Learners having completed the Introduction to Excel followed by the Intermediate need time to assimilate and put in to practice what they have learnt.
After Your Course
You could progress on to IT Users Certificate, Accountancy or Bookkeeping courses.
Fees
£75.00
The current fee information is related to the 2025/26 academic year.
