Excel Intermediate

MOA
egg-timerPart Time
Level
arrowLevel 2
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinOff-Site
Start date: 07/02/2022
MOA
egg-timerPart Time
Level
arrowLevel 2
Type
hatAdult PT, Adult SC
Duration
calendar1 Day
Location
pinLancaster & Morecambe College
Start date: 24/02/2022

This one-day training course aims to give basic users of Microsoft Excel knowledge of commands and functions which will make them more proficient in spreadsheet and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

This workshop is aimed at members of the workplace with a basic working knowledge of Microsoft Excel who are involved in using spreadsheets each day and would like to build on their current skills. Refreshments and a light business lunch is included.

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 Activities

In this workshop we will start to build on the Microsoft Excel skills you already use each day with an emphasis on automating your use of a spreadsheet.

Topics covered will include:

  • Creating a spreadsheet

  • Opening and importing

  • Formulas

  • Editing cells

  • Printing

  • Formatting cells

  • Formatting worksheets

  • Creating charts

  • Formatting charts

  • Cell referencing

  • Functions

  • Names

  • Linking

  • Filtering and sorting

Progression Opportunities

Learners who have completed the Intermediate level course may wish to progress to the Excel Advanced course.

Interested?

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

Course code: B34636-S01

ALUMNI