Limerick City

Excel - Intermediate

Duration 1 Day, 9.30am to 4.30pm.
Comment Each participant will have use of an individual computer and will receive notes and exercise files on CD at the end of the course
Number of Places 10
Course Fee €120 Per Person
Subjects Taught The course may include the following areas:
•Understanding how formulas are created.
•Understanding the difference between “relative” and “absolute” cell references.

•Naming cells and ranges and using names in formulas
•Understanding and using dates in calculations.
•Inserting comments.
•Creating custom lists.
•Conditional Formatting.
•Sorting by more than one field.
•Advanced Excel Charts –Trendlines, Combination Charts, Pareto Charts.
•Retrieving records using autofilter, custom and advanced filters.
•Using the following Excel functions ONLY:
 IF
 Sum / Min / Max
 Average / AverageA
 Count / CountA
 Countblank
 Concatenate
 Left / Right / Mid
 Today() / Now ()
 VLookUp

Enrolment and Start Dates Comment Wednesday May 1st 2013.
Course Content This course is specifically for those who already know how to input data into a spreadsheet and who are working on sheets created by others but want to know how to set up and manage their own worksheets.
Entry Requirements Course Prerequisites

Before attending this course you need to be familiar with the basic functions of Excel and be able to open, navigate and print a worksheet. A basic knowledge of formulas is helpful. You should be able to generate a basic chart.

N.B. The course content is as listed – This course DOES NOT cover Macros or Pivot Tables.

**Time constraints plus the needs and abilities of the group members, may result in some of the less important items being covered in the notes only.

Further Enquiries Anne Morris
Network Manager
t: 061 217608
e: amorris@limerickchamber.ie
Location of Course Training Point
Portal House
Raheen Business Park
Co Limerick
Available to Job Seekers: 
Yes
Certified: 
No

Excel - Advanced

Duration 1 Day 9.30am to 4.30pm
Comment Each participant will have use of an individual computer
and will receive notes and exercise files on CD at the end of the course.
Number of Places 10
Course Fee €120 per person
Subjects Taught The course content may include the following areas:
•Confirmation Of Course Prerequisites.
•Use data validation to force compliance with input standards.
•Creating data input tables.
•Creating Table lists.
•Using Goal Seek.
•Create and use a Pivot Table.
•Field Settings.
•Creating Formulas in Pivot Tables.
•Rearranging and filtering Pivot Tables.
•Grouping data in Pivot Tables.
•Creating Pivot Charts.

•Protect a document.
Recording a Macro
•How to Nest one function within another function.
•Dealing with error messages in formulas.
•Use the following Excel functions:

•VLOOKUP (Advanced Level)
•IF (Advanced level)
•IF AND (IF OR)
•Nesting IF Functions
•SUMIF, COUNTIF
•TODAY, NOW
•ISNA, ISERR, ISERROR
•Importing text delimited files (CSV or Tab delimited).

Enrolment and Start Dates Comment Takes Place on Wednesday April 10th 2013
Course Content This level of Excel starts by introducing some of the more advanced functions within Excel for managing database material. It will then cover many of the advanced features. This course will give a fuller understanding of “Why” functions work rather than just “How” to perform them and will prepare you for continued learning of Excel. Please ensure you meet the course Pre-requisites before attending this course.
Entry Requirements Course Prerequisites: You MUST be able to do the following intermediate level items before attending this course:

 Create, Understand and Use, Absolute cell referencing, (using $A$1 instead of A1 in a formula).
 Create and Manage NAMES - Name a cell or range of cells and use names in formulae instead of cell references.
 Use a basic IF function.
The following items are covered at Intermediate level and will not be covered on the advanced course.
 Create Graphs & Charts
 Sort columns of data;
 Use Filters.

N.B. This course DOES NOT cover VBA (Visual Basic for Applications) or Dashboards.

**Time constraints plus the needs and abilities of the group members, may result in some of the less important items being
covered in the notes only.

