{"text_format":"3","workbook":"xlsx","n_sheets":22,"sheets":["Start","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","Learn more"],"not_rendered":{"charts":1,"images":20,"defined_names":1,"pivot_tables":13},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["Welcome\nInstructions for screen readers: Make your first PivotTable. PivotTables are not as hard as you think. After you go through 21 more sheets in this tutorial, you'll learn how to quickly create one. The instructions for each sheet start in cell A1, and each subsequent step is in cell A2, A3, and so on. \nThe instructions will indicate which cells to navigate to for use of a feature, or further reading.\nTo start, press CTRL+PAGE DOWN."]
["Make your first PivotTable"]
["PivotTables are not as hard as you think. After you walk through \nthese simple steps, you'll know how to quickly create one."]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":17,"n_cols":9,"rows_kept":17}
["What is a PivotTable? In its most basic form, a PivotTable takes data and summarizes it so you can make sense of it, all without typing any formulas!"]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells H10 through I14 contain a PivotTable which summarizes the data. The PivotTable has two columns: Buyer and Sum of Amount. The Buyer column contains the values Dad, Mom, Kelly, and Grand Total; The Sum of Amount column contains the values $20, $544, $270, and $834."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Buyer","Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,"Dad",{"v":20,"d":"$20"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,null,"Mom",{"v":544,"d":"$544"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,null,"Kelly",{"v":270,"d":"$270"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,null,"Grand Total",{"v":834,"d":"$834"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"2","index":2,"n_rows":18,"n_cols":11,"rows_kept":18}
["That was a simple example. Here's a more sophisticated one. This one shows the spending amounts broken down by type of purchase and by buyer."]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells G10 through K18 contain a more sophisticated PivotTable which summarizes the data. The PivotTable has five columns: Type, Dad, Kelly, Mom, and Grand Total. The Type column contains the values Books, Food, Fuel, Music, Sports, and Tickets. The Dad, Kelly, and Mom columns contain various dollar amounts, and the Grand Total column contains the total dollar amounts for each Type."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,"Sum of Amount","Buyer"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,"Type","Dad","Kelly","Mom","Grand Total"]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,"Books",null,{"v":125,"d":"$125"},null,{"v":125,"d":"$125"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,"Food",null,null,{"v":470,"d":"$470"},{"v":470,"d":"$470"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,"Fuel",null,null,{"v":74,"d":"$74"},{"v":74,"d":"$74"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"},null,"Music",null,{"v":20,"d":"$20"},null,{"v":20,"d":"$20"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"},null,"Sports",{"v":20,"d":"$20"},null,null,{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"},null,"Tickets",null,{"v":125,"d":"$125"},null,{"v":125,"d":"$125"}]
[{"$nulls":6},"Grand Total",{"v":20,"d":"$20"},{"v":270,"d":"$270"},{"v":544,"d":"$544"},{"v":834,"d":"$834"}]

