Excel 365 Functions 1

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.