Back to Courses

Excel Advanced

Course Code: MTK23

Level: 3
Subject area: Business, Management & HR
Awarding body: City College Plymouth
Qualification: College Certificate
Course type: Short course
Time of Day: Daytime
Duration: One day
When you'll study: Various days, 9.00am - 4.30pm

Choose A Start Date & Apply
About the course

Are you looking for Microsoft excel training at advanced level? This one day course covers pivot tables for analysis using macros, the ‘what if’ function and how to analyse data as well as setting up a database.

What you'll learn

The skills and knowledge acquired in this Excel Advanced workshop are taking you to the next level of Excel use, giving you the opportunity to be able to use and operate the software at a superior level.Topics include:

  • pivot tables for analysis
  • using macros
  • using the ‘What If’ function
  • how to analyse data
  • setting up a database.
Entry requirements

You will require a good working knowledge of Microsoft Excel.


There is no assessment for this course.

What's next?

On successful completion you may progress to a range of computing courses at the College.

Important information

Fees quoted apply to courses starting in the academic year 2017/18 (August 2017 – July 2018). There may be a slight increase in fees for courses starting 2018/19.

Although we’re not yet able to confirm the start date for this course, applications are now welcome, just complete and return an application form.