{"sheet":"3","index":3,"n_rows":18,"n_cols":11,"rows_kept":18}
["There are also PivotCharts, which are a more visual way to summarize and make sense of the data. We won't be covering these, but for now, just know that they're possible to do."]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["To the right of the data is a PivotChart which summarizes and visualizes the data. To select it, press ALT+H, FD, P. Then use your arrows keys to move to PivotChartExample and press Enter. When you're done, press CTRL G, type A4, then Enter."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,"Sum of Amount","Column Labels"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,"Row Labels","Dad","Kelly","Mom","Grand Total"]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,"Books",null,{"v":125,"d":"$125"},null,{"v":125,"d":"$125"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,"Food",null,null,{"v":470,"d":"$470"},{"v":470,"d":"$470"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,"Fuel",null,null,{"v":74,"d":"$74"},{"v":74,"d":"$74"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"},null,"Music",null,{"v":20,"d":"$20"},null,{"v":20,"d":"$20"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"},null,"Sports",{"v":20,"d":"$20"},null,null,{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"},null,"Tickets",null,{"v":125,"d":"$125"},null,{"v":125,"d":"$125"}]
[{"$nulls":6},"Grand Total",{"v":20,"d":"$20"},{"v":270,"d":"$270"},{"v":544,"d":"$544"},{"v":834,"d":"$834"}]

{"sheet":"4","index":4,"n_rows":17,"n_cols":5,"rows_kept":17}
["But let's back up. The first step to making a good PivotTable is to make sure the data is in good shape. So, make sure you do the following before you make one: "]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has values, no duplicates, and no blanks."]
["There is a label pointing to the columns that says, \"Name your columns.\" There is also a label pointing to the rows that says, \"And make sure there are no duplicate rows, or blank cells.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":5,"rows_kept":17}
["Something to keep in mind: Lots of people use the word \"column.\" But to a PivotTable, a column is a \"field.\" Remember this as you progress with the tutorial."]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has a label pointing to it that says \"Field.\""]
["GOOD TO KNOW: Why the word \"field\"? It's just a traditional term used when working with data and database applications. The PivotTable menus and buttons use the word \"field\" a lot. So if you get used to it now, it will make things easier as you make PivotTables. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"6","index":6,"n_rows":17,"n_cols":5,"rows_kept":17}
["Let's focus on one of the fields. One of the fields below, the Amount field, is probably the most important. Wouldn't it be great if it was summed up?"]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. The Amount column has a label pointing to it that says \"This field should be summed up.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"7","index":7,"n_rows":17,"n_cols":8,"rows_kept":17}
["So we did that. We summed up the Amount field with a PivotTable. (Really?) Yes. Sum of Amount and $834 make up a small PivotTable that totals up the Amount field. "]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells H10 and H11 contain a PivotTable which totals the Amount column. The PivotTable has one column: Sum of Amount. And that column only has one value: $834. There is a label pointing to the PivotTable that says, \"It may not look like much, but this is a PivotTable.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,{"v":834,"d":"$834"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":8,"rows_kept":18}
["Why make such a small PivotTable? Because it emphasizes the concept of a PivotTable value field. If one of the fields in your data contains numeric values, a PivotTable can total it up. When it does this, it's called a PivotTable value field."]
["Cells B11 through E18 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row. There is a label pointing to the Amount column that says, \"This field contains numeric values…\""]
["Cells H11 and H12 contain a PivotTable which totals the Amount column. The PivotTable has one column: Sum of Amount. And that column only has one value: $834. There is a label pointing to the PivotTable that says, \"…and this PivotTable made it into a 'value field.'\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,{"v":834,"d":"$834"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"9","index":9,"n_rows":18,"n_cols":9,"rows_kept":18}
["PivotTables start getting interesting when you add conditions that divide or break down the value field. In this case, we added a new condition of Buyer to divide the value field. "]
["Cells B11 through E18 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells H11 through I15 contain a PivotTable which summarizes the data. The PivotTable has two columns: Buyer and Sum of Amount. The Buyer column contains the values Dad, Kelly, Mom, and Grand Total; the Sum of Amount column contains the values $20, $270, $544, and $834. There is a label pointing to the Buyer column that says, \"We added a condition here to divide the value field by 'Buyer.'\" There is also a label that points to the Sum of Amount column that says \"Value field.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Buyer","Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,"Dad",{"v":20,"d":"$20"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,null,"Kelly",{"v":270,"d":"$270"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,null,"Mom",{"v":544,"d":"$544"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,null,"Grand Total",{"v":834,"d":"$834"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"10","index":10,"n_rows":17,"n_cols":9,"rows_kept":17}
["And here's another version of the PivotTable, but this time we added the condition of Type to see how much was spent for each type of purchase."]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells H10 through I17 contain a PivotTable which summarizes the data. The PivotTable has two columns: Type and Sum of Amount. The Type column contains the values Books, Food, Fuel, Music, Sports, Tickets, and Grand Total; the Sum of Amount column contains the values $125, $470, $74, $20, $20, $125, and $834. There is a label pointing to the Type column that says, \"We added a condition here to divide the value field by 'Type.'\" There is also a label that points to the Sum of Amount column that says, \"Value field.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Type","Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,"Books",{"v":125,"d":"$125"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,null,"Food",{"v":470,"d":"$470"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,null,"Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,null,"Music",{"v":20,"d":"$20"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"},null,null,"Sports",{"v":20,"d":"$20"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"},null,null,"Tickets",{"v":125,"d":"$125"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"},null,null,"Grand Total",{"v":834,"d":"$834"}]

{"sheet":"11","index":11,"n_rows":17,"n_cols":9,"rows_kept":17}
["Another PivotTable term: The conditions we've added so far are called PivotTable row fields. In these examples, the row field breaks down, or divides, the value field."]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["Cells H10 through I14 contain a PivotTable which summarizes the data. The PivotTable has two columns: Buyer, and Sum of Amount. The Buyer column contains the values Dad, Kelly, Mom, and Grand Total; the Sum of Amount column contains the values $20, $270, $544, and $834. There is a label pointing to the Buyer column that says, \"Row field.\" There is also a label that points to the Sum of Amount column that says \"Value field.\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Buyer","Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,"Dad",{"v":20,"d":"$20"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,null,"Kelly",{"v":270,"d":"$270"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,null,"Mom",{"v":544,"d":"$544"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,null,"Grand Total",{"v":834,"d":"$834"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"12","index":12,"n_rows":17,"n_cols":9,"rows_kept":17}
["Let's review. You'll learn how to actually make a PivotTable in a few moments. But let's review the concepts we've taught you so far:"]
["Cells B10 through E17 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row. There is a label pointing to the data that says, \"First start with good data.\""]
["Cells H10 through I14 contain a PivotTable which summarizes the data. "]
["The PivotTable has two columns: Buyer, and Sum of Amount. The Buyer column contains the values Dad, Kelly, Mom, and Grand Total. The Sum of Amount column contains the values $20, $270, $544 and $834. There is a label pointing to the Buyer column that says, \"A 'row field' breaks down...\" There is also a label that points to the Sum of Amount column that says, \"...a 'value field.'\""]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[null,"Date","Buyer","Type","Amount",null,null,"Buyer","Sum of Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"},null,null,"Dad",{"v":20,"d":"$20"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"},null,null,"Kelly",{"v":270,"d":"$270"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"},null,null,"Mom",{"v":544,"d":"$544"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"},null,null,"Grand Total",{"v":834,"d":"$834"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"13","index":13,"n_rows":21,"n_cols":6,"rows_kept":21}
["When you create a PivotTable in a moment, you'll see the PivotTable Fields List. It's not just a list though, it's a more like a panel. At the top you'll see the fields from your data. "]
["Cells C14 through F21 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["There is a label pointing to the data fields that says, \"Excel looks at your data...\""]
["There is an arrow that starts at the top of the field names and points to the same field names in a picture of the PivotTable Fields List."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":8}
[null,null,"Date","Buyer","Type","Amount"]
[null,null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"14","index":14,"n_rows":4,"n_cols":1,"rows_kept":4}
["Don't do this now but in a couple steps, you'll work with a PivotTable. The first thing you'll do is create a value field. You'll do that by dragging the Amount field to the Values area."]
["A PivotTable Fields List image shows an arrow cursor dragging the Amount field to the Values area."]
["BEST PRACTICE: In your own situations, if you're ever unsure how to start a PivotTable, think about creating the value field first. Fields that are best for value fields are ones with numerical amounts. In this example, Amount is the best one. The other fields (Date, Buyer, Type) don't contain numerical values, so they aren't the best ones to use for the value field.  \n"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"15","index":15,"n_rows":13,"n_cols":5,"rows_kept":13}
["After you drag the field to the Values area, \"Sum of Am...\" will appear at the bottom of the PivotTable Fields List. (Sometimes Excel doesn't have room to show the full name, which is really \"Sum of Amount.\")"]
["Cells E12 and E13 contain a PivotTable which totals the Amount column. The PivotTable has one column: Sum of Amount. And that column only has one value: $834. There is a label pointing to the PivotTable that says, \"Creating a value field sums up the 'Amount' field and makes a small PivotTable like this.\""]
["PivotTable Fields List image shows \"Sum of Am…\" highlighted in the Values area."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[{"$nulls":4},"Sum of Amount"]
[{"$nulls":4},{"v":834,"d":"$834"}]

{"sheet":"16","index":16,"n_rows":13,"n_cols":5,"rows_kept":13}
["Then you'll want a condition to divide the value field by. And to do that, you drag any of the other fields down to the Rows area. "]
["PivotTable Fields List image shows an arrow cursor dragging the Buyer field to the Rows area. The Rows area is highlighted."]
["Cells E12 and E13 contain a PivotTable which totals the Amount column. The PivotTable has one column: Sum of Amount. And that column only has one value: $834. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[{"$nulls":4},"Sum of Amount"]
[{"$nulls":4},{"v":834,"d":"$834"}]

{"sheet":"17","index":17,"n_rows":16,"n_cols":5,"rows_kept":16}
["Now that the Buyer field is in the Rows area, you'll see that the PivotTable shows each buyer's amount. You'll see how easy this is in a second...and the great part about this is it doesn't require typing any formulas!"]
["Cells D12 and E16 contain a PivotTable. The PivotTable has two columns: Row Labels and Sum of Amount. Row Labels contains the values Dad, Kelly, Mom, and Grand Total. Sum of Amount contains the values $20, $270, $544, and $834. "]
["There is a label pointing to the Row Labels column that says, \"The row field 'Buyer'\"; another label points to the Sum of Amount column that says, \"Divides the value field 'Sum of Amount.'\""]
["A PivotTable Fields List image shows \"Buyer\" highlighted in the Rows area."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"Row Labels","Sum of Amount"]
[{"$nulls":3},"Dad",{"v":20,"d":"$20"}]
[{"$nulls":3},"Kelly",{"v":270,"d":"$270"}]
[{"$nulls":3},"Mom",{"v":544,"d":"$544"}]
[{"$nulls":3},"Grand Total",{"v":834,"d":"$834"}]

{"sheet":"18","index":18,"n_rows":21,"n_cols":8,"rows_kept":21}
["WORK WITH THE PIVOTTABLE FIELDS LIST"]
["Cells B14 through E21 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["1. In cells H14 through J31 is the PivotTable Area. Navigate to any of those cells."]
["2. Press ALT+JT, L to launch the PivotTable Fields List. Focus will default to the Search text box: \"Type words to search for\" edit. Do not type anything, instead, tab once."]
["3. Press your arrow keys to move to the Amount field. Press SPACEBAR to add the Amount field to the Values area. "]
["4. Press arrows keys to move to the Buyer field. Press SPACEBAR to add the Buyer field to the Rows area. Press ESC key to exit PivotTable Fields pane."]
["Note: After you complete steps 3 and 4, you may have to make the columns wider to see all of the text and numbers in the PivotTable. (This is a common \"extra step\" you have to do after creating a PivotTable.)"]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($H$14=\"Buyer\",$I$18=834),\"Good job! You placed the fields correctly.\",\" \")","v":" "}]
[]
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"19","index":19,"n_rows":7,"n_cols":1,"rows_kept":7}
["On the next step, you'll create a PivotTable from scratch. And when you do, there's something to keep in mind: Excel puts PivotTables on a new, separate sheet to the left of the sheet you are on. "]
["There is a picture that shows 4 sheet tabs named 17, 18, 19, 20, and Learn More. 20 is the active tab."]
["There is a caption under the picture that says, \"For example, let's say your data is on a sheet named \"20.\" If you created a PivotTable…\""]
["There is a picture that shows a new sheet tab called \"Sheet12\" that is in between sheet 19 and 20."]
["If you created a PivotTable, Excel would put it on a new sheet to the left. It would name it \"Sheet\" and then assign a number to it like \"12\", \"13,\" etc. You can always select the sheet, Alt+H, O, R, and name it something else like \"PivotTable.\""]
["WHY DOES THIS HAPPEN? Well, the full name for a PivotTable is: \"PivotTable Report.\" A report is based on data, and typically people like to see the reports separately from all of the data itself. Now, it is possible to put PivotTables on the same sheet as the data. But most of the time, PivotTables need a lot of space, so putting them on a new sheet is a good idea."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"20","index":20,"n_rows":22,"n_cols":5,"rows_kept":22}
["MAKE A PIVOTTABLE FROM SCRATCH"]
["Cells B15 through E22 contain Data. There are four columns: Date, Buyer, Type, and Amount. Each column has various values for each row."]
["1. Navigate to any of the data cells."]
["2. Remember that after step 4, a new sheet will be created. And when that happens, remember to use ALT+JT, L to open the PivotTable Fields List if it's not open already. Then add the Amount field to the Values area, and Buyer to the Rows area."]
["3. Press ALT+N,V to access the Create PivotTable dialog box."]
["4. Press ENTER to accept the default options."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-17","Dad","Sports",{"v":20,"d":"$20"}]
[null,"2017-01-21","Kelly","Books",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]

{"sheet":"Learn more","index":21,"n_rows":6,"n_cols":1,"rows_kept":6}
["Good job. You made it."]
["But keep going! There's more to learn…"]
["More Pivot info: Discover more you can do by reading this helpful article on PivotTables."]
["Clean data is key: Excel can help. Check out this article to learn more about Get & Transform."]
["LinkedIn Learning: Video courses for all levels—from beginner to advanced. Take at your own pace."]
["Community: Connect with other Excel fans. They can help you, and you can help them."]