Office-resources-banner

Free Webinar:

What’s New in Excel for Microsoft 365?

In the age of Microsoft 365, the Excel of today is very different from the Excel of yesteryear. With Microsoft releasing brand new features every few months, 365 users get to live a life of perpetual discovery, a life full of potential surprises that can be easily missed with a busy schedule. Over the course of this session, Eric will showcase some of the newest, niftiest, time-saving features to hit Excel 365 of which you may never have heard to help you start leveraging Excel to the fullest.


25th August
5pm

Register Now

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 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 06-08-2021 Dublin, Ireland
Excel - Excel Essentials and Formulas 06-08-2021 Dublin, Ireland
Excel - Excel Essentials and Formulas 01-09-2021 Dublin, Ireland

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


Course Starts Location Price
Excel 2016 - Part 1 02-08-2021 Dublin, Ireland
Excel 2016 - Part 1 09-08-2021 Dublin, Ireland
Excel 2016 - Part 1 23-08-2021 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 10-08-2021 Dublin, Ireland
Excel 2016 - Part 2 17-08-2021 Dublin, Ireland
Excel 2016 - Part 2 24-08-2021 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-08-2021 Dublin, Ireland
Excel - Automating Excel with Macros and Analysis Tools 29-09-2021 Dublin, Ireland
Excel - Automating Excel with Macros and Analysis Tools 20-10-2021 Dublin, Ireland

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


Course Starts Location Price
Excel 2016 - Part 3 13-08-2021 Dublin, Ireland
Excel 2016 - Part 3 26-08-2021 Dublin, Ireland
Excel 2016 - Part 3 08-09-2021 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) 30-08-2021 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 29-11-2021 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 07-02-2022 Dublin, Ireland
    VBA with Microsoft Excel (v1.1) 04-05-2022 Dublin, Ireland

    Excel: Data Analysis with Pivot Tables

    Being able to harness the power of PivotTable features & create Pivot Charts will help students gain an edge. Not only will students be able to summarise data to analyse, but they can organise the data in a way that can be meaningfully presented to others.


    1 day course 14:00 - 22:00 This course is run live online Can be run in our Dublin classrooms or at your premises
    
    Course Starts Location Price
    Excel 2016/2019 - Data Analysis with PivotTables 13-08-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with PivotTables 15-09-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with PivotTables 15-10-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with PivotTables 12-11-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with PivotTables 10-12-2021 Dublin, Ireland

    Excel: Data Analysis with Power Pivot

    Excel provides Power Pivot to help students organise, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot to maximise their effectiveness when analysing data.


    1 day course 14:00-22:00 This course is run live online Can be run in our Dublin classrooms or at your premises
    
    Course Starts Location Price
    Excel 2016/2019 - Data Analysis with Power Pivot 06-08-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with Power Pivot 24-09-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with Power Pivot 29-10-2021 Dublin, Ireland
    Excel 2016/2019 - Data Analysis with Power Pivot 03-12-2021 Dublin, Ireland

    Analyzing Data with Excel

    After completing this course, students will be able to:

    • Explore and extend a classic Excel dashboard.
    • Explore and extend an Excel data model.
    • Pre-format and import a .CSV file.
    • Import data from a SQL Server database
    • Import data from a report.
    • Create measures using advanced DAX functions.
    • Create data visualizations in Excel.
    • Create a Power BI dashboard with Excel.

    3 day course Normally runs 14:00 to 22:00 Live Online Can be run in person.
    Contact us
    for details.
    
    Course Starts Location Price
    20779 Analyzing Data with Excel 18-08-2021 Dublin, Ireland
    20779 Analyzing Data with Excel 23-08-2021 Dublin, Ireland
    20779 Analyzing Data with Excel 08-09-2021 Dublin, Ireland
    20779 Analyzing Data with Excel 27-09-2021 Dublin, Ireland

    Excel-Free-resources

    Free Excel skills assessment

    Not sure which level is the best for you?

    Looking to find out what level of Excel you need to enrol in, or simply looking to find out your level of expertise in Office? Well click the link below and take the test no, completely obligation free.

    Free Microsoft Excel Skills Assessment

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

    Excel Assessment

    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}}

    Office-free-resources-animation636771207237624044

    Contact Us Today

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