MS Excel Advanced 1 & 2

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