Microsoft Excel Level 1

Course Code:  EX16L1     Duration: 1 day     Price: £285+VAT
Overview

This course introduces delegates to the basic functions of Microsoft Excel 2016 and will enable them to create worksheets and perform formatting and functions within the worksheet.

Audience

This course is designed for people who wish to gain the skills necessary to create, edit, format and print basic Microsoft Excel 2016 worksheets.

Learning Objectives

On completion of this course delegates will be able to:

  • Navigate the Excel programme.
  • Perform selection, manipulation and formatting techniques.
  • Understand and create basic formulas and functions.
  • Understand and create basic charts.
  • Perform customisations.
Pre-Requisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs, navigate to information stored on the computer, and manage files and folders.

Course Contents
  • Getting started with Excel
  • Selection techniques
  • Manipulating rows and columns
  • Worksheets
  • Font formatting
  • Alignment formatting
  • Number formatting
  • Freezing row and column titles
  • Formulas
  • Functions
  • Charts
  • Customising Microsoft Excel 2016