Home » Training and Events » Advanced Microsoft Excel

Advanced Microsoft Excel

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.

Date
Friday 21st September 2018

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

Cost

  • £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

Course Venue 
OCVA, The Old Courthouse,
Floyd’s Row,
Oxford OX1 1SS

01865 251946

Access on road is via Speedwell Street (a one-way system). Please note there is no parking at OCVA.

Registration

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

  1. Complete the Google bookings form and register your details
  2. Make payment via PayPal within two working days of registering for the course. 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).

Step 1:

Step 2:

Choose payment type:

OCVA
Members
£ 70.00
  • Pay with PayPal
Charitable Organisations*
£ 80.00
  • Pay with PayPal
Non charitable rate
£ 95.00
  • Pay with PayPal
Course details at a glance

Date: 21st September 2018
Time: 1.45pm – 5.00pm
Cost: £70 – £95

Course venue

OCVA, The Old Courthouse,
Floyd’s Row,
Oxford OX1 1SS

01865 251946

Access on road is via Speedwell Street (a one-way system). Please note there is no parking at OCVA.

Enquiries contact

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

Email training@ocva.org.uk or call us on 01865 251946

Share with a friend
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on whatsapp
WhatsApp
Share on email
Email
COVID-19: Support, advice and information for the community
This is default text for notification bar
Skip to content