Excel 2016 Foundation

1-Day Instructor-led classroom based training.

Excel 2016 Foundation can be delivered as a scheduled open course, a company private closed course or as a one to one consultancy. We can run this course either at our training centre in Aberdeen, your premises or using our portable training school. Download full course profile below.

Excel 2016 Foundation – COURSE OVERVIEW

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Excel 2016 Foundation – LEARNING OUTCOMES

At the completion of this course you should be able to:

  •  navigate your way around Microsoft Excel 2016
  •  create and work with a new workbook
  • open and navigate within workbooks and worksheets
  •  make changes to data in a workbook
  •  understand and work with ranges in a worksheet
  •  copy and paste data in Excel
  •  use the fill operations available to fill a data series
  •  move the contents of cells and ranges within and between workbooks
  •  understand, create and work with formulas and functions
  •  understand and use formula cell referencing
  •  use font formatting techniques
  •  align the contents of cells in a number of ways
  •  understand and use the number formatting features in Excel
  •  format rows and columns in a worksheet
  •  work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  •  filter data in a table
  •  print your workbook data
  •  create effective charts in Microsoft Excel
  •  obtain help for Excel whenever you need it
  •  understand points to consider to avoid problems in your worksheets

Excel 2016 Foundation – COURSE PRE-REQUISITES

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Excel 2016 Foundation – COURSE PRICING

Open Course: £210 per delegate per day (excl. VAT).

For alternative options and pricing please visit: http://www.solab.co.uk/training/pricing/

Aberdeen Excel Courses – How to find us?

Our office is situated on the first floor of Bridge House, at 56-58 Bridge Street in Aberdeen.  Parking is available at the multi-storey pay and display car park next to the nearby British Telecom building.  From the car park, walk up College Street onto Bridge Street; Bridge House is located at the bottom of Bridge Street before the steps up to Crown Terrace. Solab’s office can be reached by taking either the lift or stairs to the first floor. Check location on Google Maps >>

Course Outline

  • Module 1: Getting to Know Excel 2016

  • Module 2: Creating a New Workbook

  • Module 3: Working With Workbooks

  • Module 4: Editing in a Workbook

  • Module 5: Selecting Ranges

  • Module 6: Copying Data

  • Module 7: Filling Data

  • Module 8: Moving Data

  • Module 9: Formulas and Functions

  • Module 10: Formula Referencing

  • Module 11: Font Formatting

  • Module 12: Cell Alignment

  • Module 13: Number Formatting

  • Module 14: Row and Column Formatting

  • Module 15: Working With a Worksheet

  • Module 16: Sorting Data

  • Module 17: Filtering Data

  • Module 18: Printing

  • Module 19: Creating Charts

  • Module 20: Getting Help

  • Module 21: A Guide to Brilliant Spreadsheets

Course Completion

You will have the ability to organise, manage, track, analyse and present Excel data.

On completion of the course you will receive a certificate.

Solab, training your business.

Get in touch

Talk to our learning advisors about your training requirements
or try our FREE Training Needs Analysis – contact Solab team today!