Microsoft Products

Excel, Word, PowerPoint etc

Advanced Excel (Part 3)- Automating Excel with Macros and Analysis Tools

€80.00 – €100.00
Dates:

Wednesday 1^st February 2023

Duration:

9.30am to 5pm – 1 day, by webinar

Overview:

This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Objectives:

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

Course Content:
Once you complete Excel 2016 - Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality. This course empowers you to:

Refer to internal and external worksheets

Perform LOOKUPs and audit formulas

Share and protect workbooks

Automate workbook functionality using validation rules and macros

Create sparklines and map data

Forecast data

Prerequisites:
To ensure success, students should have completed Excel Essentials (Part 1) and Excel Functions Including Pivot Tables and Lookups (Part 2) or have the equivalent knowledge and experience.
Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Advanced Excel (Part 3)- Automating Excel with Macros and Analysis Tools (12 Feb 2024)

€80.00 – €100.00
Dates:
Monday 12th February 2024
Duration:

9.30am to 5pm – 1 day, by webinar

Overview:

This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Objectives:

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

Course Content:
Once you complete Excel 2016 - Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality. This course empowers you to:

Refer to internal and external worksheets

Perform LOOKUPs and audit formulas

Share and protect workbooks

Automate workbook functionality using validation rules and macros

Create sparklines and map data

Forecast data

Prerequisites:
To ensure success, students should have completed Excel Essentials (Part 1) and Excel Functions Including Pivot Tables and Lookups (Part 2) or have the equivalent knowledge and experience.
Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Advanced Excel (Part 3)- Automating Excel with Macros and Analysis Tools (13th Nov 2023)

€80.00 – €100.00
Dates:
Monday 13th November 2023
Duration:

9.30am to 5pm – 1 day, by webinar

Overview:

This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Objectives:

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

Course Content:
Once you complete Excel 2016 - Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality. This course empowers you to:

Refer to internal and external worksheets

Perform LOOKUPs and audit formulas

Share and protect workbooks

Automate workbook functionality using validation rules and macros

Create sparklines and map data

Forecast data

Prerequisites:
To ensure success, students should have completed Excel Essentials (Part 1) and Excel Functions Including Pivot Tables and Lookups (Part 2) or have the equivalent knowledge and experience.
Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Design Trends to Attract More Clients to your Hotel (1 March)

€65.00 – €85.00
Hotel Design trends in the 2020s that are magnetic!

Date / Time:
Wednesday, 1 March ( 10 – 1 pm by webinar)
Course Content:

You will have a clear insight into the latest design trends for the 2020s and how to use them in your hotel. Customers are looking for a new experience; you can provide it for them in a unique interesting way that has them coming back for more.

Top Design trends for the 2020s.

Top 5 design hacks, to keep your customers coming back.

have your customers do the advertisement for you. (How to make your hotel Instagram-friendly)

Activate your 5 senses.

Create the illusion of changing a room size with paint and colour.

Expand any room

Raise the ceiling of any room

Make any room cosy

and more

Trainer:
Garry Cohn - Interior and Architectural Design A leading figure in the creative industry, New Yorker Garry’s 30 year career has spanned many disciplines and continents. His style has been described as the “haute couture” of the interior design world and one that exhibits an intelligent use of style, form and function. His natural talent and discerning eye for detail not only helps to distinguish him as an individual, but also differentiates his clients from the competition. His diverse experience and innate intuition bring an informed and unique creative flair to all projects.
Fee:
Members €65 pp Non Members €85 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
How to Create any Mood in your Hotel with Lighting (22 March)

€65.00 – €85.00
Hotel Design trends in the 2020s that are magnetic!

Date / Time:
Wednesday, 22^nd March ( by webinar 10am to 1pm )
Course Content:

You will learn and have the tools to know how to ask and direct people to provide you with the best lighting for your needs. The course is easy to understand and provides you with a simple understanding of how to use lighting in your hotel.

How can I use the lighting I already have to create the best results?

Make small changes with the biggest results, using accent & functional lighting.

Change the atmosphere of any room with lighting, day or night.

When do I use warm or cool lighting?

Are all LED lights the same?

What is CRI? Does it really matter?

Wireless dimmable lighting can I use it with my existing lighting?

What is the best downlighting for my needs

Trainer:
Garry Cohn - Interior & Architectural Design A leading figure in the creative industry, New Yorker Garry’s 30 year career has spanned many disciplines and continents. His style has been described as the “haute couture” of the interior design world and one that exhibits an intelligent use of style, form and function. His natural talent and discerning eye for detail not only helps to distinguish him as an individual, but also differentiates his clients from the competition. His diverse experience and innate intuition bring an informed and unique creative flair to all projects.
Fee:
Members €65 pp Non Members €85 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Masterclass in how to Lead a Prosperous Hotel Kitchen Team (20 Nov)

€150.00 – €195.00

