The latest version of Microsoft Office is 2019/O365 but the earlier formats - 2016, 2013 are 2010 - are still very much to be found in offices and homes throughout the UK and abroad.  Microsoft, however, has now ceased to provide support for Office 2007, 2003 and Windows XP.  The table below displays the icons that represent the different applications available in Microsoft Office.  Click on an icon to see more details, such as course outlines and main features.


For the everyday user, each version provides all of the basics for that particular Office application but you will see the new releases add a little more functionality to its predecessor.  All course outlines can be download as a PDF file; simply click on the appropriate logo to open up a new window, read about the course and download the outlines.

Word with text.jpg
Excel with text.jpg
PowerPoint with text.jpg
Outlook with text.jpg
SharePoint with text.jpg
Visio with text.jpg
Publisher with text.jpg
OneNote with text.jpg
Access with text.jpg
Project with text.jpg

Microsoft Excel Level 1

Microsoft Excel training throughout the UK, including Manchester, Leeds, Birmingham, York, Carlisle, Newcastle, Sheffield, Glasgow, Edinburgh, Aberdeen, Derby, Norwich, Portsmouth, Swansea, Cardiff, Chester.  For overseas training and contracts, please call to discuss your requirements.

Microsoft Excel Level 1 – Course Outline


About This Course

This course is designed for delegates new to working with Microsoft Excel will learn to create spreadsheets and workbooks that can be used to store, manipulate and share data.


Target Audience

Delegates who have little or no familiarity with Microsoft Excel


At Course Completion

After completing this course, students will be able to:


  • Get started with Excel

  • Create a basic worksheet

  • Modify a workbook

  • Use formulae and functions

  • Format an Excel worksheet

  • Manage worksheets and workbooks

  • Set up printing options


Course Content


Unit 1 - Getting Started with Excel

  • Excel and the Excel Environment

  • Navigate and Select in Worksheets

  • Create a Basic Workbook

  • Open, Save and Close Workbooks

  • Use Microsoft Help

  • Use ‘Tell me what you want to do…’

  • Selecting Cell Ranges


Unit 2 - Modifying a Workbook

  • Cut, Copy and Paste Commands

  • Flash Fill

  • AutoFill Options

  • Find and Replace

  • Spelling

  • Undo and Redo

  • Insert and Delete Options

  • Column Width and Row Height

  • Hide and Unhide Options


Unit 3 - Using Formulae and Functions

  • Understanding BODMAS

  • Create Relative Formulae

  • AutoCalculate

  • Insert Functions

  • Use AutoSum

  • Copy Formulae

  • Create Absolute Formulae


Unit 4 - Formatting an Excel Worksheet

  • Font Group

  • Add Borders and Fill Colours

  • Cell Alignment

  • Number Formatting

  • Cell Styles and Galleries


Unit 5 - Managing Worksheets and Workbooks

  • Manage Worksheets

  • View Worksheets and Workbooks


Unit 6 - Printing Options

  • Print Pane

  • Print Worksheets and Workbooks

  • Page Setup

  • Print Layout View



Course duration: one day


Word with text.jpg
Visio with text.jpg
Excel with text.jpg
Publisher with text.jpg
PowerPoint with text.jpg
OneNote with text.jpg
Outlook with text.jpg
Access with text.jpg
Project with text.jpg