Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

Take control of your spreadsheets and confidently embrace the power of Microsoft Excel.

Designed for beginners and self-taught users, this Excel training course will empower you to use Excel confidently and effectively in your everyday role - whether that's inputting data, using calculations, creating reports or managing simple lists.

You'll discover the essential tools that help you work faster, stay organised, and avoid common time-wasting errors - all while building your Excel confidence.

Learning Objectives

Getting Started with Microsoft Excel
- Introduction to the Excel interface: ribbon, formula bar and layout
- Tips for selection and movement across cells
- Creating, saving and opening workbooks

Entering and Formatting Data
- Typing and formatting text, numbers and dates
- Selecting cells, rows and columns efficiently

Formulas and Functions
- Using basic arithmetic: +, –,×, ÷
- Understanding BODMAS and how Excel calculates
- Creating functions: SUM, AVERAGE, MIN, MAX, COUNT
- Using the Function Wizard for guided formulas

Working with Dates
- Performing date calculations
- Formatting dates for consistency

Copying, Moving and Filling Data
- Cut, copy and paste
- Using AutoFill to repeat patterns
- Drag and drop techniques 
- Relative and Absolute Referencing
- Understanding cell references
- Locking cells with $ in formulas

Editing Worksheets
- Inserting, deleting and resizing rows and columns
- Hiding and unhiding worksheet elements

Formatting for Clarity and Impact
- Adjusting fonts, colours, borders and fill
- Aligning cell content
- Applying number formats and using the Format Painter
- Merging and unmerging cells

Working with Larger Worksheets
- Freezing panes and using split view
- Applying AutoFilter for data filtering

Printing and Layout Options
- Print preview and setting the print range
- Sizing sheets to fit on a page
- Adjusting margins, headers and footers

Managing Multiple Sheets
- Creating, renaming, colouring and deleting sheets
- Navigating between sheets easily

Charts and Graphs
- Creating charts based on your data
- Choosing chart types
- Applying basic formatting to charts

Reflections & Planning
- Recap key skills and tools covered during the session
- Discuss how to apply the learning in your specific role
- Identify personal next steps or areas to build on after the course

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

This course is ideal for:
- Beginners or self-taught users of Microsoft Excel
- Professionals looking to build confidence in everyday spreadsheet tasks
- Teams who want consistent foundational Excel skills across staff

Prerequisites: Basic computer skills such as using a keyboard and mouse, and saving or opening files.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill