Are you currently in Year 11? Apply today to start your course this September!
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!
Pages in this Section
MANAGING DATA AND INFORMATION USING PIVOT TABLES AND EXCEL
- MOA
- Part Time
- Level
- Level 1
- Type
- Adult PT, Adult SC
- Duration
- 1 Day
- Location
- Lancaster & 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 advice@lmc.ac.uk
Course code: B35678
