Who is this course for?

This workshop is designed for individuals who are already familiar with Excel basics and wish to enhance their skills for advanced data handling and analysis.

What specific skills will I learn in the Excel Advanced Workshop?

Participants will learn advanced formulas, data analysis tools, pivot tables, macros, and techniques for automating tasks within Excel.

Is there a prerequisite for this course?

Yes, participants should have a foundational understanding of Excel to ensure they can fully benefit from the advanced topics covered.

How is the course structured?

The course comprises interactive lessons, hands-on exercises, and real-world examples to reinforce the advanced concepts taught.

Will I receive any certification after completion?

Yes, you will receive a Livius Training Internal Certificate upon successfully completing the workshop.

What industries would benefit from this training?

Industries such as finance, project management, and data analysis would greatly benefit from the advanced Excel skills acquired in this course.

Can this training be tailored for specific business needs?

Absolutely, we can modify the workshop content to focus on specific areas of Excel that are most relevant to your organization's needs.

£295

per person

advanced

Livius Training Internal Certificate

Excel Advanced

1 day1–12 participantsCertificate included

Also available as a virtual course

Course Overview

Virtual Classroom Content

Master Excel from Anywhere in the UKTake your spreadsheet skills to the next level with our Excel Advanced Workshop, a comprehensive one-day course designed to transform how you manage, analyse, and present data. This live, instructor-led session is delivered via virtual classroom, meaning you can j...

What You'll Learn

Utilize logical functions including nested IF statements and AND/OR logic.

Execute advanced lookup functions such as XLOOKUP and INDEX/MATCH to retrieve data.

Create and customise Pivot Tables and Pivot Charts for dynamic data analysis.

Implement data validation rules and worksheet protection to maintain data integrity.

Record and manage basic Macros to automate frequent manual tasks.

Apply advanced conditional formatting to identify patterns and anomalies in datasets.

Participate in live interactive virtual exercises using screen-sharing and remote control features.

Collaborate with fellow learners in online breakout rooms to solve complex data scenarios.

Student Reviews

Why students choose us

Training that's worth every minute — and every penny

Certified & Accredited

Highfield, NUCO and IOSH options, depending on course

Small Group Sizes

Max 12 per class — real attention, real learning

Friendly Instructors

Experts who make training enjoyable

17+ Years Experience

Trusted by 20,000+ Yorkshire professionals

See what our customers say

Be the first to share your experience

Questions & Answers

No questions yet — be the first to ask!

Need Group Training?

We offer on-site training for groups of 6 or more. Contact us for special pricing and customised programmes.

Upcoming Dates

1 available

Fri

Oct

09:30 – 16:30

Virtual Classroom6 spaces

£295.00

per person

ex VAT

Select Date

Virtual Classroom

Number of Participants

Maximum 6 places available

Subtotal (ex VAT):£295.00

VAT (20%):£59.00

Total inc. VAT:£354.00

Official certification included

Course materials provided

Refreshments included

Free cancellation up to 14 days before

Questions? Call 01423 396780 Training 6+ staff? Get a group quote →

Free Download

Workplace First Aid Requirements Checklist

No spam. Unsubscribe anytime.

Not ready to book yet?

Get notified when new dates are added

New date alerts No spam

Excel Advanced

Course Overview

What You'll Learn

Student Reviews

Training that's worth every minute — and every penny

Questions & Answers

Need Group Training?

Upcoming Dates

You May Also Like

Excel Beginners Workshop

Excel Intermediate Workshop

Related Articles

Weekly Compliance Update: HSE Intensifies Crackdown on Engineered Stone Dust

Prioritizing People: Why Health and Safety is the Heart of Your Business

Weekly Compliance Update: Lessons from the ExxonMobil Prosecution

Stay Updated