Courses at LMC

Excel Advanced

MOA
egg-timerPart Time
Level
arrowLevel 2
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinLancaster & Morecambe College
Start date: 08/01/2026

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

This workshop is aimed at memebrs of the workplace with a clear working knowledge of Microsoft Excel who are involved is using spreadsheets each day and would like to introduce advanced techniques to automate everyday tasks.

Topics covered will include:

  • Editing and displaying data

  • Sharing, comparing and merging worksheets

  • Password and security

  • Sorting and filtering

  • Linking and embedding

  • Hyperlinks

  • Using advanced functions

  • Using macros

  • Pivot tables

    and more

Entry Requirements

There are no formal entry requirements although a good working knowledge of Excel is essential. There is no formal assessments during this course and delegates will receive a College certificate upon completion.

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: B34637-S01