Course Details

Digital Skills Course: Excel: Functions for data analysis

Who is this course aimed at?

All University Staff

What is this course about?

You will learn how to use logical functions useful for data analysis in Excel and gain practical experience applying and combining logical functions.

Objectives

Here is what you can expect by attending this course:
  • Analyse data using the versatile SUMPRODUCT function
  • Combine a logical test with the SUMPRODUCT function
  • Explore the IF logical function and apply multiple logical tests by nesting IF functions
  • Sum & count based on logical criteria using SUMIF, SUMIFS, COUNTIF & COUNTIFS
  • Utilize Logical operators like equal to, greater than, greater than or equal to, less than, less than or equal to, and not equal to.

Booking info:

Book your place

There are currently no planned events for this course.

Courses with active waiting lists are given priority when scheduling new dates so, if this course is of interest, please add yourself to the waiting list by clicking "Book your place" above.

Please note, if you experience difficulty in connecting to the waiting list, please log into MyHR separately and then click "Book your place" again. You can also contact people@hud.ac.uk if you require further assistance.

Don't have access to MyHR?

If you do not have access to MyHR (i.e. you may be an Affiliate) please email people@hud.ac.uk confirming your full name, the name of the course you would like to attend (and date of course if applicable) and the School/Service that you work for.

Attendee Details

*
*
*
*
*

Our Development Themes

Want to book on to a session or explore our themed learning resources?

See more

A-Z of our Sessions

Search for a session using our A-Z guide.

See more

Upcoming Sessions

Find our upcoming sessions here.

See more