Description

This course is designed to follow-on from MS Excel Level Two (Intermediate).  Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate topics, it is now time to build on tha knowledge.  A large proportion of the course is dedicated to using the Database Features in MS Excel – this is a very powerful side to Excel that not many people utilise to its fullest potential.  Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc.  It is highly recommended that you firstly attend Level Two (Intermediate) prior to attending Level Three as some of the topics covered in Level Two are essential for successful completion of Level Three.

Main Topics

Essentials and shortcuts

Named Ranges

Text Manipulation

Database Features

Working with Pivot Tables

More on Functions

What IF Analysis

Auditing

Macros

Content, Worksheet & Workbook Protection

It is 1-Day Programme and spaces are limited.

Please book online

For more information email Cillian at cgriffey@shannonchamber.ie or call 061 360611

Training Cancellation Policy: Training courses which are cancelled over 7 days in advance of scheduled training date shall incur no cancellation fee. Training courses which are cancelled within 7 days of scheduled training date shall incur a cancellation fee equal to 50% of the cost. Registrants who fail to attend training will be charged 100% of the full fee.

Please quote Purchase Order number if required on invoice. Cheques should be made payable to Shannon Chamber Skillnet. 

Shannon Chamber Skillnet is funded by member companies and the Training Networks Programme, an initiative of Skillnets funded from the National Training Fund through the Department of Education and Skills.

For further information please visit www.skillnets.ie