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.

Join our Excel courses with our experienced instructors who replicate the classroom experience, live online so you can attend from wherever suits you.

Microsoft learning partner

Excel Essential and Formulas

This course is intended for those who wish to gain the foundational 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.

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

What’s included

  • Live instruction with certified trainer
  • 6 month access to class recording
  • Training insurance included
  • Contributes to CPD hours

Prerequisites

  • None. Beginner course
Microsoft Excel logo

  • 4.6/5
  • 1 day course
  • Popular Course
  • Beginner Course
  • Irish class times
  • Attend from anywhere
  • Live online

11 Jun 24

09:30 - 17:00

04 Jul 24

09:30 - 17:00

14 Aug 24

09:30 - 17:00

17 Sep 24

09:30 - 17:00

03 Oct 24

09:30 - 17:00

07 Nov 24

09:30 - 17:00

05 Dec 24

09:30 - 17:00

Private Excel - Excel Essentials and Formulas

Schedule a Live Online or Face to Face course when and where you want it, click Enquire now for more details.

Duration

1 Days

6 CPD hours

This course is intended for

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.

Overview

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

Description

This course is intended for those who wish to gain the foundational 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.

Getting Started with Excel
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter and Edit Cell Data
  • Fill Cells with Series of Data (AutoFill and Flash Fill)
  • Use Excel Help
Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions and use Autocomplete
  • Reuse Formulas and Functions
  • Create an Absolute Reference
Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Move and Copy Data between Cells
  • Search for and Replace Data
  • Use Spellcheck and Proofing
Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply and Copy Cell Styles
  • Apply Basic Conditional Formatting
Printing Workbooks
  • Preview and Print a Workbook
  • Controlling Page Layout
  • Adding Headers and Footers
  • Set Print Titles and Print Ranges
Managing Workbooks
  • Manage Worksheets
  • Insert and Delete Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

 

Excel Functions Including Pivot Tables

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

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.

What’s included

  • Live instruction with certified trainer
  • 6 month access to class recording
  • Training insurance included
  • Contributes to CPD hours

Prerequisites

Microsoft Excel logo

  • 4.6/5
  • 1 day course
  • Popular Course
  • Advanced Course
  • Irish class times
  • Attend from anywhere
  • Live online

Private Excel - Excel Functions Including Pivot Tables and Lookups

Schedule a Live Online or Face to Face course when and where you want it, click Enquire now for more details.

Duration

1 Days

6 CPD hours

About this course

To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.

Overview

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.

Description

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

Working with Functions and Complex Calculations
  • Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)
  • Work with Logical Functions
  • Work with Lookup Functions
  • Work with Date and Time Functions
  • Work with Text Functions
Working with Lists and Tables
  • Sort and Filter Data
  • Remove Duplicate Values
  • Group and Outline Data
  • Subtotal Data
Visualizing Data with Charts
  • Create and Modify Charts
  • Use Advanced Chart Features
  • Save a Custom Chart Template
Using Tables, Pivot Table Reports and Pivot Charts
  • Create and Modify Tables
  • Use Functions to Calculate in Tables
  • Create a Pivot Table Report
  • Manipulate Pivot Tables
  • Present Data with Pivot Charts
  • Filter Data by Using Slicers and Timelines

 

Automating Excel with Macros and Analysis Tools

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.

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.

What’s included

  • Live instruction with certified trainer
  • 6 month access to class recording
  • Training insurance included
  • Contributes to CPD hours

Prerequisites

Microsoft Excel logo

  • 4.6/5
  • 1 day course
  • Popular Course
  • Advanced Course
  • Irish class times
  • Attend from anywhere
  • Live online

Private Excel - Automating Excel with Macros and Analysis Tools

Schedule a Live Online or Face to Face course when and where you want it, click Enquire now for more details.

Duration

1 Days

6 CPD hours

Overview

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.

Description

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.

Topics

