Courses at LMC

Excel Advanced

MOA
egg-timerPart Time
Level
arrowLevel X
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinLancaster & Morecambe College
Start date: 20/05/2025, 9 30am to 4 pm (Tue)
MOA
egg-timerPart Time
Level
arrowLevel X
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinLancaster & Morecambe College
Start date: 22/07/2025, 9 30am to 4 pm (Tue)

This workshop is aimed at members of the workplace with a clear working knowledge of Microsoft Excel who are involved in using spreadsheets each day and would like to introduce advanced techniques to automate everyday tasks. Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.

This Advanced Excel workshop will introduce you to some of Microsoft Excel’s more powerful features and functions.

Refreshments and a light business lunch is included.

Course Overview

In this workshop we will start to build on the Microsoft Excel skills you already use each day with the introduction of advanced spreadsheet techniques.

Topics covered will include:

  • Editing data

  • Displaying data

  • Sharing, comparing and merging worksheets

  • Password and security

  • Sorting

  • Filtering

  • Validating with Microsoft Excel

  • Linking and embedding

  • Hyperlinks

  • Using advanced functions

  • Using macros

  • Pivot tables

  • Scenarios

  • Auditing

Progression Routes

LMC offers a wide range of courses, perfect for up skilling the workforce on day courses or more in-depth professional training packages. You may be interested in:

  • Lean Organisation Management Techniques – Level 2

  • Principles of Business Administration – Level 2

  • Principles of Customer Service – Level 2

  • Principles of Team Leading - Level 2

Entry Requirements

There are no formal entry requirements nor any formal assessments for this course and delegates will receive a College certificate upon completion.

Course Fees

This course costs £11.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

If you would like to apply for this course, please click 'Apply' in the top right, follow the steps, and our Admissions Team will be in touch with you.

For more information, advice and guidance please phone Employer Engagement on 01524 521223 or 0800 306306 or email employerengagement@lmc.ac.uk

Course code: B64072