Do you want to develop your Microsoft Excel skills? Would you like to make your work more efficient through the use of formulas and formatted spreadsheets?

This interactive and practical course introduces participants to the advanced techniques and how these can be used to enhance your work. This course is ideal for those who have experience of using Excel, but would like a more in-depth knowledge of how to use spreadsheets more efficiently. By the end of the course, learners will be able to use conditional formulae to analyse data, understand techniques to summarise data and know how to look up information and values.

Learners will leave with a USB drive containing a handout and exercises to practice outside the classroom.

What will I learn?

By the end of this session you will be able to:

  • Use conditional formulae
  • Use Vlookup/Hlookup to look up information
  • Use pivot tables and pivot charts to summarise data
  • Use goal seek to meet a set value

Trainer Profile

Mary Thomas has been training and consulting with businesses of all sizes since 2009 in the uses and implementation of social media and digital marketing. She has written and delivers accredited social media and digital marketing qualifications for City & Guilds as well as being a published author and public speaker.

Benefits to you

You will leave the session with some practical tools to ensure you have the ability and confidence to use spreadsheets effectively within your work.

Who should attend?

This session is appropriate for any organisation members.


Friday 21st September 2018


1.45am arrival for tea, coffee and networking for a 2.00pm start. The workshop will finish by 5.00pm.


£70 per person for OCVA Members
£80 per person from a charitable organisation who are not OCVA members
£95 per person from a non-charitable organisation



The Old Courthouse
Floyds Row
St Aldates

There is no parking available at the venue, although we maybe able to assist those with disabilities. Please contact us to enquire if you have a disability. The venue is serviced with good transport links details of which can be found here. For more information on alternative parking, please see here.

Enquiries contact:

Telephone:  01865 251946
Email: training@ocva.org.uk

When contacting us please state the name of the course your correspondence is in relation to.


Please note there are two steps to this process and both steps of the process will need to be completed to secure your place.

Step 1: Please register your details with us on the form:

Please note that registration without payment does not constitute a booking. Both are required, and we do check. (Thanks!)

Step 2: Make payment within 2 working days of registering.

We’re using PayPal for this event. Select ‘pay with a debit or credit card‘ if you don’t have a PayPal account (there’s no need to sign in to PayPal).

Choose payment type Select
OCVA Members pay £70.00 GBP Preview Image
Charitable organisations who are not OCVA members pay £80.00 GBP Preview Image
Non-charitable Rate pay £95.00 GBP Preview Image

Further courses to consider: