Excel Functions


MASTER MICROSOFT EXCEL: Unleash the Power of Spreadsheets


Welcome to your one-stop destination for mastering Microsoft Excel. Our platform offers comprehensive, easy-to-understand tutorials and resources designed to help you harness the full potential of Excel. Whether you’re a beginner just starting out or an advanced user looking to refine your skills, we have something for everyone. Dive in and start your journey towards becoming an Excel wizard today!


  • SUM
  • Excel Self Assessment Test
  • Excel Basics
  • SUM
  • SUMIF
  • SUMIFS
  • MAX
  • MAXIFS
  • MIN
  • MINIFS
  • AVERAGE
  • AVERAGEIF
  • VLOOKUP
  • XLOOKUP
  • Pivot Table
  • COUNT
  • COUNTIF
  • COUNTA
  • COUNTIFS
  • TEXTJOIN
  • LEFT, MID, RIGHT
  • LEN
  • TRIM
  • FILTER Function
  • Filter Tool
  • SORTBY
  • Sort Data
  • SORT Function
  • Excel Wildcards
  • Flash Fill
  • Concatenate
  • CONCAT
  • Remove Duplicates
  • Nested IF
  • IF Function
  • Conditional Formatting
  • AND/OR
  • ISBLANK
  • INDEX
  • MATCH
  • INDEX MATCH
  • Text to Columns
  • TEXTBEFORE & TEXTAFTER
  • TEXTSPLIT
  • FIND
  • SEARCH
  • SUBSTITUTE
  • DAY, MONTH, YEAR
  • DATE
  • WEEKDAY
  • IFERROR
  • SUMPRODUCT
  • Advanced Filter
  • UNIQUE
  • RANDARRAY
  • SEQUENCE
  • LET
  • FV
  • VSTACK
  • HSTACK
  • CHOOSECOLS
  • CHOOSEROWS
  • TOROW
  • TOCOL
  • PMT
  • PPMT & IPMT
  • PV
  • Excel Mortgage Calculator
  • How to run a VBA Macro code?
  • Blank Excel Online Worksheet
  • Practice Data Worksheet – Excel Practice Online!
  • Excel Online Cheat Sheet
  • Addition in Excel – Tutorial and Practice
  • Subtraction (minus) in Excel – Tutorial and Practice
  • Multiply Numbers in Excel – Tutorial and Practice
  • Division in Excel – Tutorial and Practice
  • Power Query – Combine data from multiple workbooks


    • Post a Comment