0345 4506120

Microsoft Excel 2016 / 365 Introduction

Course Details

Name Microsoft Excel 2016 / 365 Introduction
Start Date:
Working Days:
£238.00 +vat
was £299.00
Course ID:


Special Notices

Please note: for Attend from Anywhere customers an additional screen is required for this course to work through remote desktop labs and view training information.

You will create and edit basic Microsoft Excel 2016 / 365 worksheets and workbooks.
Target Audience
This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 / 365 worksheets.
This course is suitable for users of Microsoft Excel 2016 or 365 subscription editions.

Learning Objectives

  • Get started with Excel 2016 / 365
  • Create a basic worksheet
  • Modify a workbook
  • Use formulas and functions
  • Format an Excel worksheet
  • Manage worksheets and workbooks
  • Set up printing options


  • Use a mouse

  • Type and use a keyboard

  • Navigate through Windows files and folders

  • Work with windows - minimise, maximise, open and close

Course Content

Module 1: Getting Started with Excel 2016

• Excel and the Excel Environment

• Navigate and Select in Worksheets

• Create a Basic Workbook

• Open, Save and Close Workbooks

• Use Microsoft Help

Module 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

Module 3: Using Formulas and Functions

• Create Relative Formulas

• AutoCalculate

• Insert Functions

• Use AutoSum

• Copy Formulas

• Create Absolute Formulas

Module 4: Formatting an Excel Worksheet

• Font Group

• Add Borders and Fill Colours

• Cell Alignment

• Number Formatting

• Cell Styles and Galleries

Module 5: Managing Worksheets and Workbooks

• Manage Worksheets

• Freeze Rows and Columns

• View Options for Worksheets and Workbooks

Module 6: Printing Options

• Print Preview

• Print Worksheets and Workbooks

• Page Setup

• Print Titles

• Page Layout View

Manchester - Oxford St


Image result for St James Buildings, Oxford Road, Manchester, M1 6FQ

St James' is widely regarded as one of the finest period properties in the city, with its handsome Portland stone frontage on Oxford Street and an abundance of classical period features including original marble foors, plastered ceilings and detailed staircases; all without sacrificing the facilities you would expect from a modern office.

Oxford Street itself offers an array of lunchtime and evening eateries, as well as bars, newsagents, and a selection of supermarkets and coffee shops. The selection of quality retailers on the ground floor of St James' itself includes a florist, coffee shops, restaurants and hairdressers.


8th Floor
St James Buildings
61-95 Oxford Street
M1 6FQ



Train station

Manchester Oxford Road - 200m

Manchester Piccadilly - 900m

Our Customers Include