Introduction to Microsoft Excel

Training details

This interactive course introduces beginners to the Microsoft Excel software and explains how it can be used to enhance your work. It is ideal for learners and refreshers as it covers all the basic elements of Excel in a practical, hands-on format. There will be plenty of time to practice your new knowledge and ask questions in the session and by the end of the course, learners will be able to format a spreadsheet for printing, create charts, use basic functions effectively and start to analyse data.

Who should attend?

This session is appropriate for any staff, volunteers or trustees who are complete beginners or with limited experience of Microsoft Excel. You will need to bring a laptop and mouse to use during the session.

What will I learn?

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

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

• Have a good working knowledge of Excel basics
• Open and navigate workbooks
• Find information on a spreadsheet
• Enter and edit labels and values
• Modify your worksheet: move and copy data, insert and delete ranges, format rows and columns, sort and filter columns
• Merge cells, format text and justify data to be able to create tables that look how you want them to
• Use built-in templates, Format Painter and AutoFormat
• Understand and be able to build simple calculations and formulae
• Know how to use Freeze Panes and hide data
• Prepare to print using setup options, page break previews and print multiple sheets.

Trainer - Gary Gibbs

Gary has had a varied career and is an experienced trainer, having trained people in health and safety, databases, consumer driven product development and food science. He started his career as a research and development scientist using excel extensively for data analysis and reporting and later moved into the food industry where he used excel for business analysis combining large data sets to do commercial analysis on how the company’s products were performing in the marketplace. Most recently Gary has created spreadsheet to mail merge invoices, track projects and imported research questionnaires into online applications for use in clinical trials. He loves a spreadsheet!

Cost:

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

Time:
10 am – 1 pm. There will be a short break during the session. 

Course venue:
The Source (next door to OCVA office),
Floyd’s Row,
Oxford OX1 1SS

Details of getting into Oxford by bus, cycle, car or train can be found here. Please note there is no parking at the venue.

Click on 'Book Now' at the bottom of this page to book your place. If the event is fully booked, please register to add your name to the waiting list. 

Please note, if you are booking on behalf of another/others, you must have their names and email addresses ready. If they do not have an email address, please contact us by emailing training@ocva.org.uk.