Excel Intermediate

  1. Home
  2. Events
  3. Excel Intermediate

We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes subject to funding being available

Please click on the following link to check if you meet Jobseekers eligibility criteria;



DATES: Wednesday 21st September 2016

TIME: 9am – 5pm

COST: €€100 pp

LOCATION: New Horizons 22 – 24 Strand Street Great,  Dublin 1,


In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.


Lesson 1: Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink


Lesson 2: Creating and Modifying Charts
Create a Chart
Format Chart Items (2007 styles)
Change the Chart Type
Save a Custom Chart Template
Create a Trendline
Export a Chart to Word and or PowerPoint
SmartArt (2007 Only)


Lesson 3: Calculating with Advanced Formulas
Create and Apply a Named Range
Calculate Between Worksheets and Workbooks
Date and Time Functions
Text Functions
Database Functions
Statistical Functions
Lookup and Reference Functions
Logical Functions


Lesson 4: Manage Data Lists
Create a Data List
Sort Data Lists
Create and Apply Auto and Advanced Filters
Add Subtotals to a Data List
Group and Outline Data Lists
Next Steps
Excel – Level 3


This course is designed for delegates who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data. In addition, this course helps prepare students for the Microsoft Certified Applications Specialist exam in Excel.

At Course Completion:
You will have gained the skills necessary to apply advanced formulas to a worksheet, to manage and display data in various formats, including visual elements.



New Horizons Ireland 

Address: 22 – 24 Strand Street Great,  Dublin 1, Ireland

Web:       http://www.newhorizonsireland.ie