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: View course dates and venues
Time: Full day 9.30-15.30 with a break for lunch (lunch not included) but 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
By the end of the course you will be able to:
How to use formulas such as: if, and, or, Vlookup, sumif, count, countif. Use of the Function wizard to construct your formulas.
How to rename, insert, delete, move, copy and hide worksheets.
How to link data contained within another workbook to your current workbook.
How to create charts based on the data contained within your workbook (e.g. pie charts, bar charts, line graphs etc.)
How to apply special pasting techniques (e.g. paste values, paste formats, paste formulas, transposing ranges etc.)
How to apply specific formats to cells based on the entry within them.
How to insert a hyperlink into a worksheet.
How to sort data using multiple criteria.
How to filter data based on custom criteria.
Contact: Email firstname.lastname@example.org Telephone 01296 382222 option 3