What are you looking for

Microsoft Excel

Pitman Training

Go to the course page (opens in new tab)

Where
No venue, study anywhere
Starts
Flexible start
Duration
24 Hours
Cost
See cost details
How it's taught
Online

About this course

Lesson One: Identifying the elements of the opening screen, entering addition formulas, adjusting column widths, using the SUM function, using the AutoSum feature. Lesson Two: Applying bold, italic and underline formats, changing font, selecting and formatting cells ranges , applying number formats, using AutoFill, entering formulas. Lesson Three: Inserting and deleting rows and columns, hiding and unhiding rows and columns, wrapping and indenting text, applying a fill colour, applying borders. Lesson Four: Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom. Lesson Five: Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, page orientation, adjusting margins and scaling, print preview and print a worksheet, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions. Lesson Six: Inserting and formatting headers and footers, inserting header and footer codes including date, page number and file name, copying and pasting data between worksheets, grouping and formatting multiple worksheets. Lesson Seven: Creating more complex formulas, making a cell reference absolute, displaying all formulas, customising and viewing calculations, using the NOW, TODAY and IF functions. Lesson Eight: Displaying a hidden worksheet, using the PMT and FV functions, recognising errors, using the IFERROR function. Lesson Nine: Column, line and pie charts, chart elements, adding and removing a data table, switching chart rows/columns, changing chart layout options, selecting and formatting chart elements , inserting sparklines, inserting moving, resizing and rotating pictures. Lesson Ten: Using Spell check, using Filter, finding and replacing text and formats, saving a workbook as a web page, hyperlinks. You can choose a software version.

What level 2 means

Level 2 is the same level as these qualifications:

  • CSE - grade 1
  • GCSE - grades 9, 8, 7, 6, 5, 4 or grades A*, A, B, C
  • intermediate apprenticeship
  • level 2 award
  • level 2 certificate
  • level 2 diploma
  • level 2 ESOL
  • level 2 essential skills
  • level 2 functional skills
  • level 2 national certificate
  • level 2 national diploma
  • level 2 NVQ
  • music grades 4 and 5
  • O level - grade A, B or C

Source: GOV.UK, What qualification levels mean (opens in new tab). Contains public sector information licensed under the Open Government Licence v3.0.

What you need before you start

None

Fees and funding

Please contact your local Pitman Training centre

The qualification you get

Qualification
Spreadsheet Software
Awarded by
Multiple Awarding Bodies
Subject area
Digital technology (practitioners)

Where you study

No venue, study anywhere. This course has no fixed venue.

Course data from the National Careers Service course directory and the Learning Aim Reference Service. Apprenticeship vacancies from the GOV.UK Apprenticeships API. Contains public sector information licensed under the Open Government Licence v3.0. Postcodes are resolved from the ONS Postcode Directory. Contains OS data © Crown copyright and database right 2026. Contains Royal Mail data © Royal Mail copyright and database right 2026. Source: Office for National Statistics licensed under the Open Government Licence v3.0.

Your favourites