Microsoft

MS Office Applications - MOUS

Network:

Duration	Excel 4 Days, Access 3 Days and PowerPoint 3 Days
Number of Places	15
Course Fee	TBC
Subjects Taught	Concepts of Computer Technology Using Computer & Managing files Word Excel Access PowerPoint Internet-mail
Enrolment and Start Dates Comment	February / March / April 2013
Financial Support	Already included
Further Enquiries	Siobhan Grant e: info@technorthwestskillnet.com m: 086 270 7277
Eligibility	Employed or Unemployed
Trainer	Compupac
Location of Course	Letterkenny

Available to Job Seekers:

Yes

Certified:

No

Word - Introduction

Network:

Pharmachem Skillnet

Duration	1 day
Number of Places	8
Course Fee	€80. Job Seekers are Free
Enrolment and Start Dates Comment	Enrolment from today, the course date to be confirmed, please contact info@pharmachemskillnet.ie for more information.
Course Content	Word Basics  Introduction  Layout of the Word Window  Creating a Document  Normal / Page Layout View  Saving a Document  Closing a Document  Opening a Document  Preview & Print a Document Editing the Document  Moving around the document  Deleting and Inserting text  Selecting text Font (Text) Formatting  Applying text effects  Removing text effects  The Format Painter  Changing Font Defaults Paragraph Formatting  Paragraph Alignment  Line Spacing  Paragraph Spacing  Automatic Bullet and Numbered Lists Indents  What are Indents?  Setting Indents  Removing Indents Tabs  What are Tabs?  Setting Tab Stops  Removing Tab Stops  Modifying existing Tab Stops  Setting Tabs with a Leader Character Moving and Copying Text  Using Drag and Drop Text  How to disable Drag & Drop  Using Cut, Copy, Paste  Moving and Copying text between documents Document Control  Page Breaks  Changing Margins  Changing the Page Setup  Section Breaks  Different Page Settings in the same document Automatic Features  AutoCorrect  AutoText  Automatic Features that can be turned off Proofing your Document  Spelling and Grammar Check  Find and Replace  Summary of Speed Keys
Further Enquiries	Cora Gawke t: 087 124 5950 e: info@pharmachemskillnet.ie
Eligibility	This course is suitable for anyone new to Microsoft Word and also for those who may currently use Word from time to time but have a limited working knowledge of the application. Over one day, we will cover common everyday tasks utilising speed keys saving a huge amount of time; also we will troubleshoot problem areas such as working with tabulated lists (Tabs) and also setting paragraph Indents in the easiest way possible. At the end of this course users will be able to use the everyday features of MS Word using the fastest methods available – mouse and speed keys. It will illustrate to even experienced users of MS Word that there are many quicker methods of performing everyday tasks.
Trainer	e-bridge
Location of Course	TBC.

Available to Job Seekers:

Yes

Certified:

No

Excel - Intermediate

Network:

Limerick Chamber Skillnet

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

Course Web Page:

http://www.limerickskillnet.ie/UpcomingCoursesEvents/tabid/85/ctl/View/mid/428/Event/336/Date/20130315/Start/201305010000/End/201305012359/language/en-IE/Default.aspx

Available to Job Seekers:

Yes

Certified:

No

Excel - Advanced

Network:

Limerick Chamber Skillnet

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

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

Network:

Life Sciences Skillnet

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

Excel 2010 - Advanced

Network:

ITAG Skillnet

Duration	1 day, from 9.30am - 4.30pm.
Comment	Eligible jobseekers can attend free of charge.
Number of Places	10
Course Fee	€45
Subjects Taught	Concepts and Functionality Working with Excel Workbooks • The Excel Screen • View Options • Splitting Worksheets • Hiding Worksheets, Columns and Rows • Save Options Functions in Excel • Sumif, Countif, Conditional IF statement, worksheet subtotal, vlookup / hlookup Printing • Print Options • Page Setup Advanced Formatting • Paste special • Conditional formatting Sorting and filtering data Subtotals Pivot Tables Data Validation Advanced Chart Editing Auditing and error management Working with multiple sheets and workbooks Scenario Manager Macros
Enrolment and Start Dates Comment	16th May, 2013 - Courses are run on a regular basis please contact us to get further dates.
Entry Requirements	Must have good working knowledge of Excel prior to attending the Advanced course.
Further Enquiries	Dee Timoney Email: dtimoney@itag.ie
Trainer	Abaltacht
Location of Course	PFH,Galway Technology Park, Galway City

Available to Job Seekers:

Yes

Certified:

No

ECDL - European Computer Driving Licence

Network:

ACIST Skillnet

