始める無料で始める

Select rows

In this exercise, you'll begin to populate our pivot table by selecting the Row Labels. On the right, you'll find the blank pivot table that was created in the previous exercise, containing the Top 10 companies by Revenue for 2017.

You will populate the Rows by selecting among the following categories: Name, Headquarters, and Industry.

You'll start by selecting a single Row Label, then removing it, then you'll select multiple Row Labels

この演習はコースの一部です

Google Sheets のピボットテーブル

コースを見る

演習の手順

  • Select Add in the pivot table editor next to the Rows section, and choose Name; this will list the name of each company in the dataset.
  • Now click the X in the upper right section of the Name box in the pivot table editor, this will remove the names.
  • Now select Add and choose Headquarters, select Add again, and choose Industry.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する