Excel for Beginners: Advanced Functions

Instructor: Edward Falzon

What you'll learn

  •   Manage data more easily by using advanced conditional functions like COUNTIF, COUNTIFS.
  •   Create conditional data by combining basic arithmetic with logic into functions like SUMIFS and AVERAGEIFS.
  •   Quickly search and obtain specific values in tables with reference functions like VLOOKUP, XLOOKUP, INDEX, MATCH.

    • Skills you'll practice

  •   Data Entry
  •   Spreadsheet Software

    • Excel for Beginners: Beginner Functions

    Excel for Beginners: Introduction to Spreadsheets

    Spreadsheets for Beginners using Google Sheets

    Using Basic Formulas and Functions in Microsoft Excel

    ©2025  ementorhub.com. All rights reserved