About the course

  • Pre-requisites

    You'll need Excel 2007, 2010, 2013 or 2016 installed. A desire to want to learn what Excel can really do for you!

  • Who will benefit?

    Anyone who wants to learn more than formulas and enhance their knowledge to become an Advanced user of Excel.

  • Course Outcomes

    You'll learn great tools such as Consolidate, Advanced Filtering, Goal Seek for forecasting data, Pivot Tables, Protecting Sheets and Recording Macros. Pick up tips, techniques and shortcuts to make using Excel simple!

Course curriculum

  • 1
    Welcome to the course!
    • Here's what you'll be learning...
    • Course Exercises
  • 2
    Module 1 - Goal Seek
    • Goal Seek
  • 3
    Module 2 - Using Scenarios
    • Scenarios
  • 4
    Module 3 - Consolidation
    • Consolidate - Part 1
    • Consolidate - Part 2
  • 5
    Module 4 - Advanced Filtering
    • Advanced Filtering
  • 6
    Module 5 - Working with Tables
    • Working with Tables - Part 1
    • Working with Tables - Part 2
    • Working with Tables - Bonus Tip
  • 7
    Module 6 - Validation
    • Validation - Drop Down Lists
    • Validation - Date Ranges
  • 8
    Module 7 - Protection
    • Protection - Protect Sheet
    • Protection - Protect Workbook - Bonus Tip
    • Protection - Protect File
  • 9
    Module 8 - Pivot Tables
    • Introduction to Pivot Tables
    • Pivot Tables - Analysing Data
    • Pivot Tables - Grouping
    • Pivot Tables - Slicers
    • Pivot Tables - Pivot Charts
  • 10
    Module 9 - Macros
    • Introduction to Macros
    • Recording Macros
    • Assigning Macros
    • Recording Global Macros
  • 11
    Test your learning
    • End of Course Quiz
  • 12
    Course Survey
    • Before you go, we'd love to hear your feedback on the Excel Advanced course please...

Course Instructor

  • Simon Lambourne-Wills

    Microsoft Office and Office365 Trainer

    Simon Lambourne-Wills

    I’ve been an IT trainer for over 10 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it’s important to enjoy attending training courses. Therefore, engaging and interacting with students on their own experiences of using the software, enables them to feel more involved in the course.

Other Available Courses

View more courses