About This Course

Take your Google Sheets skills to the next level! This advanced course will show you how to master complex formulas, analyse data like a pro, and create dynamic Pivot Tables and charts. You’ll learn powerful functions and data tools that make managing large datasets easier, faster, and more accurate. By the end, you’ll be able to turn raw data into clear, actionable insights that drive smarter business decisions.

Prerequisites: Delegates should have completed Google Sheets Introduction and Intermediate training, or have equivalent practical experience. They should be confident using formulas, formatting data, working across multiple sheets, creating charts and managing structured spreadsheet data.

Course Outline

During this course, participants will develop advanced Google Sheets skills to analyse data, create reports, and generate meaningful business insights.

  • Expanding Your Functions Toolbox – Use advanced formulas including nested IFs, AND/OR logic, IFERROR, and named ranges.
  • Lookup Functions – Apply VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve and cross-reference data efficiently.
  • Data Validation – Control data input with rules and restrictions to ensure consistency and reduce errors.
  • Querying Your Data – Extract and analyse data using the powerful QUERY function.
  • Pivot Tables Basics – Summarise and analyse large datasets quickly using Pivot Tables.
  • Customising Pivot Tables – Modify layouts, group data, and improve reporting clarity.
  • Pivot Charts – Create dynamic charts that update automatically with your data.
  • Filtering and Slicing – Use filters and slicers to explore subsets of data and identify trends.

Who should attend

This course is ideal for users with basic Google Sheets knowledge who want to advance their data analysis and reporting skills. It is particularly valuable for professionals working with large datasets, reporting, or decision-making who want to improve efficiency and insight generation.

Would Your Team Benefit From Google Sheets Training?

Find out how we can empower your employees to harness the full potential of their potential.

Contact Us

Learning Outcomes

  • Master advanced formulas and functions for accurate and efficient calculations.
  • Use lookup functions effectively to retrieve and analyse data across spreadsheets.
  • Extract and analyse data confidently to support decision-making.
  • Create and customise Pivot Tables and charts to visualise insights.
  • Apply data validation, filters, and slicers to maintain accuracy and explore data dynamically.

Course Reviews

Excel Intermediate

Course was one of the best I have ever attended in professional development and will make me more efficient

Anon
Asmodee UK
June 15, 2026

Excel Intermediate

I was amazed by Tony's knowledge and his ability to convey things concisely and clearly. I really enjoyed the course and am confident in my ability to apply some of the knowledge to my day to day work which is what I wanted to get out of it.

Anon
Crown Agents Bank
June 11, 2026

Excel Introduction

Excel - Gary help me loads with a spreadsheet I had! I’ll book onto the intermediate

Anon
Wessex Water
June 2, 2026

Excel

Gary made the information very attainable, it was good we could do the work alongside him.

Anon
Welwyn Hatfield Borough Council
June 2, 2026

Excel Advanced

Tony Barrett is highly knowledgeable in Excel and was able to explain each concept in a way that made it easy for me to understand how to apply it directly to my role.

Anon
CWG
June 16, 2026

PowerPoint

Great course, Louise, great to learn small everyday skills to help speed up

Anon
Stellantis
June 16, 2026

Related Courses

Corporate IT

Google Sheets Introduction

This one-day Google Sheets introduction course helps beginners organise data, use formulas, and create professional spreadsheets and charts.

Corporate IT

Google Sheets Intermediate

This one-day Google Sheets intermediate course helps professionals build efficient spreadsheets, use formulas, and analyse data for better decision-making.

Corporate IT

Power BI- Intermediate

This one-day Power BI intermediate course helps users master advanced data transformation, DAX, and interactive dashboards for deeper data insights.

Corporate IT

Power BI- Advanced

This two-day Power BI advanced course helps professionals master data modelling, automation, and advanced analytics to build powerful, data-driven dashboards.

Corporate IT

Power BI- Introduction

This two-day Power BI introduction course helps professionals connect, analyse, and visualise data to create interactive dashboards and data-driven insights.

Check Our FAQs

What types of training courses do you offer?

We offer a wide range of bespoke corporate training solutions across key areas such as leadership, management development, digital skills, workplace communication, customer experience, sales performance, project delivery, team development and professional skills. Each programme can be tailored to your organisation’s objectives, your people and the practical challenges they face at work.

Do you offer public courses?

No. Elliott Training does not currently offer public scheduled courses for individual delegates. We specialise in private corporate training courses delivered exclusively for organisations, teams and groups who require tailored training aligned to their business needs.

Are your courses bespoke?

Yes. Our courses can be tailored to your organisation, team and objectives. We can adapt the course content, examples, exercises, case studies and delivery style to reflect your sector, systems, processes and workplace priorities.

Can you create a bespoke course from scratch?

Yes. If you require a course that is not listed on our website, we can design a bespoke training programme around your specific requirements. This is ideal for internal projects, new systems, company initiatives, role-specific development or specialist skills training.

How long are your training courses?

Course length depends on the subject, objectives and level of detail required. We can deliver bite-size sessions, half-day workshops, full-day courses, multi-day programmes or larger training projects across multiple cohorts.

Struggling find an answer to your question?

Contact Us

Ready for transformation?

Speak to one of our experts and find out how we can take your learning journey to the next level.

"*" indicates required fields