Excel Advanced

Key Course Points

Course Code: SSA5039 Course Data Sheet
View PDF
 Course Duration 1 days Start & End Time 9:30 am- 5:00 pm

Upcoming Dates

Start Date Format Price (€) Price (£)
21/10/2026 Virtual / Classroom €325.00 £295.00 Enrol Now
25/11/2026 Virtual / Classroom €325.00 £295.00 Enrol Now
09/12/2026 Virtual / Classroom €325.00 £295.00 Enrol Now
21/01/2027 Virtual / Classroom €325.00 £295.00 Enrol Now
I would like to discuss custom dates and or private delivery. 
Enquire Now

Course Information

This course is intended to help all users get up to speed on the different aspects of Excel, including some of its more advanced features. We will cover how to automate worksheet functionality using Macros, audit worksheets, analyze data using PivotTables and work with multiple workbooks.

By the end of this course, users should be comfortable with automating worksheet functionality, auditing worksheets, using a variety of different analysis tools and working effectively with multiple workbooks.

Lesson 1: Automating Worksheet Functionality

  • Manage Workbook Properties
  • Record and Run a Macro
  • Create and Use a Template
  • Add Data Validation in a Workbook

Lesson 2: Auditing Worksheets

  • Trace Cells
  • Error Checking
  • Evaluate Formulas and Use the Watch Window
  • Data List Outline

Lesson 3: Data Analysis and Presentation

  • Quick Analysis Tool
  • Add Sparklines
  • What-If Analysis

Lesson 4: Analysing Data with PivotTables, Slicers and PivotCharts

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyse Data with PivotCharts

Lesson 5: Working with Multiple Worksheets and Workbooks

  • Link to Data in Multiple Workbooks
  • Consolidate Data

Lesson 6: Exporting and Sourcing Data

  • Export Data
  • Use Data Sources

Lesson 7: Analysing Data with Logical and Lookup Functions

  • Use Logical Functions
  • Use Lookup Functions

This Advanced course assumes the user has completed or has an understanding of the topics covered in the Microsoft Office Excel Introduction and Intermediate courses, including:

·       Creating advanced formulas

·       Organizing worksheet data with tables

·       Visualizing data with charts

Contact Us

Whether you are thinking of doing any of our courses you can book it here now. Alternatively, if you need advice or would like to discuss a business discount account - email: info@sureskills.com or call: 01 240 22 62 (Irl)/ 028 9093 5565 (UK).

Latest Downloads

Discover our wide range of courses to help you achieve maximum results.

View Full Brochure Range