Further Enquiries Anne Morris
Network Manager
t: 061 217608
e: amorris@limerickchamber.ie
Location of Course Limerick Chamber of Commerce
96 O'Connell Street
Limerick
Available to Job Seekers: 
Yes
Certified: 
No

Speakers Training Camp

Duration 2 days, 8.45am - 5.00pm.
Number of Places Limited to 8 People
Course Fee €395.00 Per Person
Enrolment and Start Dates Comment Dates: 11 & 17 April 2013
Course Content Speakers Training Camp
Sean Dwan provides on-site training and hands-on workshops for people who would like to improve their public speaking abilities and methods of presentation. He is an International Certified Speakers Training Camp Instructor ®, and is famous for his great sense of humour, optimism, enthusiasm and his personable approach. The SpeakersTrainingCamp® is known throughout the world and has been provided to companies such as British Airways, Owens Corning, General Dynamics, Fortune 500 Companies, Educational Institutions and a wide range of small and medium sized companies. Session lengths of the SpeakersTrainingCamp® workshop can be adjusted to accommodate your specific needs.

General Outline
• Top-rated Presentation Skills Workshop.
• Limited to 8 People.
• 80% Active Participation.
• Individual Coaching.
• Individual Take – Home Video.
• 47-Page SpeakerTrainingCamp® Manual.

You Will Learn
• How to organise and deliver effective presentations.
• The ONLY presentation template you will ever need for organising your thoughts, stating your points clearly and making an impact with your audience.
• You will learn the Top Three Techniques for capturing your audience attention and maintaining their interest throughout your presentation every time.
• No 1 Thing that an audience wants from a presenter.
• TOP 10 Turn Offs to avoid when presenting.
• How to dress appropriately for every audience.
• How to make a good impression on your audience.
• Voice Projection.
• Eye Contact and Facial Expression.
• Appropriate gestures and body language.

Programme Highlights
• Master the magic of memorable presenters.
• Captivate your audience.
• Cut preparation time in half.
• Become more dynamic.
• Organise your thoughts.
• Apply 10 techniques for handling nervousness.
• Maximise your voice.
• Make dull facts and figures come to life.
• Effectively use humour.
• Handle questions with ease.
• Avoid the top terrible turn-offs.
• The SpeakersTrainingCamp® programme will improve your speaking and presentation skills beyond all recognition.
• Your confidence and self esteem will soar.

Further Enquiries Anne Morris
061 217608
amorris@limerickchamber.ie
Trainer Sean Dwan Speak for Success
Location of Course Radisson Hotel
Littleisland
Co Cork
Available to Job Seekers: 
Yes
Certified: 
No

Statistics - Basic

Duration 2 Days
Number of Places 10
Course Fee €215 members
€295 non members
Enrolment and Start Dates Comment 20th May 2013
Course Content Day 1
• Graphical Methods
• Statistical terms and concepts
• Central Limit Theorem
• Histograms, Boxplots, Dotplots, Scatterplots, Time Series Plots,Matrix Plots, Pareto etc
• Process Variation and Measures of Central Tendency
• Descriptive Statistics
• Probability Distributions – normal, t, F, Chi-square, binomial, Poisson
• Control Chart Basics

Day 2
1. Confidence Intervals for means and proportions
2. Tests of hypotheses
• Comparison of means (t-Tests)
• Proportion Tests
• Tests for Equal Variances
• Non-parametrics tests (Kruskal-Wallis)
1. Power and Sample Size
2. Regression Analysis
3. Correlation Analysis
4. Analysis of Variance (ANOVA)

Further Enquiries t: 061 423 622
e: kate@icbe.ie
e: info@icbe.ie
Learning Outcomes At the end of the course the learner will be able to
• Select and use the correct tool for analysing quality data
• Interpret session window and graphical outputs from Minitab
• Understand basic statistical principles
• Know how to analyse the variation that arises in manufacturing processes and business
• Understand the concepts of hypothesis testing and how statistics is used to make process improvement decisions
• Understand how to establish confidence for the results of data analysis
• Know how to obtain sample sizes for hypothesis testing.
Trainer Simon A. Jege
Location of Course Shannon
Available to Job Seekers: 
Yes
Certified: 
No