Working with Multiple Worksheets and Workbooks

  • Working with Named Ranges
  • Link Cells Across Worksheets and Workbooks
  • Use 3D References to Calculate Across Worksheets
  • Consolidate Data
Use Formula Auditing and Error Checking
  • Reveal Formulas
  • Trace Cell Precedents and Dependents
  • Locate Errors in Formulas
  • Watch and Evaluate Formulas
Reviewing and Protecting Workbooks
  • Control Data Entry via Data Validation
  • Protect Workbook Access
  • Protect Worksheets and Cell Content
  • Add and Edit Comments
  • Prepare a Workbook for Distribution
  • Modify Excel's Default Settings
Using Macros to Automate Workbook Functionality
  • Create Macros via Recording
  • Run Macros via Buttons and Shortcuts
  • Assign Macros to the Quick Access Toolbar and Ribbon
  • Assign Macros to Objects
  • View Macro Code
Forecasting and Analysis Data
  • Use Conditional Formatting to Highlight, Sort and Filter Key Data
  • Advanced Conditional Formatting using Formulas
  • Create Sparklines to Visualise Data
  • Add Trendlines to Charts to Visualise and Forecast Trends
  • Use Data Tables and Scenarios to Project Potential Outcomes
  • Use Goal Seek to Calculate Outcomes
  • Forecast Data Trends Using Solver

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 optimise its performance.

What’s included

  • Live instruction with certified trainer
  • 6 month access to class recording
  • Training insurance included
  • Contributes to CPD hours

Prerequisites

  • It is recommended you have significant experience using Excel
Microsoft Excel logo

  • 4.6/5
  • 1 day course
  • Popular Course
  • Advanced Course
  • Attend from anywhere
  • Live online

Private VBA with Microsoft Excel

Schedule a Live Online or Face to Face course when and where you want it, click Enquire now for more details.

Duration

1 Days

6 CPD hours

About this course

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

Overview

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.

Description

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.

Prerequisites

To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel courses, Parts 1, 2, and 3.

Topics

1. Using VBA to Solve Business Problems

  • Use Macros to Automate Tasks in Excel
  • Identify Components of Macro-Enabled Workbooks
  • Configure the Excel VBA Environment

2. Recording a Macro

  • Use the Macro Recorder to Create a VBA Macro
  • Record a Macro with Relative Addressing
  • Delete Macros and Modules
  • Identify Strategies for Using the Macro Recorder

3. Writing VBA Code Directly

  • Write VBA Code
  • Discover Objects You Can Use
  • Create a Custom Function

4. Solving Problems through Code

  • Make Decisions in Code
  • Work with Variables
  • Perform Repetitive Tasks

5. Improving Your VBA Code

  • Debug VBA Errors
  • Deal with Errors
  • Improve Macro Performance

6. Controlling How and When Macros Run

  • Prompt the User for Information
  • Configure Macros to Run Automatically

 

Top

free resit on Nexus Human courses

Award Winning Trainers

Interact with our experienced and certified trainers during our live online classes.

Training insurance with free resit on Nexus Human courses

Free Resit Included

If the situation arises where training delegates fall ill or become unavailable, no need to worry, they can resit the course for free. Our Training Insurance covers you to sit the same public class within 6 months, if the case arises.

6 Month Access To Recording

Classes are recorded so that you don't miss a thing. You can go over the class again in order to enforce learning for up to 6 months after the training course has ended.

Very useful and well-presented course. Sharon adapted well to tailoring content to our specific requirements / questions.

Irish Independent

Nexus Human class

John lives in an excel orientated world and is well on his way to world domination! He's an excel Master and shows great enthusiasm and patience in all aspects of his job, highly recommended for future sessions.

Barbara

Nexus Human Excel class

The patience that Sharon had with everyone was excellent. The pace was also perfect. I would highly recommend this course to my colleagues.

Nexus Human Excel class

Sharon was very approachable and explained things very well

JC Decaux

Nexus Human Excel class