Excel Intermediate



This course is for users who have either completed the Beginner course or who have gained sufficient experience to be familiar with the Beginner topics.



Classroom: 1 day

Online: 2 half days


Session 1: November 10th 9.15am - 12.45pm

Session 2: November 24th 9.15am - 12.45pm



  • Be comfortable with the content of the Beginner course – revision of this if required
  • Revision of use of absolute and fixed cells references
  • Be able to insert and delete rows and columns
  • Be able to create a chart in a number of different formats
  • Insert, rename, move, copy sheets within and between spreadsheets
  • Be able to link sheets, so that changes in one are automatically updated in another
  • Set up a list, do simple and complex sorting (including multiple levels, by colour and by icon)
  • Use basic If Function
  • Introduction to Conditional Formatting
  • Introduction to VLookup Function
  • Formatting a list as a table – why and when you do it
  • Introduction to Pivot Tables
  • (If time allows) Introduction to Countif/Sumif/Countifs/Sumifs


Upcoming Dates (online)

Session 1: August 31st 9.15am - 12.45pm

Session 2: September 7th 9.15am - 12.45pm



This training will be delivered by Anne Walsh - The Excel Expert