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

With less than one week to go, budding entrepreneurs and ambitious start-ups are being encouraged to take some time out to submit their application for the 2013 Cork innovates bursary.

The Cork innovates bursary will offer a wide range of services from advertising,  financial advice and mentoring to legal services and membership supports. Everything a business and entrepreneur could need to get started and get ahead is included in this year’s bursary.

James Duggan of Funmanway Adventureland recently commented that “Winning the bursary was the single biggest step my business made going forward since its launch,” and similar likeminded entrepreneurs are being encouraged to follow in his footsteps this year to avail of an even greater award.  The bursary is now open for applications on www.corkinnovates.com until 21 October 2013.   The selection process will be a multi-tiered approach with an initial screening of applications, followed by interviews, private pitching sessions and a public pitching session on November 14^th at the second InBusiness InCork Showcase.  Pre-registration for this showcase is now open here

Ireland India Business Association (IIBA), in association with Tyndall National Institute

On Monday 21 October, the Ireland India Business Association (IIBA), in association with Tyndall National Institute, will host a ‘Doing Business with India’ networking event in Tyndall between 18:30 and 20:30. This event will provide a networking opportunity for industries with Indian links or those interested in establishing links with India. The event will also showcase different research activities at Tyndall and how Tyndall/UCC can generate value for industry through research collaboration. To register for this event, please click here.


B2B Networking Event, November 29, Lisbon, Portugal

Vice President of the European Commission, Antonio Tajani, has joined forces with the Portuguese government by organising a B2B networking event which will take place in Lisbon on 29 November. The objective of this conference is to make European companies aware about opportunities in and from Portugal. This mission will comprise of a conference which will focus on making European companies aware of business opportunities in Portugal and there will also be a B2B matchmaking session to allow European enterprises to meet potential Portuguese partners within the Health, Tourism, Automotive, Aeronautical, ICT and Agrifood sectors. For further information about this event, please click here.

Business Partnership Opportunities

• An award-winning German producer of high quality fruit juices is looking for distribution partners in Ireland. The juices are available in apple, plum, quince, elderberry and rhubarb flavours. This family-run business is focused on producing juices in a sustainable and ethical way. For further information about this profile, please contact eimear@corkchamber.ie and quote Ref. BODE20130627001.
• A Swiss specialist in the field of measurement is looking for access to key markets in the area of aviation, aerospace, railway industry, automobile industry, health and medical industry for their measuring products through a trade intermediary. They are also looking for companies that can sell their licence to and for any interested investors. For further information, please contact eimear@corkchamber.ie and quote Ref. 20120625013.

• This new CACSSS Work Placement Module gives employers and recruiting organisations the chance to recruit a valuable source of skilled labour to meet business and project needs and provides a flexible solution to your recruitment needs.

• The Employability Advisor, based at the UCC Career Services, is responsible for the management and development of this new work placement module for the College of Arts, Celtic Studies and Social Sciences in UCC.
• The programme involves Employability & Pre-placement workshops (supporting students in becoming ‘work-ready’) and post-placement follow-up designed to help students to reflect and articulate on their work-based learning and skills developed and how to market these to future employers.

• This 5 Credit Additional Module involves  a minimum of 150 hours of work placement and is academically assessed. Work Experience can be paid or unpaid, or supported by external funding (e.g. Erasmus), and can occur in a variety of relevant campus, local, national or international settings (e.g. academic, commercial, cultural, heritage, statutory, NGO etc.)
• Work-placements can be completed in one of two periods: Across College Term (Weekly) Placement (within months Nov to Sept) or during the summer months (Block) Placement (within months – June to Sept).
• This module offers students the benefit of a period of work experience, which is vetted by the university and employers.
•  The UCC Career Services, participating companies and academic staff work with students to ensure that they are developing work-place relevant skills related to their degrees.
•  Successful completion of this placement module is listed on students’ transcripts.
  

More details available here.

See Christmas Brochure here.

Find out whether your business might be suited to expansion - using Franchise, Licence or Distributor Models

The National Franchise Centre (NFC) in partnership with Cork innovates has recently announced that it will deliver its hugely successful programme Franchise START in Cork this November.

The programme is 5 days in duration and caters to those who wish to assess the feasibility of business expansion using various models. Often, the cost and time involved in scaling ones venture depends on the complexity of the business, the proposed system and the current position. Franchise START helps participants to evaluate their current situation and what planning is required in areas such as intellectual property, the market, systems, profitability etc.  The merits of Franchise START lie in its practical and utilitarian approach to expansion models and no doubt it will prove itself to a new Cork audience.

Siobhan Finn of Cork Innovates commented that “We identified a need for support for businesses wishing to grow and scale using the franchise model in Cork. We successfully engaged with the National Franchise Centre and are delighted to now support the launch of its Franchise START programme here in Cork.  This is another new offering for local entrepreneurs and the business community and Cork innovates is very pleased to have instigated this for the region”

Martina McGrath, National Franchise Centre Manager advised "this programme offers a true insight into the investment required in order to scale ones business. For some franchising, licencing and distributorships offer an excellent platform for expansion; however, gaining a knowledge base to enter into this sphere can be an uphill and costly exercise. We look forward to facilitating such businesses over the coming months- assisting in their growth journey”.

To register your interest for Franchise START (due to be delivered from 4^th November on a part time basis) or for further information please logo onto www.nationalfranchisecentre.ie or email: nfc@lit.ie