Excel 2016 (Introductory and Intermediate)

Learning Outcomes:

By the end of this course participants will be able to:

• Create and navigate Excel files

• Use time saving features such as AutoSum, AutoFill and creating formulae

• Format and customise worksheets

• Display data in charts

• Customise Quick Access Toolbar

• Use formulae effectively

• Create templates

• Use productivity tools and apply protection to a worksheet

• Edit simple data to a required format and layout.

• Produce and format a chart.

• Incorporate simple built-in functions.

• Organise and maintain data.

• Develop a template.

Prerequisites

• It is recommended that participants have basic experience with the underlying operating system, i.e. an ability to navigate the environment using a mouse and keyboard plus an understanding of computer file storage.

Customisation

• In addition to our standard courseware, we can adapt course content and flow to your specifications.