Skip to content
  • Excel Practice Online
  • Excel Exercises
  • Excel Shortcuts
  • About
  • Contact
  • 0
0 Menu Close
  • Excel Practice Online
  • Excel Exercises
  • Excel Shortcuts
  • About
  • Contact
  • 0
Excel Practice Online

Practice excel and become a master!

Pivot Table Exercise

Pivot Table Exercise

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

  • FIND

  • SEARCH

  • TRIM

  • LOWER, UPPER, PROPER

  • DAY, MONTH, YEAR

  • DATE

  • 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

  • Practice Data Worksheet – Excel Practice Online!

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

Cart

Terms and Conditions - Privacy Policy