£70

Microsoft Excel - Formulas and Functions

Event Information

Share this event

Date and Time

Location

Location

Wessex Community Action

Whittle Road

#Unit 6

Churchfields

SP2 7YR

United Kingdom

View Map

Event description

Description

This course is for anyone in business or the voluntary sector who need to manipulate numbers, summarise data, combine lists or manipulate data in a variety of ways.

Excel is an incredibly flexible package, but most people only use 20% of the features. This day delves into the calculating capabilities of Excel so you have knowledge of the calculations it can do and the situations to which they can be applied. For example we’ll learn to add, average and summarising blocks of numbers in a variety of ways, use formulas to grab data from other sheets and lists for summarising, delve into the mysteries of SUMIFS() and COUNTIFS(), see how Excel can make decisions for you and clean up text entered by others. The day is a toolkit of Excel capabilities for you to apply in your job role or to develop your knowledge for the next stage in your career.

Most importantly, you do not have to be a whizz at maths to get immediate benefit from using Excel - if you can use a calculator you can use Excel!

By the end of the day you will be able to:

Explain the difference between a standard formula and an Excel function

Summarise blocks of numbers using Excel functions

Use logical formulas such as IF() to make decisions on the spreadsheet

Use lookup functions to grab data from other worksheets

Use text functions to clean up text data

_______________________________________________________________________________________

Tea and coffee will be available during the day.

If you are a voluntary or community organisation that does not have a credit or debit card and you wish to book places on any of our courses or seminars please email info@wessexcommunityaction.org.uk to request a booking form. On receipt of the booking form Wessex Community Action will confirm the places and raise an invoice.

Refunds can be requested from the organiser up to 14 days before the event. Please email info@wessexcommunityaction.org.uk . If the event is cancelled by the organiser then a full refund will be made.

As our Training Room is on the First Floor we regret that there is no disabled access. If you are disabled and are interested in our courses and events please email: info@wessexcommunityaction.org.uk providing your contact details and we will be in touch to see what alternative arrangements can be made to provide access to our events.

Share with friends

Date and Time

Location

Wessex Community Action

Whittle Road

#Unit 6

Churchfields

SP2 7YR

United Kingdom

View Map

Save This Event

Event Saved