Courses at LMC

Excel Advanced - Multiply

MOA
egg-timerPart Time
Level
arrowLevel X
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinLancaster & Morecambe College
Start date: 25/11/2024

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.

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: B6867