25,000+ Courses Nationwide
0345 4506120

Microsoft Excel 365 Level 2

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

Target Audience

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

Select specific date to see price, venue and full details.

Learning Objectives

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

  • 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 be successful in this course, we recommend you first attend the following course or have equivalent knowledge:

  • Microsoft Excel 365 Level 1

Course Content

Set up and printing issues.

  • Functions and formulas.
  • Time and date functions.
  • Mathematical functions.
  • Logical functions.
  • Statistical functions.
  • Text functions.
  • Financial functions.
  • LookUp functions.
  • Database functions.
  • Named ranges.
  • Cell formatting.
  • Manipulating worksheets.
  • Templates.
  • Paste Special options.

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best