Practial Project Management - 2 day

Duration 2 Days
Number of Places 12
Course Fee €375 member €450 non member
Subjects Taught Course Timetable:
Time Day 1 Day 2
08:30am
Introduction PM Concepts Project Management Framework Identifying Risks Mitigation Contingency

10:50am Coffee Coffee

11:00am
Integration Management
Cost / Resource Management
Managing Remote Teams

12:30pm Lunch Lunch

1:15pm
Scope Management Creating a Work Breakdown Structure
Communications Management

3:00pm Coffee Coffee

3:10pm
Time Management Estimation Scheduling
Stakeholder Management Negotiation 5:00pm Summary Summary
5:30pm Close Close

Enrolment and Start Dates Comment 13th May 2013
Course Content Practical Project Management
(2 Days in class, 6 - 14 students)
At AspiraCon we have adopted a range of methods to facilitate accelerated learning and to maximize future application in the workplace. Our approach recognises that trainees must be involved in the learning process and hence we incorporate a high level of interactivity during delivery in order to gauge the transfer of this learning. Interactive sessions such as brain storming, buzz-groups and breakout sessions, role-play and simulated real-life environment compliment training material and promote better retention of course content. Each session includes an introduction during which set ground rules for engagement and

Confidential 08 January 2013
confidentiality, learning objectives, participatory methodologies, and activities. Tailored case studies and knowledge retention tests are incorporated into each training course maximizing the opportunity for participants to learn by doing. Our trainers are adept at incorporating appropriate examples and information so that trainees will have a relevant frame of reference.

Considering that adults learn at different rates, we utilize a variety of teaching methods (accelerated learning, group work, individual exercises, encouraging participation) during delivery allowing us to stay true to the content while maximizing the experience for all learners. Our training personnel are highly skilled at listening effectively and endeavour to give constructive feedback when appropriate.

Learning Objectives:
• Understand the five process groups: Initiating, Planning, Execution, Control and Closing.
• Learn the ten knowledge areas of project management (Integration, Scope, Time, Cost, Quality, Human Resources, Communications, Risk, Procurement and Stakeholder Management).
• Get a detailed understanding of some of the key knowledge areas, including:
• How to put together a Project Charter – what’s important and what’s not
• Creating a Work Breakdown Structure and using it to make sure that you capture the full scope of the project
• Estimation – understand how to come up with reliable effort and duration estimates
• Confidential 8 January 2013
• Schedules – how to create and optimise a schedule so that you can have a realistic plan that can be achieved
• Learn how to identify risks to your projects success, and some techniques to minimise the impact of those risks to the project
• Explore some Project Communication methods that will help you get the right information to your key project stakeholders
• Learn how apply this learning to the participant’s own particular project/environment through use of case studies and working exercises based on realistic problems and real-life project scenarios and through completion of an assignment, including individual feedback and mentorship for each person.

Further Enquiries t: 061 423 622
e: kate@icbe.ie
e: info@icbe.ie
Trainer AspiraCon www.AspiraCon.com
Location of Course Cork
Available to Job Seekers: 
Yes
Certified: 
No

Supervisory Management

Duration 3 Days. Time: 9.30am – 5.00pm.
Number of Places 12
Course Fee €505.00 per member / €595.00 non member
Subjects Taught • Role of the Manager
• Developing Leadership Skills
• Stages of the Leadership Journey
• Authentic Leadership

Understanding Behaviour
• Behaviour types
• Rights & Responsibilities
• What is Assertive Behaviour?
• How to become assertive

Communication
• Simple model of communication
• 6-stage model of communication
• Active listening
• Steps for Assertive Communication
• Assertiveness Skills & Techniques

