25,000+ Courses Nationwide
0345 4506120

Microsoft Excel 365 Level 3

This course is designed for users who want to take more control of Microsoft Excel 365 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.

Target Audience

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

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

Learning Objectives

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

  • Understand and create PivotTables.
  • 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.
  • Use Excel’s auditing feature.
  • Create and run macros.
  • Use various password and security features.

Pre-Requisites

To be successful in this course, we recommend you first attend the following courses or have equivalent knowledge:

  • Microsoft Excel 365 Level 1
  • Microsoft Excel 365 Level 2

Course Content

  • PivotTables.
  • Input tables.
  • Charts.
  • Hyperlinks.
  • Linking and embedding.
  • Importing text files
  • Sorting and filtering data.
  • Tracking and reviewing changes.
  • Scenarios.
  • Validating.
  • Auditing.
  • Notes and Comments.
  • Macros.
  • Passwords and security issues.

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