MS Excel Advanced 1 & 2

Start date: 20/10/2026

Duration: 10am - 1pm - 20&21 Oct and 17 & 18th of Feb 2026

Location: Online

Cost: Skillnet Members €230, Non Members €295

Book Now

Programme overview

MS Excel Advanced 1 & 2 – Advanced Excel Training for Professionals

Improve your Excel skills with our MS Excel Advanced 1 & 2 training course designed for experienced users who need to build and manage complex spreadsheets, automate tasks, and analyze data more efficiently. This course is ideal for construction professionals who regularly work with data models, reports, or large datasets and want to maximise Excel’s advanced features.

Whether you’re in construction, finance, engineering, or administration, this advanced Excel course gives you the tools to work smarter, not harder. By the end of the training, you’ll have the confidence and skills to use Excel for advanced data analysis, model building, and task automation.

Course Prerequisites:
Participants should have solid Excel experience and be comfortable with functions, formulas, formatting, and data management. Completion of an intermediate-level Excel course is highly recommended.

What You’ll Learn in MS Excel Advanced 1 & 2:

  • Use advanced Lookup and Information Functions such as INDEX, MATCH, and nested formulas for dynamic data retrieval.

  • Summarise and analyse large datasets with Pivot Tables and Pivot Charts.

  • Apply advanced filtering and custom sorting techniques for deeper data insights.

  • Use formula auditing tools and formula view to troubleshoot and refine complex calculations.

  • Learn how to protect and share workbooks, control access, and manage versioning.

  • Work efficiently with Excel Tables to organise and reference structured data.

  • Create advanced charts to visualise trends and performance metrics.

  • Get an introduction to Macros to start automating repetitive tasks.

Boost your productivity and unlock Excel’s full potential with our MS Excel Advanced 1 & 2 course, perfect for construction professionals ready to harness advanced Excel features for real-world results.

Learn more about your trainer: Marta Maslowska

For more information or to book contact Laura at 087 3688491 or cpskillnet@cif.ie

To register, please complete the short form below. If you are registering on behalf of someone else, please contact cpskillnet@cif.ie.
The information collected here is used by Skillnet Ireland and the Construction Professionals Skillnet (the “Learning Network”) in relation to training programmes partially or fully-funded by Skillnet Ireland from the National Training Fund through the Department of Further and Higher Education, Research, Innovation and Science (DFHERIS).

Read more about Privacy and Data Protection

Skillnet Ireland is mandated by the DFHERIS to monitor and evaluate training programmes and to ensure that funds are being used appropriately. Skillnet Ireland and the Learning Network will comply with all applicable Data Protection Legislation in the processing of the information and personal data provided by you in this Form. | | WHAT WE USE YOUR PERSONAL DATA FOR | We use your personal data for the following purposes: 1. Delivering Skillnet Ireland training programmes via the Learning Network. 2. Monitoring the training programmes of the Learning Network. Skillnet Ireland is required by the DES to perform compliance reviews, evaluations of the training programmes, quality assurance and to verify attendance at training. You may be contacted either by telephone or email for these purposes. 3. For the purposes of providing aggregated statistical information to the DES to help inform national policy in relation to skills.  || You may be contacted by third parties, contracted by Skillnet Ireland to perform monitoring and evaluation activities for these specific purposes only. Skillnet Ireland relies on the legal basis of necessary legitimate interests to process your personal data. Further information on this can be found in the Skillnet Ireland Trainee Privacy Statement here.
Book Now

Register Now

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*
Would you like to receive email updates from Construction Professionals Skillnet about future courses?

Selected Course:

   MS Excel Advanced 1 & 2

View by Category

Sign up to our Network Newsletter

Share This