Description

Excel 2007 is a very powerful tool for quickly and easily manipulating and analysing large amounts of numerical data. It is perfect for analysing class marks, departmental marks, attendance figures etc, in fact any large amount of data.
This self study guide will concentrate on using conditional formula – IF function – to derive grades from raw scores both on a class context and for a whole department/school basis. You will also examine an alternative method of deriving grades using a LOOKUP. You will then filter the list using the AutoFilter and Advanced Filter tools to extract some detailed information.

Content:

1. Use absolute cell addressing
2. Use absolute cell addressing
3. Use a nested IF function
4. Use a LOOKUP function
5. Use the ROUND function
6. Use an array in a formula
7. Use AutoFilter
8. Use Advance Filter

Level: Proficient users

Audience: All education staff

Pre Skills:

1. Competence with a recent version of Windows
2. Competence with Excel 2007: Enhancing the appearance of your spreadsheet and Excel 2007: Using charts and graphs

Hardware: Personal computer (PC)

Software: Microsoft Excel 2007