Free Excel Skills Assessment

Very short questionnaire to establish your skill level with Microsoft Excel.

Excel Assessment

Irish-buiness-badge

Excel Training Courses

Whether you're brand new to Excel or seeking advanced knowledge, we've got it covered. We have a wide range of Excel levels and class types. We have Dublin classroom training, live online Excel training and classic Excel e-learning options too.

*Please note that all dates below are now run live online.

Excel Cheat Sheets

Excel courses for beginners

Excel Essential and Formulas

This course is intended for those who wish to gain a foundation and understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.


1 day course 9:30-17:00
or 14:00-22:00
This course is run live online Can be run in our Dublin classrooms or at your premises

Upcoming dates: Live online 9:30-17:00


Course Starts Location Price
Excel - Excel Essentials and Formulas 05-07-2022 Dublin, Ireland
Excel - Excel Essentials and Formulas 02-08-2022 Dublin, Ireland
Excel - Excel Essentials and Formulas 06-09-2022 Dublin, Ireland

Upcoming dates: Live online 14:00-22:00


Course Starts Location Price
Excel 2016 - Part 1 31-05-2022 Dublin, Ireland
Excel 2016 - Part 1 06-06-2022 Dublin, Ireland
Excel 2016 - Part 1 21-06-2022 Dublin, Ireland

Excel courses for Advanced users:

Excel Functions Including Pivot Tables and Lookups

Designed for students who already have foundation 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.


1 day course 9:30-17:00
or 14:00-22:00
This course is run live online Can be run in our Dublin classrooms or at your premises

Upcoming dates: Live online 9:30-17:00

Upcoming dates: Live online 14:00-22:00


Course Starts Location Price
Excel 2016 - Part 2 01-06-2022 Dublin, Ireland
Excel 2016 - Part 2 07-06-2022 Dublin, Ireland
Excel 2016 - Part 2 22-06-2022 Dublin, Ireland

Automating Excel with Macros and Analysis Tools

This course is for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.


1 day course 9:30-17:00
or 14:00-22:00
This course is run live online Can be run in our Dublin classrooms or at your premises

Upcoming dates: Live online 9:30-17:00


Course Starts Location Price
Excel - Automating Excel with Macros and Analysis Tools 30-06-2022 Dublin, Ireland
Excel - Automating Excel with Macros and Analysis Tools 28-07-2022 Dublin, Ireland
Excel - Automating Excel with Macros and Analysis Tools 31-08-2022 Dublin, Ireland

Upcoming dates: Live online 14:00-22:00


Course Starts Location Price
Excel 2016 - Part 3 03-06-2022 Dublin, Ireland
Excel 2016 - Part 3 17-06-2022 Dublin, Ireland
Excel 2016 - Part 3 01-07-2022 Dublin, Ireland

Excel Courses for Professionals

VBA with Microsoft® Excel®

In this course, you will develop and deploy VBA modules to solve business problems. You will:

  • Identify general components of VBA and their appropriate use in solving business solutions.
  • Record VBA macros to automate repetitive tasks.
  • Write VBA code to create VBA subroutines and functions.
  • Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops.
  • Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

  • 1 day course Normally 14:00-22:00 Live Online Can be run in person. Contact us for details.
    
    Course Starts Location Price
    VBA with Microsoft Excel (v1.1) 08-08-2022 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 28-09-2022 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 08-11-2022 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 13-12-2022 Dublin, Ireland

    Programming and Data Wrangling with VBA and Excel

    In this course, you will develop and deploy VBA modules to solve business problems. You will:

    • Identify general components of VBA and their appropriate use in solving business solutions.
    • Record VBA macros to automate repetitive tasks.
    • Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
    • Write VBA code to create a custom worksheet function.
    • Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
    • Control how and when macros run.
    • Develop UserForm objects to create custom dialog boxes and windows.
    • Use VBA to read and write data from local files and cloud services.
    • Use VBA to clean and transform data.
    • Run programs and commands outside of Excel and share VBA projects with other users.

    3 day course Normally 14:00-22:00 Live online Can be run in person.
    Contact us
    for details.

    Excel for Office 365 - Data Analysis with PivotTables

    In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.

    You will:

    • Prepare data for PivotTable reporting and create PivotTables from various data sources.
    • Analyze data by using PivotTables.
    • Work with PivotCharts.

    Half day course Normally runs 14:00-22:00 Live online Can be run in person.
    Contact us
    for details.

    Data Analysis and Visualization with Microsoft Excel

    In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

    • Perform data analysis fundamentals.
    • Visualize data with Excel.
    • Analyze data with formulas and functions.
    • Analyze data with PivotTables.
    • Present visual insights with dashboards in Excel.
    • Create geospatial visualization with Excel.
    • Perform statistical analysis.
    • Get and transform data.
    • Model and analyze data with Power Pivot.
    • Present insights with reports.

    2 day course Normally runs 14:00-22:00 Live online Can be run in person.
    Contact us
    for details.
    
    Course Starts Location Price
    Data Analysis and Visualization with Microsoft Excel 06-06-2022 Dublin, Ireland
    Data Analysis and Visualization with Microsoft Excel 06-09-2022 Dublin, Ireland
    Data Analysis and Visualization with Microsoft Excel 01-12-2022 Dublin, Ireland

    Excel Cheat Sheets

    Please click the image to download a PDF of the cheat sheet.

    Excel cheat sheets

    Please click the image below to download your cheat sheet.

    Excel quick tips cheat sheet Cheat-sheet-PREVIEW-Excel2018 Excel Formula Keyboard shortcut cheat sheet Excel Vlookup keyboard shortcut cheat sheet

    Microsoft Office Certification

    Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)

    Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program.

    Required Exam

    • MO-200

    Preparation Courses:

    All Excel Courses

    {{value[0].Version}}

    Contact Us Today

    22-24 Strand Street Great
    Strand House
    Dublin 1
    D01 W1W4
     +353 1 8898 700
     Email New Horizons Ireland

    Adobe and Office Instructor Sharon

    Safeguarding and analysing data using Excel and Power BI