We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?


Archway Computer Training

Introductory Excel 2016 training – Provisional Course Outline

All outlines can be tailored to meet the needs of the individuals or organisation


Aims of the course


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


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 abasic 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


Formulas 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 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 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 or modifying charts or graphs
  • Changing chart type
  • Moving and deleting charts or graphs



Be the first to write a review about this course.
Write a Review
Archway Computer Training offers tailored training at your offices in Wiltshire, Dorset, Somerset and Hampshire.
Archway Computer Training
Downside, The Down, Hindon, United Kingdom SP3 6EF
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.