Microsoft Excel Level 3

Course Code: EX16L3   Duration: 1 Day   Price: £285+VAT
Overview

This course is designed for users who want to take more control of Microsoft Excel 2016 and use it in order to facilitate business decisions. This course allows users to start analysing data for the good of the business rather than just using it as an end user.

Audience

This course is designed for those wishing to gain the skills necessary to automate some common Excel tasks.

Learning Objectives

On completion of this course, you will be able to:

  • Understand and create pivot tables
  • Understand and use input tables.
  • Create advanced charts.
  • Create and use hyperlinks and linking & embedding.
  • Import text files.
  • Use various methods of sorting and filtering data.
  • Use the track changes feature.
  • Create and use scenarios.
  • Understand and use data validation.
  • User Excel’s auditing feature.
  • Create and run macros.
  • Use various password and security features.
Pre-Requisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

  • Microsoft Excel Level 1
  • Microsoft Excel Level 2
 Course Contents
  • Pivot tables
  • Input tables
  • Charts
  • Hyperlinks
  • Linking and embedding
  • Importing text files
  • Sorting and filtering data
  • Tracking and reviewing changes
  • Scenarios
  • Validating
  • Auditing
  • Macros
  • Passwords and security issues