Your browser is unsupported and may have security vulnerabilities! Upgrade to a newer browser to experience this site in all it's glory.
Skip to main content

Staff, student, and parent links are now under My Kendal in the main menu!

Course Mode
Part-time
Level
N/A
Start Date
23/05/2025
Start / End Time
9:30am - 4:30pm
Duration
1 Day
Location
Westmorland Campus

Professional Business Services

The professional business services department provides courses for those wishing to retrain or develop their career in the professions of accounting, HR, law, management and IT.

View course department

Course 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 fee displayed is the course fee. Course fees are per year for full-time & degree-level courses and per course for part-time courses.

There may be other costs associated with this course, e.g. kit, equipment, books, trips etc. Financial support may be available to support you with these. See the Student Money pages for more information.

Courses fees

The current full-time & degree-level fee information is related to the 2024/25 academic year.

Entry Level, Level 1 & Level 2 Courses

You may qualify for financial support to cover the cost of a government-funded qualification if any of the below apply to you:

  • Receive an eligible means-tested benefit, e.g. JSA, ESA or Universal Credit
  • Have an annual salary of less than £25,000
  • Are aged 16-18 on 31/08/24 and are not studying at another school/college
  • Do not already have a level 1, 2 or 3 qualification
  • Have a household income under £35,000 and are in financial hardship

See the Student Money pages for more information.

Join us at our next

Open Evening

28 November 2024 16:30 – 19:30