Microsoft Excel
Pitman Training
- 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.