Microsoft Excel Functions Training Course

Table of Contents

Excel Functions Training Courses

Excel Functions Overview

On our Excel Functions training course you will learn dozens of new functions to enhance your spreadsheets: logical functions, lookup functions, and statistical functions to name a few.

Microsoft Excel functions are the backbone of most Excel worksheets but with nearly 500 worksheet functions in Excel how can you possibly learn them all? The answer is to learn the important ones.

This Excel functions course is devised to give you a broad skill set covering all the primary categories of Excel functions. Our course includes the new functions which have been introduced into Excel recently such as SWITCH, IFS, TEXTJOIN and CONCAT.

Excel Functions Training Courses

Excel Functions Five Key Topics

  1. Text formulas and functions
  2. Decision making functions: IF, IFS, SWITCH
  3. Filter functions: SUMIFS, COUNTIFS
  4. Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
  5. Using Information and Error handling functions
Excel Functions Training Courses

Course Details

Course Duration : 1 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability : Monday – Saturday

Excel Functions Training Courses

Excel Functions Training Course Details

Course Location : Our Microsoft Excel Functions training course can be delivered at your offices, Mouse venue or online.

Class Size : Individual or Group.

Course Format : Classroom style or online (Teams or Zoom)

Tailored Course Content : Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.

Next Public Course : Due to COVID, public classroom courses are suspended until March 2021.

On Completion of Excel Functions

  • Text formulas and functions such as TRIM
  • Filter functions such as SUMIFS
  • Database functions such as DSUM and DGET
  • Decision making functions such as IF, IFS and SWITCH
  • Date and Time such as TODAY and NETWORKDAYS
  • Lookup and Reference functions such as VLOOKUP and XLOOKUP
  • Magnitude functions such as MAX, LARGE and RANK
  • Information and error functions such as CELL, ISNA and IFERROR

Excel Functions Course Outline

  • Concatenation operator or CONCATENATE function?
  • CONCAT and TEXTJOIN functions
  • Extraction; LEFT, RIGHT, MID
  • Manipulation: LEN, TRIM, FIND, SEARCH, REPLACE, SUBSTITUTE
  • Conversion: TEXT, VALUE, UPPER, LOWER, PROPER
  • SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS, MAXIFS
  • Database functions: DSUM, DCOUNT, DCOUNTA, DAVERAGE, DGET
  • IF, AND, OR, NOT
  • Constructing and evaluating nested IFs
  • IFS and SWITCH, the alternative to nested IFS
  • IFERROR, IFNA
  • CHOOSE
  • NOW, TODAY
  • NETWORKDAYS
  • MAX and MIN
  • LARGE and SMALL
  • RANK
  • IFERROR and IFNA
  • CELL
  • ISERR, ISERROR, ISNA
  • ISBLANK, ISNUMBER
  • VLOOKUP and HLOOKUP
  • XLOOKUP
  • COLUMN and ROW
  • MATCH
  • INDEX
  • XMATCH
  • OFFSET
  • TRANSPOSE
  • INDIRECT
  • Intersection formulas
Excel Functions Training Courses
Excel Functions Training Courses
Excel Functions Training Courses
Hints and Tips