What will I learn?

This Advanced course is designed for those users who wish to increase their current knowledge of Excel to include the more complex and advanced features.

At the end of this course, participants will be able to:

  • Work with Advanced functions
  • Create Lookups and data tables
  • Manage and analyse lists of data
  • Create and use PivotTables and PivotCharts
  • Use validation rules
  • Create a basic macro

    Entry Requirements

    This Advanced course is suitable for anyone who has ideally attended an Excel Intermediate course or has sufficient experience and understanding of Excel.  If you are unsure if this course is at the right level for you, please contact us on 0845 8500916 to discuss.

    Entry Requirements Age

    Applicants must be 19+ on the start date of the course in order to apply/enrol on the course.

    Please Note

    All fees are correct at the current time and may be subject to change.

    Due to funding restrictions this course is not available to:

    · Existing full time Sparsholt College/Andover College students aged 16, 17 or 18 (or 19-24 with an EHCP) on the 31/8 in the year they started/start their course
    · Learners aged 19-24 with an EHCP

  • Fees:

    £158

    Level of Study:

    Part-Time

    Dates:

    • 20/03/2026 - (VQADVEV/FC02)
    • 18/06/2026 - (VQADVEV/FC03)

    Interview:

    No

    Location:

    Virtual

    Duration:

    09:30 - 16:30