Advanced Excel

L2 Level 2
7 April 2027 — 7 April 2027
City Centre Campus, Cardiff

About this course

Excel Advanced: Master Excel’s Most Powerful Features


Take your Excel expertise to new heights with our Advanced Excel course. Designed for confident Excel users, this course equips you with the skills to tackle complex data challenges, streamline workflows and create professional, data-driven reports. Learn advanced functions and formulas, unlock the full potential of PivotTables and PivotCharts, and enhance data presentation with tools such as Sparklines and Cell Protection. Through practical, hands-on exercises, you'll develop the confidence to work smarter, analyse data more effectively and maximise the power of Excel in the workplace.

What you will study

This course is delivered at our City Centre Campus from 9.30am – 4:00pm.

If you do not have a laptop, one will be made available for you to use on the day.

Enter and Organise Data

  • Insert, copy, delete and hide tabs
  • Change tab colour
  • Cell styles
  • Linking Worksheets and Workbooks
  • Cell Protection and restricting data entry
  • Protecting Worksheets
  • Protecting Workbooks
  • Named Ranges
  • Naming Tables
  • Page Setup and Repeating rows and columns

Managing Data

  • Data Validation
  • Sub-totals
  • What if
  • Goal seek
  • Filters and Slicers
  • Sparklines

Functions and Formulas

  • IF Statements
  • Advanced
  • SumIfs
  • CountIfs
  • CountA and CountBlank
  • RoundUp and RoundDown
  • Rank
  • Concat

Charts, Pivot Tables and Pivot Charts

  • Managing Charts
  • Creating Pivot Tables and Pivot Charts
  • Managing Fields
  • Filtering and sorting
  • Drill Down

Course fees

Course Fee: £150.00

Entry requirements

You are eligible for this course if you:

  • are aged 19+ • can attend the entire session
  • have experience using Microsoft Excel for in-depth data management

Important points

  • The College welcomes contact with parents/guardians of students who are under 18.
  • Additional support is available for students with learning difficulties and disabilities.
  • Cardiff and Vale College is committed to inclusion and values diversity. We are determined to promote equality of opportunity and to treat everyone fairly and with respect.
  • Cardiff and Vale College reserves the right to make changes to this course without prior notice.
  • Course fees are subject to change. Your fee will be confirmed prior to enrolment.
  • All courses are accurate at the time of upload or print.
  • Courses can only run if there are sufficient numbers.
  • Please note, if you choose three or more course choices, then you may be referred for a careers appointment first. This does not apply to A Level or GCSE choices.
Key information

Start date

7 April 2027

End date

7 April 2027

Time of day

Day Time

Location

City Centre Campus, Cardiff
Maps & directions

Course code

CSAEX2P01
L2

Qualification

Advanced Excel

Locations

City Centre Campus, Cardiff
City Centre Campus, Cardiff

City Centre Campus,

Dumballs Road,

Cardiff,

CF10 5FE