Title: Masterclass in how to Lead a Prosperous Hotel Kitchen Team
New Opportunity for Executive/Head Chefs
Date:
Monday, 20^th November
Venue:
Carton House, Co Kildare
Duration:

10am to 4pm in person

Overview:
Do you want a more highly motivated Kitchen Team who stay longer and contribute more? Do you want to learn more about how you can support your team to work at their collective best? This innovative Masterclass, facilitated by the Global Team Coach expert David Clutterbuck and Una Crilly, Hospitality Leadership Consultant, has been designed for Chef Leaders (Executive/ Head Chefs, who are leading the kitchen team) from the wide network of Hotels in Ireland. At this in-person event, you will learn about the most cutting edge leadership tools and techniques to support Chefs to build a prosperous kitchen workplace, attract and keep the best people, and to build high performing teams. Participants will learn how to have more productive meetings, create psychological safety, and enable your people to really be at their best, grow and innovate. This will be an interactive session with break out activities and Q&A with industry experts. Time to take a break from the kitchen, come to this exciting event, be open to reflect, learn new strategies and have fun!
About the Facilitators:
Prof. David Clutterbuck David Clutterbuck is a global expert on team coaching and mentoring. He has great experience working with businesses across the world to help leaders build high performing teams that thrive in high pressure, dynamic work environments. David has a great sense of humour, loves to create a fun learning environment and has a great love of Irish Hospitality. Don’t miss out on this incredible opportunity to meet a Global Team Coaching expert and build your prosperous kitchen workplace for future generations. Una Crilly, Hospitality Leadership Consultant
Fee:
Members €150 pp Non Members €195 pp
Course Numbers:
Please note: Numbers are limited, with a maximum of one Chef Leader per hotel and maximum of 6 per hotel group.
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information

Select options Details
Out of stock
MS Excel (Level 1)

€80.00 – €100.00
Dates:

Excel Level 1 – Friday 27^th January 2023 (SOLD OUT)

Next course - 17th Feb 2023

Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Details
MS Excel (Level 1) (17 Feb 2023)

€80.00 – €100.00
Dates:
Excel Level 1 – Friday 17^th February 2023
Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
MS Excel (Level 1) (17 Jan 2024)

€80.00 – €100.00
Dates:
Excel Level 1 – Wednesday 17th January 2024
Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Out of stock
MS Excel (Level 1) (19 Oct 2023)

€80.00 – €100.00
Dates:
Excel Level 1 – Thursday 19th October 2023
Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Details
MS Excel (Level 1) (20 Mar 2023)

€80.00 – €100.00
Dates:
Excel Level 1 – Monday 20th March 2023
Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Select options Details
Out of stock
MS Excel (Level 1) (27Sept 2023)

€80.00 – €100.00
Dates:
Excel Level 1 – Weds 27th September 2023
Duration:

9.30am to 4.30pm – 1 day, by webinar

Who should attend:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

This course builds upon the foundational knowledge and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

Course Objectives:

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Content:
Once you complete this course, you’ll be able to create and develop Excel worksheets and workbooks so you can begin to analyze critical business data. This course empowers you to:

Write a range of fundamental Excel commands

Perform worksheet calculations

Build custom formulas

Amend elements in a worksheet

Apply formatting changes to cells

Manage workbook properties

Trainer:
Sharon O’Neill, New Horizons
Fee:
Members €80 pp Non Members €100 pp
Booking:
Book online below. For more information, email Dervla O’Neill at oneilld@ihf.ie or call 086 083 6626 for more information
Details

Microsoft Products

Dates:

Duration:

Overview:

Course Objectives:

Course Content:

Prerequisites:

Trainer:

Fee:

Booking:

Dates:

Duration:

Overview:

Course Objectives:

Course Content:

Prerequisites:

Trainer:

Fee:

Booking:

Dates:

Duration:

Overview:

Course Objectives:

Course Content:

Prerequisites:

Trainer:

Fee:

Booking:

Hotel Design trends in the 2020s that are magnetic!

Date / Time:

Course Content:

Trainer:

Fee:

Booking:

Hotel Design trends in the 2020s that are magnetic!

Date / Time:

Course Content:

Trainer:

Fee:

Booking:

Title: Masterclass in how to Lead a Prosperous Hotel Kitchen Team

Date:

Venue:

Duration:

Overview:

About the Facilitators:

Fee:

Course Numbers:

Booking:

Dates:

Next course - 17th Feb 2023

Duration:

Who should attend:

Course Objectives:

Course Content:

Trainer:

Fee:

Booking:

Dates:

Duration:

Who should attend:

Course Objectives:

Course Content:

Trainer:

Fee:

Booking:

Dates:

Duration:

Who should attend:

Course Objectives:

Course Content:

Trainer:

Fee:

Booking:

Dates:

Duration:

Who should attend:

Course Objectives:

Course Content:

Trainer: