Skip to content
  • Excel Practice Online
  • Book your excel workshop today!
  • Excel Shortcuts
  • About
  • Contact
  • Join Premium Club
Menu Close
  • Excel Practice Online
  • Book your excel workshop today!
  • Excel Shortcuts
  • About
  • Contact
  • Join Premium Club
Excel Practice Online

Practice excel and become a master!

Functions & Tools

  • Excel Basics

  • SUM

  • MAX

  • MIN

  • COUNTA

  • COUNT

  • AVERAGE

  • Filter Tool

  • Sort Data

  • Flash Fill

  • Remove Duplicates

  • IF

  • Nested IF

  • Conditional Formatting

  • SUMIF

  • COUNTIF

  • AVERAGEIF

  • SUMIFS

  • COUNTIFS

  • MAXIFS

  • MINIFS

  • VLOOKUP

  • XLOOKUP

  • Pivot Table

  • INDEX MATCH

  • Text to Columns

  • LEFT, MID, RIGHT

  • AND/OR

  • INDEX

  • MATCH

  • TEXTJOIN

  • CONCAT

  • LEN

  • TRIM

  • LOWER, UPPER, PROPER

  • DAY, MONTH, YEAR

  • WEEKDAY

  • EOMONTH

  • IFERROR

  • SUMPRODUCT

  • Excel Wildcards

  • Advanced Filter

  • Power Query – Combine data from multiple workbooks

  • Power Query – Column from Examples

  • Unpivot columns using Power Query

  • UNIQUE

  • SORT Function

  • SORTBY

  • FILTER Function

  • RANDARRAY

  • SEQUENCE

  • PMT

  • PPMT & IPMT

  • How to run a VBA Macro code?

  • Blank Excel Online Worksheet

  • Terms and Conditions
  • Privacy Policy
Copyright © 2021 - EXCEL PRACTICE ONLINE

Terms and Conditions - Privacy Policy