Motivation
• What is motivation?
• Motivating others
• Motivation and management style
• Steps for keeping yourself motivated

Teamworking
• What is a team?
• Stages of Team Development
• Management style for team stages

Time Management
• The myth of Time Management
• Efficiency or Effectiveness
• Setting priorities

Day 2
Planning
• The 7 stages of Planning
• Elements of a Plan
• SMART Objectives
• Mind Mapping

Coaching
• Coaching in the workplace
• Understanding when coaching can be used
• Essential Coaching Skills
• The Adult Learning Cycle
• Coaching Structures
• Coaching Teams

Delegation
• Analyse the task
• Analyse the person
• Agree a monitoring system
• Set the climate for delegation
• Review Progress

Upward Assertion Managing Conflict
• Sources of Conflict
• Steps to managing conflict
• Managing conflict assertively
• Conflict Management Styles

Enrolment and Start Dates Comment 14th, 22nd & 30th May 2013.
Course Content Role & Responsibilities
Communication to Influence
Leadership & Motivation
Team Management
Delegation
Managing Conflict
Understanding Legislation
Coaching / Mentoring
Performance Management
Further Enquiries t: 061 423 622
e: kate@icbe.ie
e: info@icbe.ie
Learning Outcomes At Course Completion:
Candidates understand how to have a positive impact on the team through developing Supervisory Management skills. Candidates understand how planning is a key component of success. Candidates understand people management and conflict resolution.
Trainer Cork
Location of Course Cork
Available to Job Seekers: 
Yes
Certified: 
No

Leadership & Managing People Programme

Duration 4 days
Subjects Taught • Leadership
• Managing Performance
• Communication
• Interpersonal skills
• Employment Legislation
• Negotiation
• Grievances
• Industrial Relations Institutions
• Giving Feedback and Managing Problem People
• Motivation
• Discipline and Dismissals
• Counselling and Coaching
• Employment of Staff
• Conflict Resolution
Enrolment and Start Dates Comment tbc
Network Manager Pauline O'Flanagan, pauline@lifesciencesskillnet.ie
Course Content The primary objective of the Managing People Programme is to enable front-line managers to make a more effective contribution to the organisation by developing core skills central to managing people at work.

Participants will:
• Understand and appreciate the full extent and importance of your role in managing people
• Improve your interpersonal skills to enable you to deal more effectively with people at all levels within the organisation and act with greater confidence
• Acquire the key tools for managing people through a practical approach to skills development in such areas as motivation, managing problem behaviours, counselling, assertiveness and negotiations.
• Develop an appreciation of grievance and disciplinary procedures and improve your effectiveness in handling issues in these areas.
• Gain an overview of the key areas of employment legislation and become more confident when dealing with queries in relation to these.

Further Enquiries Michelle Reinecke-Quain
Life Sciences Skillnet Administrator
Email: michelle.reinecke-quain@ibec.ie
Phone: 061 431802
Available to Job Seekers: 
No
Certified: 
Yes

Mobile IT Computer Training, Excel, Word, Visio - all levels

Duration 1 Day
Number of Places 11
Course Fee €597.00 per course
Subjects Taught Mobile IT Training- Microsoft Word, Excel, PowerPoint, Visio, Project. Tailored to your needs.
Enrolment and Start Dates Comment Courses catered for Nationwide
Contact Network Manager Pauline O'Flanagan, pauline@lifesciencesskillnet.ie
Further Enquiries Michelle Reinecke-Quain
Life Sciences Skillnet Administrator
Email: michelle.reinecke-quain@ibec.ie
Phone: 061 431802
Trainer Productive Solutions
Location of Course In house IT Microsoft Package Training Nationwide.
Available to Job Seekers: 
Yes
Certified: 
No

Convert Website Visitors to Sales

