Dublin: 01 9609300
Navan: 046 9012407
Mobile: 087 2048661

Microsoft Excel Training - Level 2 Intermediate

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.

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

Duration & Locations

8am - 5pm

Online Course


Microsoft Excel Level 2 FAQS

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.

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.

Book Your Course Today!


Meath Kells Road Navan,
Co Meath. C15 FX6Y 


© 2024 National Training Centre. All Rights Reserved.