MS Excel (Intermediate) - 2007/2010

Course Date: 13^th January 

Member Rate: €110.00

This course is designed for those who may have been using MS Excel 2007 or 2010 for some time, but have never received formal training. We will work through basics including the use of shortcut keys & some less familiar formatting options. We will then move on to more intermediate topics such as working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among other options.

Objectives:

On completion of this course participants will be able to use much of the functionality with MS Excel including:

• Competent use of Shortcut Keys
• Use formatting tools such as the format painter
• Write and copy formulas – Relative / Absolute
• Work with multiple worksheets and write formulas across sheets / Link Sheets
• Create professional looking charts and use drawing tools to enhance these
• Use the database functionality of MS Excel – Sorting & Auto Filter

Personal Productivity using MS Outlook 2007/2010

Course Date: 14^th January

Member Rate: €140.00

Would you like to have an EMPTY INBOX at the end of each day?!

Would you like to have an organised system that will help you work more effectively on a daily basis?

Then this course is for you! It will provide you with a totally practical and workable solution to managing your workload and time more effectively.

The emphasis of the day is the practical application of the 'Time Management Best Practice' theory using MS Outlook as the tool. This course has been designed to provide you with the knowledge, skills and competencies to effectively use Outlook as your organisational tool.

Following this course participants 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 course is ideal for anyone who feels that there aren’t enough hours in the day and who is overwhelmed by their workload. This course is only €140.00 for Chamber members so don’t delay, BOOK TODAY!

MS Excel (Advanced) 2007/2010

Course Date: 20^th January

Member Rate: €110.00

This course is designed to follow-on from the MS Excel Intermediate course. Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate tasks, 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.

Objectives:

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

Effective Presentation Skills

Course Date: Wednesday 19^th February

Member Rate: €130.00

This course combines the perfect balance of theory with practical presentation techniques over one day resulting in a comprehensive training course giving participants the skills required to deliver effective presentations in a clear, concise and confident manner. Participants will learn how to structure a presentation to gain maximum effect and impact, control their nerves and convey a professional image through the presentation.

Participants will practice and deliver their presentation a number of times throughout the day. One of these sessions is recorded and feedback will be offered.

Following this course, participants will:

• Understand the importance of knowing your audience
• Plan an effective presentation
• Overcome Nerves
• Beginning and ending a presentation successfully
• Be familiar with a strong presentation structure
• Getting the audience’s attention and keeping it
• Establishing the audience's attention and keeping it
• Properly using your eyes, hands, voice and stance
• Handling Q & A

This course is aimed at those who would like to gain confidence when designing and delivering a presentation and would like to learn a process that can be applied for all future presentations.

Participants should come to the course with a Presentation topic in mind. When choosing your topic, bear in mind that initially you will build your presentation around your chosen topic and deliver it at the end of the day. Therefore, it should be a topic that you are familiar with and one that you would be comfortable speaking on. It can, but does not have to be work related. BOOK NOW!