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
020 8203 1774
Email