Excel 365 Functions 1

  • 1 place(s) remaining
  • 27th Jan 22
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members

Overview

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

Delegates will learn how to use Excel functions including AVERAGE, COUNTIF and VLOOKUP.  They will also learn 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.

This course will enable you to

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 a 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 VLOOK UP

Find a function to do a particular task

  • Search for information on the web
  • Use Excel function libraries

Who is the Course aimed at

Anyone who can enter simple formulas in a workbook and wishes to extend their 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 Intermediate course.

Excel 365 Functions 1

  • 1 place(s) remaining
  • 27th Jan 22
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members
Book
Can't make this training?

Get notified when this
course is on next.

Get notified of next event