Excel - Formulas & Functions

Prerequisites

Before attending this course, participants should have a working knowledge of Microsoft Excel.

At course completion

After completing this training, participants will be able to conveniently use formulas and functions within MS Excel.
 

Course outline

Module 1: Introduction

  • Quick Calculations
  • Naming cells
  • Working with AutoFill

Module 2: Formulas

  • The Formula Bar
  • Inserting a Formula
  • Understanding cell references
  • Operator precedence
  • Comparison operators

Module 3: Functions

  • Inserting a function
  • Frequently used functions
  • Nesting functions
  • Function Library:
    • Logical functions (IF, AND, …)
    • Information functions (IS functions)
    • Lookup functions (VLOOKUP, LOOKUP)
    • Math & Trigonometry functions (SUMIF, SUMIFS, ROUND)
    • Statistical functions (COUNT, AVERAGE, MAX, …)
    • Text functions

Module 4: Troubleshooting formulas & functions

  • Checking errors
  • Evaluating formulas
  • Tracing precedents and dependents