Microsoft Excel Advanced

  • Event: Microsoft Excel Advanced
  • Date: 12/09/2018
  • Time: 9:30 AM - 4:30 PM
  • Venue: The Park Inn by Radisson, Shannon Airport, Shannon, Co Clare
Book Now Add to your calendar

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 that 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.

Member Fee €150

Non Member Fee €170

Please book online

For more information contact Cillian Griffey email 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 cancel within 24 hours or 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 co-funded by Skillnet Ireland and member companies. Skillnet Ireland is funded from the National Training Fund through the Department of Education and Skills.

For further information please visit www.skillnetireland.ie