Network: 
ISME Skillnet
Duration 1 day
Dublin, 9.30am - 5.30pm.
Number of Places 10
Course Fee €215 ISME Members.
€295 non members.
No charge to Job Seekers.
Subjects Taught Course Content:
• Planning – identifying your USP’s/benefits, navigation, structure, content, imagery, identifying your website goals etc
• Getting found – SEO and other methods to drive traffic to your website, SEO checklist
• Generating click through – what does your search engine listing say about, it is generating clicks. Are your third party links driving quality traffic to your website?
• Developing interest – navigation rules, good content, technical issues etc
• Promoting enquiry – landing pages and clear call to actions
• Closing the sale – on-site and off-site sales processes and procedures
• Tracking – using Google analytics to monitor and analyse traffic
• Briefing your website developer
Enrolment and Start Dates Comment 13 June 2013. Booking Essential - Contact liz@isme.ie.
Course Content This workshop is designed to take you through the step by step process for turning website visitors into clients from being found, generating click through, developing interest, promoting enquiry and closing the sale.

Hand-outs:
Each participant will receive a copy of the presentation with details of all sites and tools covered throughout the workshop and a list of tasks that need to be completed on their website to ensure it complies with best practice guidelines.

Entry Requirements Work experience
Further Enquiries Liz Carroll. Email: liz@isme.ie. Tel. 01 6622755
Learning Outcomes At the end of the day you will:
• Be able to evaluate your websites effectiveness
• Understand the key steps to ensuring your website is found online and convert a large percentage of visitors
• Learn the principals of building an effective website.
Trainer Sandra Hennessy
Location of Course Dublin, Waterford, Limerick, Cork.
Available to Job Seekers: 
Yes
Certified: 
No

Lead Auditor Training - IRCA Certified

Duration 5 days
Comment The programme is internationally approved by IRCA – International Registration Scheme for certified training programme and Auditors.
Number of Places 10
Course Fee Life Sciences Members €600 / person
Subjects Taught Fundamentals Of Quality, Drug GMP Requirements, Regulation, Auditing.
Enrolment and Start Dates Comment Enrol by Friday 31 May 2013
Course Dates:
Limerick - 18 June 2013
Sligo - 4 June 2013
Athlone - 8 October 2013
Course Content Lead Auditor Training IRCA Certified Course During the 5 days participants will acquire knowledge and skills in auditing. However, auditing like any other acquired skill requires practice. The best place to practice and extend your experience is during actual audits.
Careers or Further Progression Professional Certified Lead Auditor
Entry Requirements Working with quality systems
Further Enquiries Michelle Reinecke-Quain
Life Sciences Skillnet Administrator
Email: michelle.reinecke-quain@ibec.ie
Phone: 061 431802
Eligibility Lead Auditor Training IRCA Certified Course During the 5 days participants will acquire knowledge and skills in auditing. However, auditing like any other acquired skill requires practice. The best place to practice and extend your experience is during actual audits.
Learning Outcomes By the end of the course participants will be able to:
• Describe the purpose of a quality management system and explain the 8 principles of quality management.
• Explain the purpose, content and interrelationship of ISO 9000, ISO13485, ISO 9004 and ISO 19011.
• Interpret requirements of ISO 13485 in the context of an audit.
• Manage an audit programme.
• Understand the different types of audits.
• Describe the roles and responsibilities of auditors and lead auditors.

• Plan and conduct an audit in accordance with ISO 19011, demonstrating ability to:
a) plan and prepare effectively
b) gather objective evidence, through effective interviewing,
observation, sampling and note taking.
c) analyse and interpret information in order to determine
conformance with requirements.

• Report the audit, including writing valid, factual and value-adding non-conformity reports.
• Undertake audit follow-up activities, including evaluating the effectiveness of corrective action.
• Professionally liaise with external auditors.

Methods of Assessment Theory and Practical
Trainer Martin Reddington
Irish Quality Centre Galway & Sligo
Kelamc Group Clonmel
Location of Course Limerick
Sligo
Athlone
Available to Job Seekers: 
No
Certified: 
No
Syndicate content