Excel 365 Functions 1

  • Closed
  • 27th Jan 22
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members
Join waiting list Receive updates on future training and available places

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

  • Closed
  • 27th Jan 22
  • 10am-11.30am
  • Remote Via MS Teams
    Remote via MS Teams
  • £20for members £for non-members
Receive updates on future training and available places Join waiting list

Other occurances of this programmes

Can't make this training?

Get notified when this
course is on next.

Get notified of next event