Microsoft Excel Essentials Training in United Kingdom

  • Learn via: Classroom
  • Duration: 1 Day
  • Level: Fundamentals
  • Price: From €551+VAT

In this course you’ll create and edit basic Microsoft Office Excel worksheets and workbooks. This course emphasises hands-on experience, with a series of self-guided exercises integrated into the training manual.

We can host this training at your preferred location.

Prerequisites

  • Use of mouse and keyboard
  • Ability to navigate the Windows environments
  • Open and close programs

What You Will Learn

At the end of this course, you’ll be able to:

  • Get started with Excel
  • Create calculations with formulas and functions
  • Modify a worksheet
  • Format an Excel worksheet
  • Work with Data Lists
  • Manage worksheets and workbooks

Outline

Module 1: Getting started with Excel

  • What is Microsoft Excel?
  • Excel and the Excel environment
  • Navigating and selecting cells in worksheets
  • Creating a new workbook
  • Saving your work
  • Opening and closing workbooks
  • Using Help

Module 2: Modifying a worksheet

  • Cut, Copy and Paste commands
  • Undo and Redo commands
  • Using AutoFill
  • Working with rows and columns
  • Find and Replace
  • Performing a spell check

Module 3: Creating calculations with formulas and functions

  • Creating formulas
  • AutoCalculate
  • Inserting functions and using AutoSum
  • Using functions to round values
  • Copying a formula
  • Creating an Absolute formula
  • Dynamic array formulas

Module 4: Formatting an Excel worksheet

  • Text formatting
  • Add borders and colours to cells
  • Cell alignment
  • Number formatting
  • Format Painter
  • Cell styles and galleries

Module 5: Working with data lists

  • Creating an effective list
  • Applying basic sorting
  • Applying basic filters

Module 6: Managing worksheets and workbooks

  • Managing Worksheets
  • Freezing rows and columns
  • Splitting the screen
  • Arrange All command
  • View Side by Side

Training Reviews


Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our United Kingdom facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

06 June 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
13 June 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
20 June 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
14 July 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
17 July 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
26 August 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
24 September 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT
12 November 2025 (1 Day)
London, Manchester, Birmingham
Classroom / Virtual Classroom
€551 +VAT

Related Trainings

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.