Number of Places	10
Course Fee	TBA
Enrolment and Start Dates Comment	August 2013 (TBA)
Financial Support	ACIST Skillnet Funding
Course Content	• Information and Communication Technology • Using the computer and managing files • Word processing • Spreadsheets • Using Databases • Presentation Graphics • Web browsing and communication
Careers or Further Progression	A stepping stone to higher level to IT education
Entry Requirements	The participant should have an understanding and have used the computer and computer software before undertaking this course.
Further Enquiries	Crystel Robbins Rynne Mob: 087 998 0303 Email: crystel@skillsacist.com
Learning Outcomes	Essential IT knowledge and skills Provides an international qualification
Methods of Assessment	A written test at the end of each module, once all 7 tests have been successfully past then the ECDL qualification will be achieved.
Trainer	TBA
Location of Course	Ennis, Co Clare

Available to Job Seekers:

Yes

Certified:

Yes

Effective Time Management Using Microsoft Outlook

Network:

ACIST Skillnet

Duration	Half Day
Number of Places	10
Course Fee	TBA
Subjects Taught	Email Messages: Inbox: • Create and Manage Folders • Create an electronic signature • Using Out-of-Office-features Tasks; creating & updating tasks, organising tasks, managing & deleting tasks. Calendar: • Personal Apppointments • Shared Calendars • Contacts
Enrolment and Start Dates Comment	April 2013. Date TBA
Financial Support	ACIST Skillnet Funding
Course Content	The aim of the course is to help delegates master the concepts of MS Outlook and to efficiently and confidently use the tools Outlook has to offer.
Entry Requirements	A good basic knowledge of MS Outlook is required.
Further Enquiries	Crystel Robbins Rynne Network Manager ACIST Skillnet Mobile: 087 9980303 Office: 0657081466 Email: crystel@skillsacist.com
Learning Outcomes	Delegates will gain more from MS Outlook and utilise its features for effective time management.
Trainer	Keytrainer was established in 1978 as a supplier of Keyboard Skills training to Corporate, Government Bodies and private individuals. In 1987 it expanded to include PC applications training and innovated the intensive Secretarial Office Skills course. In 1991, understanding the advent of more rigid application of Health and Safety standards, Keytrainer developed the first VDU ergonomics, user and environment auditing service in Ireland. Their success is due to the fact that they offer a thorough high quality service by experienced consultants and tutors with a high level of support to both the employer and the employee. Their high percentage of repeat business over the years illustrates that once a customer uses them, they stay with them. Their client base includes Banking, Financial, Government, Service and Industrial organisations.
Location of Course	Ennis (Venue TBA)

Available to Job Seekers:

Yes

Certified:

No

Microsoft Visio Professional 2010

Network:

Biznetcork Skillnet

Duration	1 Day, 9.30am - 5.00pm.
Number of Places	7
Course Fee	Cork Chamber Member Rate: €130.00 Non-member rate: €185.00
Subjects Taught	Introduction - An Overview of Visio • Visio documents • Elements of the Visio window • Visio navigation Connected Diagrams / Flowcharts • Create a Flowchart • Create a Drawing Page • Add a Shape to the Drawing Page • Add a connector manually & automatically • Working with text / Adding text to shapes • Add details to Diagrams • Modify the Design • Connecting point to point and shape to shape • Name / Save / Print a Flowchart • Copy a Diagram Page & General Options • Create a New Page • Move between Pages • Delete / Reorder Pages • Add Page Numbers / Dates • Spell Checking • Document Protection • Copy Formatting • Background Colours / Patterns • Create and add a background page • Set Line / Corner / Shadow / Style / Double Click / Behavior • Options • Insert Comments • Set Margins / Set up the Drawing Page • Add Headers & Footers • Print a Diagram Manipulating Shapes and Lines • Select/ Copy / Re-Arrange / Align / Distribute / Shapes • Freeform Shapes • Connecting Point to Point • The Shape Menu • Snap & Glue Options • Set and Change a Line Style • Add crossovers to a connector Layers • Create a new layer • Add shapes to a layer • View a layer • Colour a layer • Show objects in a layer • Print a layer Working with Master Icons, Stencils & Templates Styles Organisation Charts • Create a new organisation chart
Enrolment and Start Dates Comment	Start Date: Wednesday, 3rd April 2013
Course Content	Learn how to create and develop business-oriented drawings using Microsoft Visio. The course will look at methods of developing flow charts, organizational charts, space planning and other drawings that will be useful in a business environment. Participants will explore basic skills needed to use Visio effectively. We will develop different business drawings, customise and modify existing drawings, explore the concepts behind many of the different business-oriented drawings.
Further Enquiries	Aoife Dunne Training Administrator t: 021 453 0141 e: aoife@corkchamber.ie
Eligibility	Microsoft Visio is ideal for IT professionals, developers, and people in other roles (such as business process roles, human resources and administration) who need to interpret, update, and share complex information about processes, infrastructure, and applications.
Trainer	E-Bridge
Location of Course	Regus offices, Building 1000 (2nd Floor), City Gate, Mahon, Cork

