Overview

This course will expand your Excel knowledge and skills. This course is aimed at those that have an understanding of the basics of Microsoft Excel such as creating workbook, using AutoFill and AutoSum, constructing formulae, Absolute Cell References and formatting worksheets.

Suitable For: Any member of staff within the school or an academy.

Date & Venue: Please see the Training Schedule

Time: Full day 9:30am to 3:30pm with a break for lunch (lunch not included). Refreshments will be provided.

Cost: If you have a Finance package 150 credits per delegate or if no Finance Package purchased please refer to Schools Finance Packages 2018

What you will need to bring

• Memory stick
• Lunch

Objectives

By the end of the course you will be able to:

• Create Charts
• Manipulate and Control Worksheets
• Link Data from one Worksheet to Another
• Apply Different Pasting Techniques
• Apply Conditional Formatting
• Validate Data Entry
• Sort/Filter Data

Details

Formulas and functions

How to use formulas such as: if, and, or, Vlookup, sumif, count, countif.  Use of the Function wizard to construct your formulas.

Worksheet techniques

How to rename, insert, delete, move, copy and hide worksheets.

Data linking

How to link data contained within another workbook to your current workbook.

Creating charts

How to create charts based on the data contained within your workbook (e.g. pie charts, bar charts, line graphs etc.)

Special pasting

How to apply special pasting techniques (e.g. paste values, paste formats, paste formulas, transposing ranges etc.)

Conditional formatting

How to apply specific formats to cells based on the entry within them.

Hyperlinks

How to insert a hyperlink into a worksheet.

Sorting data

How to sort data using multiple criteria.

Filtering data

How to filter data based on custom criteria.