Excel pivot table practice exercises
Lesson 9 · Pro
✓
Lesson 9 done.
You can turn a list of orders into a report without writing a formula: totals by region, a grid with Columns, a count instead of a sum, the biggest on top, one category through a filter, subtotals with two fields in Rows, dates grouped by month, shares of the total, and a Refresh before you trust any of it. Try it on a list of your own this week: click a cell in it, then Insert → PivotTable.
More Excel practice
Excel practice onlineExcel skills testExcel formula playgroundExcel practice for beginnersExcel IF function practiceVLOOKUP practice exercisesXLOOKUP practice exercisesSUMIFS and COUNTIFS practiceINDEX MATCH practice exercisesExcel date functions practiceExcel keyboard shortcuts practiceSQL practice onlineLearn to read financial statements