Microsoft Excel – Advanced

Date & Time

No further occurrences


GTA University Centre

Course Summary

This half-day course is designed to assist those wishing to build further upon their knowledge of Microsoft Excel. Ideally delegates will have completed the ‘Intermediate’ module or have a good working knowledge of other Excel versions to begin with.

This course is the third of our Excel series, the others being Excel Beginners, Excel Intermediate and Excel Expert.


  • Use the 'Names Manager' and Named Ranges in Formulas
  • Understand the Data Validation tool
  • Use the IF statement with OR & AND
  • 'Nest' additional IF statements where there is multiple criteria
  • Use Formula Auditing Tools
  • Use the Show Formulas and Evaluate Formula function
  • Pivot Tables/Chart and Slicers
  • Understand how to Protect Cells
  • Use the Group function to tie a range of cells together and insert subtotals
  • Use the Advanced Filter function
  • Use the DSUM database function
  • Create a Macro using the 'Record macro' function (writing in VBA is covered in the Expert Level)
  • Assign an image to a macro and update the Quick Access Toolbar with icon
  • Use the Trust settings.

Tutor Profile


Jacqui Ward is the proprietor and trainer of JW Training, specialising in providing Microsoft application training and business consultancy.

Jacqui is a qualified PRINCE 2 Project Manager and freelance computer software trainer with over 25 years’ experience both in Guernsey and the UK. She has delivered packaged and bespoke training on a corporate, group or one-to-one basis for a variety of major financial companies, the States of Guernsey, Guernsey Electricity and quarterly Excel sessions for the GTA to name just a few.

In previous roles Jacqui has worked as both a marketing director for an international merchant bank and as an IT business solutions manager. Delegate feedback is consistently high, emphasising Jacqui’s ability to draw on her vast experience to deliver training which is targeted on user requirements in her relaxed, friendly and focused style.