Course Web Page:

https://www.corkchamber.ie/biznetcork-skillnet/2013/04/03/Microsoft-Visio-Professional-2010

Available to Job Seekers:

Yes

Certified:

No

Microsoft Project 2010 - Introduction - Intermediate

Network:

Biznetcork Skillnet

Duration	2 Days
Number of Places	10
Course Fee	Cork Chamber Member Rate: €260.00 Non-member rate: €370.00
Subjects Taught	Assisted Project Setup • The Project Guides • The Import Wizard • Smart Tags • Using Templates Set up a Project • Set the Project Start Date • Enter Summary Information • Modify the Project Calendar • Modify the User Options Create a Schedule • Enter Tasks • Enter Milestones • Enter Task Notes • Enter Task Dependencies • Modify the Timescale Modify / Organise a Schedule • Create a Project Outline • Modify Links • Change Constraints • Enter Recurring Tasks Format and Output • Modify the Chart and Text Appearance • Print Project Charts & Reports / Page Setup • Use Filters and Groups • Change the sort order of the task list Resource Management • Create a Pool of Resources • Assign resources to tasks • Modify Resource Calendars Manage the Project • Create a Baseline Plan • Update Project Progress • Compare the Current Plan V the Baseline Plan • Update the Project • Task Updates Update Resources • Remuneration Rates • Resource Availability • Resource Holidays • Overtime • Reports • Modify Existing Reports • Save modified Reports The Organiser • Copy Project Elements to other projects Data Mapping • Export / Import Data within Project and Excel • Project Templates
Enrolment and Start Dates Comment	Enrolment and Start Dates: 07/05/2013 for 29/05/2013
Financial Support	There are limited free places on all of our courses for jobseekers.
Course Content	Day One: Introduction Project Management Concepts Starting Microsoft Project 2010 MS Project 2010 user interface What is Project Management?; What is a Project? Getting Started with MS Project 2010 Gantt Chart View; Menus; Shortcut Menus Toolbars; Opening a Project File Using the Gantt Chart View Task Information Form; Tables; System Options Starting a New Project Project Information Dialogue Box File Properties Dialogue Box; Calendars and Setting Working Times Outlining the Plan; Milestones Creating a Summary Task; Task Notes Entering Durations; Task Relationships Linking Tasks Changing Task Relationships Lead and Lag time Scheduling a Date Constraint Using Deadlines Displaying the Project Summary Task User controlled scheduling Project Presentation Critical Path Analysis; Gantt Chart View Total and Free Slack; Formatting Timescales Printing the Gantt Chart View; Timeline View Resource Management Basic Resource Assignments; Day Two: Intermediate Resource Assignments; Creating Resource Calendars; Adjusting Resource Calendars Part-Time Resource Assignments Resource Rates and assignments Identifying Overallocation Level resources Team Planner Tracking Changes Add a Baseline; Baseline new tasks Tracking the Projects Progress Update Tasks and changing the schedule Filters Using Standard Filters Autofilters; Customising Autofilter settings Creating Custom Filters Sorting and Grouping Tables Task Tables Resource Tables Customising and Creating Tables Views Task Views Resource Views Working with Network Diagram View Customising Views Creating a new View Reports Standard reports Customising report
Entry Requirements	Existing users of Project wishing to develop their understanding and capabilities with this package. A basic understanding of PCs and familiarity with and use of a keyboard, mouse and MS Windows XP/7/8 is required, gained from previous experience or by attendance on a "MS Windows User Introduction" course.
Further Enquiries	Aoife Dunne Training Administrator t: 021 453 0141 e: aoife@corkchamber.ie
Learning Outcomes	This course provides practical guidance on how to plan and schedule projects using MS Project 2010. On completion of the course delegates will have acquired the skills needed to create a new project; analyse and adjust schedules with date, dependency and resource constraints; customise and print Gantt Chart views and reports; and record and review task progress against the baseline. Participants will also acquire the necessary skills to customise and print high quality charts and reports for effective communication of project plans.
Trainer	PFH Technology Group
Location of Course	PFH Technology Ltd., Eastgate Avenue, Eastgate, Little Island, Co. Cork

Course Web Page:

https://www.corkchamber.ie/biznetcork-skillnet/2013/05/29/Microsoft-Project-2010-2-Day-Introduction--Intermediate

Available to Job Seekers:

Yes

Certified:

No

Find A Course For