We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

Introductory Excel 2016 training – Provisional Course Outline

Introductory Excel 2016 training

Our Introductory Excel 2016 training course outlines can be tailored to meet the needs of the individuals or organisation. We train at your site in Dorset, Somerset, Wiltshire or Hampshire.

Aims of the course

This Introductory Excel 2016 training course aims to introduce delegates with little or no understanding of the Microsoft Excel software to the basic features of the package.

Number on coursePrice per day
1 - 1 training£315 + VAT
2 - 4 people£495 + VAT
5 - 8 people£645 + VAT

Course Objectives

On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. They should also be able to accomplish standard mathematical and logical operations using basic formulae and functions. They should also be able to use some of the more advanced Microsoft Excel applications such as creating graphs and charts.

The course is of one day’s duration.

How the course is run – This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites – Delegates attending the course should preferably have a basic understanding of the Windows environment and use of the keyboard and mouse.

Course Outline

Getting Started

  • Opening Excel
  • Understanding the Ribbon structure
  • Opening a workbook
  • Creating a new workbook
  • Closing a workbook
  • Using Help functions
  • Changing spreadsheet view mode
  • Using the zoom tool
  • Modifying the Quick Access Toolbar
  • Saving workbooks – as Excel workbooks and as pdfs

Basic Operations

  • Inserting Data – numbers, text, symbols, special characters, simple formulae, using undo
  • Selecting Data – cells, range of adjacent or non-adjacent cells, rows, columns
  • Copying, Moving, Deleting
  • Finding and Replacing
  • Inserting rows and columns
  • Modifying row height and cell width
  • Deleting rows and columns
  • Sorting Data

Formulae and Functions

  • Arithmetic Formulas – addition, subtraction, multiplication, division, standard error messages, autofill tool, relative cell referencing, absolute cell referencing
  • Working with Functions – sum, average

Formatting

  • Formatting Cells – number of decimal places, number of zeros after the decimal point, date styles, currency, percentages
  • Formatting Cells – text size, bold, italic, font type, font colour, text orientation
  • Formatting Cell Ranges – centring and aligning cell contents, adding border effects
  • Spelling
  • Document Setup – modifying document margin settings, adjusting document setup to fit one page, adding a header and footer, changing document orientation, page size, etc

Printing

  • Printing Simple Spreadsheet Documents – using basic print options, previewing a spreadsheet, printing a spreadsheet or a worksheet, printing part of a worksheet or a pre-defined cell range

Charts and Graphs

  • Producing different types of graphs and charts to analyse data
  • Editing charts or graphs
  • Changing chart type
  • Moving and deleting charts or graphs

To request further details of any of our courses, or to make a booking, please contact us by ringing 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.
We provide:

Excel training Dorset locations include:

Bournemouth Poole Sherborne Shaftesbury
Gillingham Christchurch Ferndown Wimborne
Blandford Forum Dorchester Weymouth Verwood
Merley Wareham Bridport Lulworth
St Leonards

Excel training Wiltshire locations include:

Salisbury Swindon Trowbridge Chippenham
Devizes Marlborough Warminster Tisbury
Melksham Westbury Corsham Amesbury
Tidworth Bradford-on-Avon Bulford Camp Porton
Calne Highworth Wootton Bassett Wroughton
Malmesbury

Excel training Hampshire locations include:

Southampton Winchester Portsmouth Basingstoke
Andover Petersfield Ringwood Havant
Gosport Farnborough Aldershot Romsey
Eastleigh Fleet Alton Fareham
Totton Hedge End Stubbington
Hythe New Milton Emsworth Romsey
Bordon Tadley South Hayling Lymington
Yateley Blackfield Hook Blackwater
Bursledon North Baddesley Liphook Netley
Bishop’s Waltham Liss Marchwood Denmead
New Alresford Oakley

Excel training Somerset locations include:

Bath Yeovil Wincanton Frome
Taunton Weston-Super-Mare Midsomer Norton Shepton Mallet
Radstock Paulton Bridgwater Burnham-on-Sea
Chard Cheddar Clevedon Crewkerne
Glastonbury Portishead Nailsea Keynsham
Street Minehead Wellington Wells
Yatton Ilminster Long Ashton

We have also trained home-based businesses and users in some of the Dorset, Wiltshire and Hampshire villages, so please do get in touch.

Organisations which have benefitted from our Introductory Excel 2016 training include: