Microsoft Excel Training - Beginner, Intermediate, Advanced

Microsoft Excel Training

Microsoft Excel is the industry leading spreadsheet program which enables information to be stored, organised and manipulated with powerful data visualisation and analysis tools.

We have a wide range of excel courses for all levels; Beginner, Intermediate or Advanced.

Click Here for Course Schedule

Microsoft Excel Beginner Course

This course is intended for new users and covers the following:

  • Creating a Spreadsheet Files
  • Excel Environment
  • Navigating within a Worksheet
  • Navigating the Workbook
  • Working with Cells
  • Selecting items in Excel
  • Entering Data
  • Formatting Text
  • Formatting Numbers and values
  • Formatting Columns and Rows
  • Adding and Editing Borders
  • Cutting, Copying and Pasting
  • Inserting and Deleting
  • Using Find and Replace
  • Using Undo and Redo
  • Entering Basic Formula and Functions
  • Auto filling Rules
  • Using Page Setup
  • Sorting Data
  • Headers and Footers
  • Printing a Spreadsheet

Microsoft Excel Intermediate Course

This course is intended for those who have experience of Excel or have previously completed the beginners course. The course covers the following:

  • Worksheet management – comparing/moving/copying
  • Conditional Formatting
  • Linking excel data
  • Paste Specials
  • Freezing/Hiding Rows/Columns
  • Absolute Cell Referencing
  • Working with  Formulas (SumIF, CountIF, CountA)
  • Working with Date and Time Functions
  • Sorting Data
  • Filters & Advanced Filters
  • Creating sub-totals
  • IF and nested IF Functions
  • V Lookups & H Lookups
  • Creating and formatting Charts
  • Pivot Tables

Microsoft Excel Advanced Course

This course is intended for those who have a good level of Excel and want to develop their skills further in the following areas:

  • Creating Tables in Excel
  • Advanced formulas and functions
    • Database Functions
    • Text Functions
    • Lookup, Index and Match
    • Array Formula 
  • Advanced List management
  • Importing & Exporting Data
  • What If Analysis
    • Scenarios,
    • Data Tables,
    • Goal Seek
  • Spreadsheet Security
  • Working with Macros
    • Creating a Macro
    • Inserting a Macro
    • Assigning a macro to a button
  • Forms and Form controls in Excel

Training Methods:

Classroom Based Train the Trainer Course

Classroom based presentation on power-point with practical exercises.

Virtual/Online Train the Trainer Course

This Online Course is done as Virtual Training - live with our experienced trainer. The trainer allows space for discussion, questions and lots of interaction to ensure you get the best quality training experience.

Group Train the Trainer Course

For companies and organizations with multiple people to be trained, we offer group rates for in-company training nationwide - this can also be done at your premises or at a venue local to you if preferred.

Course Duration:

1 day course from 9:30am – 4:30pm

Price:

  • €195 per person*

*Discounts available for group booking

Click Here for Course Schedule

FAQ - Microsoft Excel Course

How can I learn Excel quickly?

Taking a 1-day course at NTS will dramatically improve your Excel skills. With courses to suit anyone from Beginner to Intermediate to Advanced level, you are sure to gain more understanding and boost your knowledge in this powerful tool.

Is Excel training worth it?

Excel is the most widely used and recognizable spreadsheet tool in the world. Used by all business sizes and across all industries, proficiency in Excel will boost your employment prospects and career path. Not only that, it will help massively in your day-to-day work.

How long does an Excel course take?

Our Excel courses run for 1 day each and there is a starting point for everyone, regardless of their current Excel skills.