View Details

Venue
Remote Corporate Training, Not a geographical location
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
target audience
Course Types
Course
Course categories
ESCC Directly Provided Services / ICT & Digital Skills / ESCC Staff
Subject
ICT & Digital Skills
Course description

Is this course for you?


You can enter simple formulas in a workbook, and wish to extend your skills using functions to perform tasks such as: finding the average of a set of data; counting data entries which match specified conditions; looking up data entries in a table.


This online course has example worksheets you can practice with after the session.


There is also a 3 hour, classroom-based version of this course, which has more opportunity to practice techniques during the training.


Pre-requisites


The course assumes that delegates are familiar with:
• entering simple formulas,
• copying formulas with AutoFill
• locking cells with $ signs.


To take part in this course, delegates will need an internet-connected device with camera and microphone, and an internet connection which can stream video in reasonable quality.

Training objectives

At the end of the course, you will be able to use Excel functions including AVERAGE, COUNTIFS and VLOOKUP. You will also know how to search for a function to perform a particular task, and be able to use the help available in Excel to complete a function's arguments.

Learning outcomes

Introducing Excel functions



  • Understand what a function is

  • Work with function arguments


The AutoSum list



  • Find the AVERAGE, MAX and MIN values for a set of data

  • Understand the COUNT function


Write your own formulas using functions



  • The five things you need to enter for a function

  • Count non-blank cells with COUNTA


Complete a function's arguments



  • Use a function tooltip to complete multiple arguments

  • Get help from the Function Arguments dialog box


Use more complex functions



  • Count rows of data meeting particular conditions with COUNTIFS

  • Add up data meeting particular conditions with SUMIFS

  • Look up data in a table with VLOOKUP


Find a function to do a particular task



  • Use Excel help

  • Search for information on the web

Additional Information

This is a remote session delivered via MS Teams. Delegates' email addresses as recorded on the learning portal will be passed to the facilitator for the purposes of this session only. Please ensure that your correct personally allocated email is that shown on your learning portal account.

Enquiries
Start Date
Wednesday 7 September 2022
End Date
Wednesday 7 September 2022
Closing Date
Tuesday 6 September 2022
Times
10:00 - 11:30
Maximum Places
10 
Cost
Login to view cost
Number of Sessions
1

Need more time?

For security reasons your session is about to expire. You will be automatically signed out in

To continue your session, select Stay Signed In.