Microsoft Excel Intermediate

Description

By the end of the course, you will be confident in going beyond the basic features in Excel. For example using multiple sheets, linking them to create formulae across sheets, use common functions such as Average and If statements and manage data in an Excel database.

What you will learn

In particular you will be able to:

  • Protect part of your spreadsheet to avoid deleting formulae
  • Create and work on more than one worksheet
  • Copy part of your Excel spreadsheet to a Word document and have any changes made in Excel updated in the Word document
  • Use features such as average, minimum and maximum to create statistical information
  • Create a calculation based on a condition. For example, add a £10 bonus to all staff who have achieved results above target
  • Extract specific information from an Excel database. For example, show only the organisations with more than 1000 employees

Further information

The IT Training Surgery
Provider:
The IT Training Surgery
Duration:
1 Day
Price:
POA
Availability:
On demand
Course type:
Classroom
Locations:
London

Contact Information

The IT Training Surgery

39 Hatton Garden
London
EC1N 8EH

Locations