Are you currently in Year 11? Apply today to start your course this September!

Courses at LMC

Courses at LMC

Full Time, Part Time, Apprenticeship or Higher Education

Browse our course list to find the course that's right for you - your future starts here!


egg-timerPart Time
arrowLevel 1
hatAdult PT, Adult SC
calendar1 Day
pinLancaster & Morecambe College
Start date: 15/03/2023, 9 am to 4 pm (Wed)

The aim of this session is to equip you with the knowledge of using Pivot Tables from Excel to summarise data in a quick and easy manner.

The ability to solve problems, make timely business decisions and respond to customers’ needs is all dependent on the ability to manipulate good quality data and information.

You need only to have a basic knowledge of Excel to be able to gain benefit from this course.

Course Overview

The course will look at:

  • Manipulating data from information already available

  • Using the Headings to change the information

  • Sorting and Filtering

  • Multiple tables on one page

  • Using Count, Sum and Average on Calculations.

  • Graphs and Charts from Pivot Tables

  • Presentation of Pivot Table information

Entry Requirements

You need only to have a basic knowledge of Excel to be able to gain benefit from this course.

Course Fees

This course costs £100.00, including exam fees.

You may be eligible for free study if you are 23 or under and this is your first full Level 2 or 3 course. Alternatively, if you are unemployed, receiving an eligible benefit, and taking the course to help you find employment.

You may also be entitled to additional financial support including course materials, uniforms, and childcare expenses depending upon your individual circumstances. Read more about Financial Support for adults.

How to Apply

For more information, advice and guidance please phone Employer Engagement on 01524 521483 or 0800 306306 or email

Course code: B35678