MS Excel Advanced

Course Dates: Friday, 25^th October 2013

Member Rate: €100.00

This course is designed for experienced users of MS Excel who would like to maximise their use of the application through the use of the advanced functionality of MS Excel including advanced data analysis tools including Pivot Tables. You will cover functions such as IF & VLookup / HLookup & will look at automating tasks through the use of Macros.

On completion of this course participants will be proficient in the more advanced functionality of MS Excel including:

• Advanced Data Analysis – Advanced Filtering, Creating Names Ranges, Sub-Totalling feature, Database Function, Pivot Tables
• Recording Macros
• IF, Lookup and other functions
• Goal Seek & Scenario Manager
• Protecting worksheets & workbooks

This course is designed for experienced users of MS Excel. Ideally you should have completed an Intermediate training course prior to attending this advanced programme. 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) or have extensive experience of the functions covered at Intermediate level prior to attending as some of the topics covered in Level Two are essential for successful completion.

This course is only €100.00 for Chamber members, so don’t delay, BOOK TODAY!!

Personal Productivity using MS Outlook

Course Date: Friday, 1^st November 2013

Member Rate: €130.00

This one day course will provide you with an effective means to reduce mind clutter and an easy to apply method of managing and prioritizing workload and overcoming e-mail deluge. This course, based on the 2007/2010 version of Outlook, will enable you to have an EMPTY INBOX at the end of each working day!

Following this course you will:

• Be aware of Time Management theory (Best Practice)
• Be familiar with MS Outlook Shortcut Keys
• Be able to use timesaving everyday functionality in MS Outlook
• Have customised Outlook to make it work more effectively as a time management tool
• Know how to create tasks in order to prioritise and manage workload
• Know how to create tasks directly from email as an effective method of deferring less urgent work
• Have the ability to use the calendar and tasks to manage working days realistically
• Able to collaborate with other users through meeting invitations, sharing calendars etc.

This invaluable one-day course is available at a cost of only €130.00, so don’t delay, BOOK TODAY!  

See our full range of courses at www.corkchamber.ie/training

Bookings can be completed through the website and enquiries should be directed to Aoife@corkchamber.ie  (Training Services Administrator)

BUSINESS SCHOOL CALENDAR

October

Certificate in Supervisory Management         23^rd October

November

Personal Productivity using MS Outlook  1^st November

PMI Exam Preparation Course 5^th November

Certificate in Train the Trainer 6^th November

E-Mail & Business Writing     6^th November

MS Project 2010       11^th November

Increasing Sales by Telephone  12^th November

Project Management Professional   20^th November

Influencing & Negotiating Skills  20^th November

Present & Express with Confidence 28^th November