View Details

Venue
Remote Corporate Training, Not a geographical location
venue
Admin Contact
Corporate Training Mail Box (corporate.training@eastsussex.gov.uk)
Target Audience
All users
target audience
Course Types
Course
Course categories
ESCC Assessment & Care Management / ESCC Directly Provided Services / ICT & Digital Skills / ESCC Staff / Early Years and Childcare / Schools and Governors / Voluntary and Community Sector / Public Sector Partners (eg NHS, Police, Probation)
Subject
ICT & Digital Skills / Personal Development
Course description

Delegates' email addresses as registered on the portal will be provided to the trainer for the purpose of conducting this training only.


Delegates should ensure that their work (not personal) email addresses are recorded - check and update as necessary through 'My Profile and Bookings/Change Contact Details'.



The training is expected to be delivered through Microsoft Teams.


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 course includes topics from the Excel Performing Calculations and the Excel Advanced Calculations courses


 

Training objectives

Pre-requisites



The course assumes that delegates are familiar with: entering simple formulas, copying formulas with AutoFill and 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.


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 information on the function needed 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



  • Search for information on the web

  • Use Excel function libraries


Check for Errors



  • Work with Excel error checking

Additional Information

Please note that the provider for this session is an external trainer. Once your place has been confirmed look out for invitation to join from pmseaman@gmail.com

Accept the invitation (and be sure to check your spam folder as well in case it has slipped into that) and the session will automatically drop into your Outlook calendar. 

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