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.