Pivot Tables 2 - Free Excel Practice Online

This free, interactive exercise teaches you Pivot Tables 2 in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Tables track and works right in your browser - no Excel install, no download, and no signup.

Practising Pivot Tables 2 this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Pivot Tables 2 lesson

1. If you haven't already, download WDI Data to continue with pivot tables.Click the "Insert" tab, then click "Pivot Table" and click "ok" on the Create Pivot Table dialog box.Note: If you don't have Excel, you can follow along on this version, though some functionality may be a bit different.Press Check Answer to continue.
2. On the right side, drag Country Name to the Rows box.Drag 2015 to the Values box.Drag Indicator Name to the Filter box and filter for Access to Electricity.What percentage of Afghanistan's population had access to electricity in 2015?
3. On the right side, un-check Country Name.Drag Region to the Rows box.Hmm... How can 300% of North America's population have access to electricity? Note the column heading says "Sum of 2015," which means it's adding together the percentage for all three countries in North America.To fix this, click the down triangle on "Sum of 2015" in the Values box on the right side. Click "Value Field Settings" and choose Average.Now what was the average access to electricity for North America?
4. Change the Indicator Name filter to International Tourism. What was the AVERAGE number of tourists to countries in Sub-Saharan Africa in 2015?
5. Change the Value Field Settings back to SUM of 2015. What was the TOTAL number of tourists to Sub-Saharan Africa in 2015?
6. Suppose we just want to know the number of countries in Sub-Saharan Africa. Change the Field Value Settings to COUNT of 2015.How many countries were included in Sub-Saharan Africa in 2015?
7. Look at the Grand Total line.How many total countries were included in the 2015 tourism data?
8. How many countries were included for East Asia & Pacific in the 2015 tourism data?
9. How many countries were included for Europe & Central Asia in the 2015 tourism data?
10. How many countries were included for South Asia in the 2015 tourism data?

Pivot Tables 2 practice - FAQ