Microsoft Excel – Intermediate

Course Summary

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

This course is the second of our excel series, the others being Excel Beginners, Excel Advanced and Excel Expert.

Topics

  • Relative and Absolute cell referencing
  • Using the =If() function and logical functions
  • Understand statistical formulas such as MAX, MIN etc.
  • Using the =VLookup() function
  • Protecting the Worksheet
  • Date, Time or Percentage formatting
  • Understand the Auto-calculate, basic Filter, Table and Sort functions
  • Use the Freeze Pane function
  • Create a basic graph from data and edit and format the chart and change chart type.

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.

Course at a Glance

  • Next Start Dates:

    7 November 2017
    6 February 2018
    5 June 2018
    6 November 2018
  • CPD Points: 4
  • Course Cost: £175.00
  • Course Length: 4 hours (09:00-13:00)
  • Location: GTA University Centre, Guernsey
  • Tutor: Jacqui Ward

There are no dates currently available for this course, If you would like to register your interest please complete the form below:

Latest Articles



Latest from Twitter



Want to learn more? Sign up to our mailing list!



We will email you from time to time to update you on upcoming courses, events and conferences.