Intermediate Excel - Derby - 17.10.12

Course:Intermediate Excel - Derby - 17.10.12
Type:Open Course
Program:Information Technology
Venue:Derby Office
Date:17th October 2012
Time:9.30am - 4.30pm
Available To:Members and Non Members
Members Price:£150.00 + VAT
Non Members Price:£195.00 + VAT

Course Description

Benefits

This course will introduce you to some of the more powerful tools available within Excel and enable you to build complex formulae and gain a greater understanding on how Excel can save you time.  You will learn and see new features that will help you to use Excel more efficiently.

Who Should Attend?

Users who are familiar with and have a good understanding of Excel.  Those who use it regularly and write their own basic formulas. 

This is a "packed" course and due to the level of content, not all topics may be covered (to be agreed during training). 

Content

Filling data

Formulas and formula referencing

Cell Alignment

Working with worksheets

Finding and replacing

Page set up

Headers and Footers

Sorting data

Charting techniques

Chart object formatting

Logical Functions (IF, AND, OR, NOT, IF ERROR)

Lookup Functions (VLOOKUP, HLOOKUP, INDEX)

Filtering data

Setting Excel options

The Trainer

The tutor for the course is Martin Perry who has many years experience as an IT Trainer. Martin's courses are geared to ensuring all delegates walk away with new skills regardless of their ability when they arrived. All courses are delivered in such a way that delegates continually use the applications throughout the day ensuring maximum hands on experience with numerous opportunities provided to recap on learning points.


Book Your Place Now

external link
Advertise Here