Microsoft Excel Level 2

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

This course introduces the user to the intermediate features of Microsoft Office Excel 2016 to attain proficiency as a competent Excel user.

Audience

This course is aimed at those wishing to gain the skill sets necessary for calculating data using functions and formulas to manipulate worksheets.

Learning Objectives

By actively participating in this course, you will learn about the following:

  • Understand and use setup and printing issues.
  • Understand and use a variety of functions.
  • Create a variety of formulas.
  • Create and use named ranges.
  • Perform cell formatting and worksheet manipulation.
  • Use and create templates.
  • Use a variety of paste special options.
 Pre-Requisites

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

Course Contents
  • Setup and printing issues
  • Functions and formulas
  • Time and date functions
  • Mathematical functions
  • Logical functions
  • Statistical functions
  • Financial functions
  • Lookup functions
  • Database functions
  • Named ranges
  • Cell formatting
  • Manipulating worksheets
  • Templates
  • Paste Special options

Head Office

Skilltec Training

58 New George Street
City Centre
Plymouth
Devon
PL1 1RR

enquiries@skilltec.co.uk
01752 227330

Follow us on:

Payment methods:

Registered in England 06131527

Registered address: 58 New George Street, Plymouth, PL1 1RR