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

{"sheet":"Start","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
["Welcome\nInstructions for screen readers: Get more out of PivotTables. A simple PivotTable gives you an overall summary of your data, but sometimes you need detailed answers to specific questions. That's where adding more column fields and row fields can help. \nThe instructions will indicate which cells to navigate to for use of a feature, or further reading.\nTo start, press CTRL+PAGE DOWN."]
["Get more out of PivotTables"]
["A simple PivotTable gives you an overall summary of your data,\nbut sometimes you need detailed answers to specific questions.\nThat's where adding more column fields and row fields can help."]
["GOOD TO KNOW\nDid you take the first tutorial? If not, go to File > New and find Make your first PivotTable."]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":16,"n_cols":9,"rows_kept":16}
["In the first tutorial, we introduced you to the concept of a PivotTable. We also explained how a row field can be used as a condition that breaks up a value field.   "]
["Cells H10 through I14 contain a PivotTable which summarizes the data in cells B8 to E16. 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 $220, $270, $810, and $1,300. The Buyer column is made up of a Row field, and the Sum of Amount column is made up of 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"]
["This example shows how the row field...","2017-01-01","Dad","Gifts",{"v":95,"d":"$95"}]
["...breaks up the value field.","2017-01-15","Mom","Food",{"v":325,"d":"$325"},null,null,"Buyer","Sum of Amount"]
[null,"2017-01-17","Mom","Tickets",{"v":250,"d":"$250"},null,null,"Dad",{"v":220,"d":"$220"}]
[null,"2017-01-21","Dad","Food",{"v":125,"d":"$125"},null,null,"Kelly",{"v":270,"d":"$270"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"},null,null,"Mom",{"v":810,"d":"$810"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"},null,null,"Grand Total",{"v":1300,"d":"$1,300"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-02-25","Kelly","Sports",{"v":125,"d":"$125"}]

{"sheet":"2","index":2,"n_rows":108,"n_cols":7,"rows_kept":108}
["But when you first look at a PivotTable, you might find that you need more answers out of it."]
["When you first look at a PivotTable, you might have questions like, \"When did these purchases happen?\", \"What did each person spend money on?\", \"What did Mom buy that was so expensive?\"."]
["In this example, cells F11 to G15 show the same two column PivotTable as before. The Buyer column is a Row field, and contains the values Dad, Mom, Kelly, and Grand Total; The Sum of Amount column is the Value field, and contains the values $220, $270, $810, and $1,300. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Buyer","Sum of Amount"]
[{"$nulls":5},"Dad",{"v":220,"d":"$220"}]
[{"$nulls":5},"Kelly",{"v":270,"d":"$270"}]
[{"$nulls":5},"Mom",{"v":810,"d":"$810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"$1,300"}]
{"$rows_empty":84}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",{"v":95,"d":"$95"}]
[null,"2017-01-15","Mom","Food",{"v":325,"d":"$325"}]
[null,"2017-01-17","Mom","Tickets",{"v":250,"d":"$250"}]
[null,"2017-01-21","Dad","Food",{"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"}]
[null,"2017-02-25","Kelly","Sports",{"v":125,"d":"$125"}]

{"sheet":"3","index":3,"n_rows":108,"n_cols":7,"rows_kept":108}
["These are all good questions but for the moment, lets focus on just one question."]
["What did each person spend money on?"]
["For reference, cells F11 to G15 show the same two column PivotTable as before. The Buyer column is a Row field, and contains the values Dad, Mom, Kelly, and Grand Total; The Sum of Amount column is the Value field, and contains the values $220, $270, $810, and $1,300. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Buyer","Sum of Amount"]
[{"$nulls":5},"Dad",{"v":220,"d":"$220"}]
[{"$nulls":5},"Kelly",{"v":270,"d":"$270"}]
[{"$nulls":5},"Mom",{"v":810,"d":"$810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"$1,300"}]
{"$rows_empty":84}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",{"v":95,"d":"$95"}]
[null,"2017-01-15","Mom","Food",{"v":325,"d":"$325"}]
[null,"2017-01-17","Mom","Tickets",{"v":250,"d":"$250"}]
[null,"2017-01-21","Dad","Food",{"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"}]
[null,"2017-02-25","Kelly","Sports",{"v":125,"d":"$125"}]

{"sheet":"4","index":4,"n_rows":108,"n_cols":9,"rows_kept":108}
["The last question we asked was \"What did each person spend money on?\""]
["We answered that question by adding a column field for Type. As a result, the PivotTable now has five new columns that show us the type of purchase made by each person. "]
["Our new PivotTable now goes from cell C10 to I15, with columns for Buyer, Food, Music, Sports, Tickets, Gifts, and Grand Total. The Buyer and Grand Total are the same as before, and the new detail columns are in-between them."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[null,null,"Sum of Amount","Type"]
[null,null,"Buyer","Food","Music","Sports","Tickets","Gifts","Grand Total"]
[null,null,"Dad",{"v":125,"d":"$125"},{"$nulls":3},{"v":95,"d":"$95"},{"v":220,"d":"$220"}]
[null,null,"Kelly",null,{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":125,"d":"$125"},null,{"v":270,"d":"$270"}]
[null,null,"Mom",{"v":560,"d":"$560"},null,null,{"v":250,"d":"$250"},null,{"v":810,"d":"$810"}]
[null,null,"Grand Total",{"v":685,"d":"$685"},{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":375,"d":"$375"},{"v":95,"d":"$95"},{"v":1300,"d":"$1,300"}]
{"$rows_empty":84}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",{"v":95,"d":"$95"}]
[null,"2017-01-15","Mom","Food",{"v":325,"d":"$325"}]
[null,"2017-01-17","Mom","Tickets",{"v":250,"d":"$250"}]
[null,"2017-01-21","Dad","Food",{"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"}]
[null,"2017-02-25","Kelly","Sports",{"v":125,"d":"$125"}]

{"sheet":"5","index":5,"n_rows":108,"n_cols":9,"rows_kept":108}
["If the PivotTable is hard to understand, try this: Read from the left, then from the top, and then down. In example below, Dad is in cell C12, Food for $125 in cell D12, Gifts for $95 in cell E12, and a Grand Total of $220 in cell I12. Rows 13 and 14 show the details for Kelly and Mom, and row 15 shows the Grand Total."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,"Sum of Amount","Type"]
[null,null,"Buyer","Food","Gifts","Music","Sports","Tickets","Grand Total"]
[null,null,"Dad",{"v":125,"d":"$125"},{"v":95,"d":"$95"},{"$nulls":3},{"v":220,"d":"$220"}]
[null,null,"Kelly",null,null,{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":125,"d":"$125"},{"v":270,"d":"$270"}]
[null,null,"Mom",{"v":560,"d":"$560"},{"$nulls":3},{"v":250,"d":"$250"},{"v":810,"d":"$810"}]
[null,null,"Grand Total",{"v":685,"d":"$685"},{"v":95,"d":"$95"},{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":375,"d":"$375"},{"v":1300,"d":"$1,300"}]
{"$rows_empty":84}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",95]
[null,"2017-01-15","Mom","Food",325]
[null,"2017-01-17","Mom","Tickets",250]
[null,"2017-01-21","Dad","Food",125]
[null,"2017-02-02","Mom","Food",235]
[null,"2017-02-20","Kelly","Music",20]
[null,"2017-02-25","Kelly","Tickets",125]
[null,"2017-02-25","Kelly","Sports",125]

{"sheet":"6","index":6,"n_rows":3,"n_cols":1,"rows_kept":3}
["Don't do this now but in a couple steps, you'll work with a PivotTable. The first thing you'll do is create detail in the Columns field. You'll do that by placing the Type field in the Columns field area."]
["A PivotTable Fields List image shows an arrow cursor dragging the Type field to the Columns area."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"7","index":7,"n_rows":108,"n_cols":8,"rows_kept":108}
["1. The PivotTable Area for this example is in cells B13 through C17. 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: \"Search\" edit"]
["3. Press your arrow keys to select the Type field. Once selected, press SPACEBAR to add the Type field to the Rows area. "]
["4. Press Tab to select the Type field. Press Enter, then press arrow keys to select Move to Column Labels and press Enter to add the Type field to Columns area. Press SHIFT+F6 to exit the PivotTable Fields pane."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Buyer\",$H$17=810),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Buyer\",$H$17=810),\"your first column field.\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"Buyer\",$H$17=810),\"Click Next to continue...\",\" \")","v":" "}]
[]
[null,"Buyer","Sum of Amount"]
[null,"Dad",{"v":220,"d":"$220"}]
[null,"Kelly",{"v":270,"d":"$270"}]
[null,"Mom",{"v":810,"d":"$810"}]
[null,"Grand Total",{"v":1300,"d":"$1,300"}]
{"$rows_empty":82}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",95]
[null,"2017-01-15","Mom","Food",325]
[null,"2017-01-17","Mom","Tickets",250]
[null,"2017-01-21","Dad","Food",125]
[null,"2017-02-02","Mom","Food",235]
[null,"2017-02-20","Kelly","Music",20]
[null,"2017-02-25","Kelly","Tickets",125]
[null,"2017-02-25","Kelly","Sports",125]

{"sheet":"8","index":8,"n_rows":108,"n_cols":9,"rows_kept":108}
["Let's review the PivotTable you just made, but this time we've added some special colors to differentiate the row, column, and value fields."]
["The row field goes from cell C10 to C13, and is shaded in yellow."]
["The column field goes from cell D9 to H10, and is shaded in orange."]
["The value field goes from cell D11 to H13, and is shaded in blue."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,null,"Sum of Amount","Type"]
[null,null,"Buyer","Food","Gifts","Music","Sports","Tickets","Grand Total"]
[null,null,"Dad",{"v":125,"d":"$125"},{"v":95,"d":"$95"},{"$nulls":3},{"v":220,"d":"$220"}]
[null,null,"Kelly",null,null,{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":125,"d":"$125"},{"v":270,"d":"$270"}]
[null,null,"Mom",{"v":560,"d":"$560"},{"$nulls":3},{"v":250,"d":"$250"},{"v":810,"d":"$810"}]
[null,null,"Grand Total",{"v":685,"d":"$685"},{"v":95,"d":"$95"},{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":375,"d":"$375"},1300]
{"$rows_empty":85}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-01","Dad","Gifts",95]
[null,"2017-01-15","Mom","Food",325]
[null,"2017-01-17","Mom","Tickets",250]
[null,"2017-01-21","Dad","Food",125]
[null,"2017-02-02","Mom","Food",235]
[null,"2017-02-20","Kelly","Music",20]
[null,"2017-02-25","Kelly","Tickets",125]
[null,"2017-02-25","Kelly","Sports",125]

{"sheet":"9","index":9,"n_rows":3,"n_cols":1,"rows_kept":3}
["Here's another way to think about it: The row field is on the left, and the column field at the top. Each of these provide a condition to the value field, which sums them up."]
["A conceptual image shows a 4-section rectangular area with the Row field on the bottom-left in yellow, the Column field on the top-right in orange, and the Value field on the bottom-right in blue."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"10","index":10,"n_rows":3,"n_cols":1,"rows_kept":3}
["Think of it that way when using the fields list. The row field is on the left, and the column field at the top. Each of these provide a condition to the value field, which sums them up."]
["A conceptual image shows the PivotTable Field List displayed with the Row field on the bottom-left in yellow, the Column field on the top-right in orange, and the Value field on the bottom-right in blue."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"11","index":11,"n_rows":121,"n_cols":24,"rows_kept":121}
["One thing to be aware of: If a column field adds a lot of columns to a PivotTable, it will make it very wide. "]
["In this example, the PivotTable now ranges from cell C10 to X15, as the column field added 20 new columns. That's a lot of columns! This will cause people to scroll a lot..."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,null,"Sum of Amount","Type"]
[null,null,"Buyer","Books","Food","Fuel","Music","Sports","Tickets","Dining","Electricity","Medical","Dental","Taxes","Auto insurance","Parking","Electronics","Airfare","Clothes","Music lessons","Club dues","Health insurance","Home insurance","Grand Total"]
[null,null,"Dad",{"$nulls":4},{"v":1000,"d":"$1,000"},{"$nulls":5},{"v":500,"d":"$500"},{"$nulls":3},{"v":500,"d":"$500"},{"$nulls":5},{"v":2000,"d":"$2,000"}]
[null,null,"Kelly",{"v":250,"d":"$250"},null,null,{"v":20,"d":"$20"},null,{"v":125,"d":"$125"},{"v":20,"d":"$20"},{"$nulls":5},{"v":20,"d":"$20"},{"v":125,"d":"$125"},null,{"v":125,"d":"$125"},{"v":250,"d":"$250"},{"$nulls":3},{"v":935,"d":"$935"}]
[null,null,"Mom",null,{"v":470,"d":"$470"},{"v":74,"d":"$74"},{"$nulls":4},{"v":70,"d":"$70"},{"v":74,"d":"$74"},{"v":235,"d":"$235"},null,{"v":74,"d":"$74"},{"$nulls":5},{"v":125,"d":"$125"},{"v":70,"d":"$70"},{"v":235,"d":"$235"},{"v":1427,"d":"$1,427"}]
[null,null,"Grand Total",{"v":250,"d":"$250"},{"v":470,"d":"$470"},{"v":74,"d":"$74"},{"v":20,"d":"$20"},{"v":1000,"d":"$1,000"},{"v":125,"d":"$125"},{"v":20,"d":"$20"},{"v":70,"d":"$70"},{"v":74,"d":"$74"},{"v":235,"d":"$235"},{"v":500,"d":"$500"},{"v":74,"d":"$74"},{"v":20,"d":"$20"},{"v":125,"d":"$125"},{"v":500,"d":"$500"},{"v":125,"d":"$125"},{"v":250,"d":"$250"},{"v":125,"d":"$125"},{"v":70,"d":"$70"},{"v":235,"d":"$235"},{"v":4362,"d":"$4,362"}]
{"$rows_empty":84}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-17","Dad","Sports",{"v":1000,"d":"$1,000"}]
[null,"2017-01-17","Dad","Airfare",{"v":500,"d":"$500"}]
[null,"2017-01-17","Dad","Taxes",{"v":500,"d":"$500"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Books",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Dining",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Clothes",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Music lessons",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Parking",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Electronics",{"v":125,"d":"$125"}]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-21","Mom","Club dues",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Medical",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Electricity",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Dental",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Auto insurance",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Health insurance",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Home insurance",{"v":235,"d":"$235"}]

{"sheet":"12","index":12,"n_rows":119,"n_cols":5,"rows_kept":119}
["There is an alternative to extra-wide PivotTables: you can use a second row field instead. A second row field will appear indented under the first row field."]
["In this example, there is a PivotTable from cell D8 to E32. It shows Dad, Kelly, and Mom as first row fields in column D. Then the spending types are beneath them as second row fields with items such as Sports, Airfare, Dining, etc."]
["GOOD TO KNOW\nA second row field makes a vertically-oriented PivotTable rather than horizontal. Some people find vertical PivotTables easer to read because they don't require as much scrolling from side-to-side."]
["EXCEL SPEAK\nSometimes people call a second row field a \"secondary row field.\""]
["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":2000,"d":"$2,000"}]
[{"$nulls":3},"Sports",{"v":1000,"d":"$1,000"}]
[{"$nulls":3},"Taxes",{"v":500,"d":"$500"}]
[{"$nulls":3},"Airfare",{"v":500,"d":"$500"}]
[{"$nulls":3},"Kelly",{"v":935,"d":"$935"}]
[{"$nulls":3},"Books",{"v":250,"d":"$250"}]
[{"$nulls":3},"Music",{"v":20,"d":"$20"}]
[{"$nulls":3},"Tickets",{"v":125,"d":"$125"}]
[{"$nulls":3},"Dining",{"v":20,"d":"$20"}]
[{"$nulls":3},"Parking",{"v":20,"d":"$20"}]
[{"$nulls":3},"Electronics",{"v":125,"d":"$125"}]
[{"$nulls":3},"Clothes",{"v":125,"d":"$125"}]
[{"$nulls":3},"Music lessons",{"v":250,"d":"$250"}]
[{"$nulls":3},"Mom",{"v":1427,"d":"$1,427"}]
[{"$nulls":3},"Food",{"v":470,"d":"$470"}]
[{"$nulls":3},"Fuel",{"v":74,"d":"$74"}]
[{"$nulls":3},"Electricity",{"v":70,"d":"$70"}]
[{"$nulls":3},"Medical",{"v":74,"d":"$74"}]
[{"$nulls":3},"Dental",{"v":235,"d":"$235"}]
[{"$nulls":3},"Auto insurance",{"v":74,"d":"$74"}]
[{"$nulls":3},"Club dues",{"v":125,"d":"$125"}]
[{"$nulls":3},"Health insurance",{"v":70,"d":"$70"}]
[{"$nulls":3},"Home insurance",{"v":235,"d":"$235"}]
[{"$nulls":3},"Grand Total",{"v":4362,"d":"$4,362"}]
{"$rows_empty":65}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-17","Dad","Sports",{"v":1000,"d":"$1,000"}]
[null,"2017-01-17","Dad","Airfare",{"v":500,"d":"$500"}]
[null,"2017-01-17","Dad","Taxes",{"v":500,"d":"$500"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Books",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Dining",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Clothes",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Music lessons",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Parking",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Electronics",{"v":125,"d":"$125"}]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-21","Mom","Club dues",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Medical",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Electricity",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Dental",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Auto insurance",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Health insurance",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Home insurance",{"v":235,"d":"$235"}]

{"sheet":"13","index":13,"n_rows":3,"n_cols":1,"rows_kept":3}
["On the next sheet you'll add a second row field. And you'll do that by placing the Type field under the Buyer field in the Rows field."]
["A PivotTable Fields List image shows an arrow cursor dragging the Type field to the Rows area."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]

{"sheet":"14","index":14,"n_rows":122,"n_cols":9,"rows_kept":122}
["1. The PivotTable Area for this example is in cells B13 through C17. 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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Press your arrow keys to move to the Type field. Press SPACEBAR to add the Type field to the Rows area. "]
["4. Press ESC key to exit PivotTable Fields pane. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP.",{"$nulls":7},{"$f":"IF(AND($B$15=\"Airfare\",$C$36=74),\"Nice going! You added\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Airfare\",$C$36=74),\"a second row field to\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Airfare\",$C$36=74),\"the PivotTable. Scroll \",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"Airfare\",$C$36=74),\"down and click Next...\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Row Labels","Sum of Amount"]
[null,"Dad",{"v":2000,"d":"$2,000"}]
[null,"Kelly",{"v":935,"d":"$935"}]
[null,"Mom",{"v":1427,"d":"$1,427"}]
[null,"Grand Total",{"v":4362,"d":"$4,362"}]
{"$rows_empty":83}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-17","Dad","Sports",{"v":1000,"d":"$1,000"}]
[null,"2017-01-17","Dad","Airfare",{"v":500,"d":"$500"}]
[null,"2017-01-17","Dad","Taxes",{"v":500,"d":"$500"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Books",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Dining",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Clothes",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Music lessons",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Parking",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Electronics",{"v":125,"d":"$125"}]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-21","Mom","Club dues",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Medical",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Electricity",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Dental",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Auto insurance",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Health insurance",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Home insurance",{"v":235,"d":"$235"}]

{"sheet":"15","index":15,"n_rows":121,"n_cols":7,"rows_kept":121}
["If you need to simplify the PivotTable, you can collapse the data for the second row field \"up\" and out of the way. "]
["The PivotTable for this example is in cells F7 to G31. Select cell F8 to choose the first row field for Dad. Next, press Alt+JT > E to expand the second field, or X to collapse it."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kelly\",$G$9=935),\"Nice!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Sum of Amount"]
[{"$nulls":5},"Dad",{"v":2000,"d":"$2,000"}]
[{"$nulls":5},"Sports",{"v":1000,"d":"$1,000"}]
[{"$nulls":5},"Taxes",{"v":500,"d":"$500"}]
[{"$nulls":5},"Airfare",{"v":500,"d":"$500"}]
[{"$nulls":5},"Kelly",{"v":935,"d":"$935"}]
[{"$nulls":5},"Books",{"v":250,"d":"$250"}]
[{"$nulls":5},"Dining",{"v":20,"d":"$20"}]
[{"$nulls":5},"Electronics",{"v":125,"d":"$125"}]
[{"$nulls":5},"Music",{"v":20,"d":"$20"}]
[{"$nulls":5},"Parking",{"v":20,"d":"$20"}]
[{"$nulls":5},"Tickets",{"v":125,"d":"$125"}]
[{"$nulls":5},"Clothes",{"v":125,"d":"$125"}]
[{"$nulls":5},"Music lessons",{"v":250,"d":"$250"}]
[{"$nulls":5},"Mom",{"v":1427,"d":"$1,427"}]
[{"$nulls":5},"Auto insurance",{"v":74,"d":"$74"}]
[{"$nulls":5},"Dental",{"v":235,"d":"$235"}]
[{"$nulls":5},"Electricity",{"v":70,"d":"$70"}]
[{"$nulls":5},"Food",{"v":470,"d":"$470"}]
[{"$nulls":5},"Fuel",{"v":74,"d":"$74"}]
[{"$nulls":5},"Medical",{"v":74,"d":"$74"}]
[{"$nulls":5},"Club dues",{"v":125,"d":"$125"}]
[{"$nulls":5},"Health insurance",{"v":70,"d":"$70"}]
[{"$nulls":5},"Home insurance",{"v":235,"d":"$235"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"$4,362"}]
{"$rows_empty":68}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-17","Dad","Sports",{"v":1000,"d":"$1,000"}]
[null,"2017-01-17","Dad","Airfare",{"v":500,"d":"$500"}]
[null,"2017-01-17","Dad","Taxes",{"v":500,"d":"$500"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Books",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Dining",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Clothes",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Music lessons",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Parking",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Electronics",{"v":125,"d":"$125"}]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-21","Mom","Club dues",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Medical",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Electricity",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Dental",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Auto insurance",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Health insurance",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Home insurance",{"v":235,"d":"$235"}]

{"sheet":"16","index":16,"n_rows":121,"n_cols":7,"rows_kept":121}
["You can also collapse or expand the entire second row field, to simplify the PivotTable even more."]
["Here's the Key"]
["Select the PivotTable data range from cells F7 to G31, then go to ALT+JT > P to collapse the entire group. Converseley, ALT+JT > X will expand the entire group."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"Kelly\",$G$9=935),\"Right on!\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","Sum of Amount"]
[{"$nulls":5},"Dad",{"v":2000,"d":"$2,000"}]
[{"$nulls":5},"Sports",{"v":1000,"d":"$1,000"}]
[{"$nulls":5},"Taxes",{"v":500,"d":"$500"}]
[{"$nulls":5},"Airfare",{"v":500,"d":"$500"}]
[{"$nulls":5},"Kelly",{"v":935,"d":"$935"}]
[{"$nulls":5},"Books",{"v":250,"d":"$250"}]
[{"$nulls":5},"Dining",{"v":20,"d":"$20"}]
[{"$nulls":5},"Electronics",{"v":125,"d":"$125"}]
[{"$nulls":5},"Music",{"v":20,"d":"$20"}]
[{"$nulls":5},"Parking",{"v":20,"d":"$20"}]
[{"$nulls":5},"Tickets",{"v":125,"d":"$125"}]
[{"$nulls":5},"Clothes",{"v":125,"d":"$125"}]
[{"$nulls":5},"Music lessons",{"v":250,"d":"$250"}]
[{"$nulls":5},"Mom",{"v":1427,"d":"$1,427"}]
[{"$nulls":5},"Auto insurance",{"v":74,"d":"$74"}]
[{"$nulls":5},"Dental",{"v":235,"d":"$235"}]
[{"$nulls":5},"Electricity",{"v":70,"d":"$70"}]
[{"$nulls":5},"Food",{"v":470,"d":"$470"}]
[{"$nulls":5},"Fuel",{"v":74,"d":"$74"}]
[{"$nulls":5},"Medical",{"v":74,"d":"$74"}]
[{"$nulls":5},"Club dues",{"v":125,"d":"$125"}]
[{"$nulls":5},"Health insurance",{"v":70,"d":"$70"}]
[{"$nulls":5},"Home insurance",{"v":235,"d":"$235"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"$4,362"}]
{"$rows_empty":68}
[null,"Date","Buyer","Type","Amount"]
[null,"2017-01-17","Dad","Sports",{"v":1000,"d":"$1,000"}]
[null,"2017-01-17","Dad","Airfare",{"v":500,"d":"$500"}]
[null,"2017-01-17","Dad","Taxes",{"v":500,"d":"$500"}]
[null,"2017-02-20","Kelly","Music",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Tickets",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Books",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Dining",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Clothes",{"v":125,"d":"$125"}]
[null,"2017-01-21","Kelly","Music lessons",{"v":250,"d":"$250"}]
[null,"2017-02-20","Kelly","Parking",{"v":20,"d":"$20"}]
[null,"2017-02-25","Kelly","Electronics",{"v":125,"d":"$125"}]
[null,"2017-01-01","Mom","Fuel",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-21","Mom","Club dues",{"v":125,"d":"$125"}]
[null,"2017-02-02","Mom","Food",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Medical",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Electricity",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Dental",{"v":235,"d":"$235"}]
[null,"2017-01-01","Mom","Auto insurance",{"v":74,"d":"$74"}]
[null,"2017-01-15","Mom","Health insurance",{"v":70,"d":"$70"}]
[null,"2017-02-02","Mom","Home insurance",{"v":235,"d":"$235"}]

{"sheet":"17","index":17,"n_rows":107,"n_cols":13,"rows_kept":107}
["You can also have more than one column field. They can also be collapsed or expanded."]
["The PivotTable for this example goes from cells B13 to M19. In this case, we have a Type category in the Columns section, which include items for Food and Utilities."]
["TRY THIS\nSelect Food in cell C14 and go to ALT+JT > P to collapse the entire field. ALT+JT > X will expand it."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
{"$rows_empty":7}
[null,null,{"$f":"IF(AND($C$16=398,$D$15=\"Jan\"),\"Nice job!\",\" \")","v":" "}]
[null,"Sum of Amount","Column Labels"]
[null,null,"Food",{"$nulls":3},"Food Total","Utilities",{"$nulls":3},"Utilities Total","Grand Total"]
[null,"Row Labels","Jan","Feb","Mar","Apr",null,"Jan","Feb","Mar","Apr"]
[null,"Kelly",{"v":74,"d":"$74"},{"v":74,"d":"$74"},{"v":125,"d":"$125"},{"v":125,"d":"$125"},{"v":398,"d":"$398"},{"$nulls":5},{"v":398,"d":"$398"}]
[null,"Dad",{"v":235,"d":"$235"},{"v":235,"d":"$235"},{"v":235,"d":"$235"},{"v":74,"d":"$74"},{"v":779,"d":"$779"},{"$nulls":5},{"v":779,"d":"$779"}]
[null,"Mom",{"$nulls":5},{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":20,"d":"$20"},{"v":70,"d":"$70"},{"v":2090,"d":"$2,090"},{"v":2090,"d":"$2,090"}]
[null,"Grand Total",{"v":309,"d":"$309"},{"v":309,"d":"$309"},{"v":360,"d":"$360"},{"v":199,"d":"$199"},{"v":1177,"d":"$1,177"},{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":20,"d":"$20"},{"v":70,"d":"$70"},{"v":2090,"d":"$2,090"},{"v":3267,"d":"$3,267"}]
{"$rows_empty":75}
[null,"Month","Buyer","Type","Amount"]
[null,"Jan","Kelly","Food",{"v":74,"d":"$74"}]
[null,"Jan","Dad","Food",{"v":235,"d":"$235"}]
[null,"Jan","Mom","Utilities",{"v":1000,"d":"$1,000"}]
[null,"Feb","Kelly","Food",{"v":74,"d":"$74"}]
[null,"Feb","Dad","Food",{"v":235,"d":"$235"}]
[null,"Feb","Mom","Utilities",{"v":1000,"d":"$1,000"}]
[null,"Mar","Kelly","Food",{"v":125,"d":"$125"}]
[null,"Mar","Dad","Food",{"v":235,"d":"$235"}]
[null,"Mar","Mom","Utilities",{"v":20,"d":"$20"}]
[null,"Apr","Kelly","Food",{"v":125,"d":"$125"}]
[null,"Apr","Dad","Food",{"v":74,"d":"$74"}]
[null,"Apr","Mom","Utilities",{"v":70,"d":"$70"}]

{"sheet":"18","index":18,"n_rows":146,"n_cols":5,"rows_kept":146}
["Something to keep in mind: If you need more detail, it's possible to add many more row fields or columns fields. In this example, there are three row fields."]
["The PivotTable for this example ranges from cell D8 to E29, and has fields for Season, Buyer, and Type in column D, with Sum of Amount in column E."]
["EXPERT TIP\nJust because you can add a bunch of fields, doesn't mean you should. In this example, it works fine. But sometimes too many fields, with all of their indentations, can make the PivotTable too complicated for other people to understand. "]
["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},"Fall",{"v":5425,"d":"$5,425"}]
[{"$nulls":3},"Mom",{"v":5425,"d":"$5,425"}]
[{"$nulls":3},"Insurance",{"v":1272,"d":"$1,272"}]
[{"$nulls":3},"Rent",{"v":3220,"d":"$3,220"}]
[{"$nulls":3},"Utilities",{"v":933,"d":"$933"}]
[{"$nulls":3},"Spring",{"v":4760,"d":"$4,760"}]
[{"$nulls":3},"Dad",{"v":4760,"d":"$4,760"}]
[{"$nulls":3},"Insurance",{"v":1040,"d":"$1,040"}]
[{"$nulls":3},"Rent",{"v":2400,"d":"$2,400"}]
[{"$nulls":3},"Utilities",{"v":1320,"d":"$1,320"}]
[{"$nulls":3},"Summer",{"v":3473,"d":"$3,473"}]
[{"$nulls":3},"Mom",{"v":3473,"d":"$3,473"}]
[{"$nulls":3},"Insurance",{"v":1080,"d":"$1,080"}]
[{"$nulls":3},"Rent",{"v":1260,"d":"$1,260"}]
[{"$nulls":3},"Utilities",{"v":1133,"d":"$1,133"}]
[{"$nulls":3},"Winter",{"v":4100,"d":"$4,100"}]
[{"$nulls":3},"Dad",{"v":4100,"d":"$4,100"}]
[{"$nulls":3},"Insurance",{"v":1030,"d":"$1,030"}]
[{"$nulls":3},"Rent",{"v":1420,"d":"$1,420"}]
[{"$nulls":3},"Utilities",{"v":1650,"d":"$1,650"}]
[{"$nulls":3},"Grand Total",{"v":17758,"d":"$17,758"}]
{"$rows_empty":68}
[null,"Buyer","Season","Type","Amount"]
[null,"Dad","Winter","Insurance",{"v":300,"d":"$300"}]
[null,"Dad","Winter","Rent",{"v":200,"d":"$200"}]
[null,"Dad","Winter","Utilities",{"v":400,"d":"$400"}]
[null,"Dad","Winter","Insurance",{"v":300,"d":"$300"}]
[null,"Dad","Winter","Rent",{"v":800,"d":"$800"}]
[null,"Dad","Winter","Utilities",{"v":400,"d":"$400"}]
[null,"Dad","Winter","Insurance",{"v":200,"d":"$200"}]
[null,"Dad","Winter","Rent",{"v":300,"d":"$300"}]
[null,"Dad","Winter","Utilities",{"v":450,"d":"$450"}]
[null,"Dad","Winter","Insurance",{"v":230,"d":"$230"}]
[null,"Dad","Winter","Rent",{"v":120,"d":"$120"}]
[null,"Dad","Winter","Utilities",{"v":400,"d":"$400"}]
[null,"Dad","Spring","Insurance",{"v":210,"d":"$210"}]
[null,"Dad","Spring","Rent",{"v":300,"d":"$300"}]
[null,"Dad","Spring","Utilities",{"v":400,"d":"$400"}]
[null,"Dad","Spring","Insurance",{"v":230,"d":"$230"}]
[null,"Dad","Spring","Rent",{"v":900,"d":"$900"}]
[null,"Dad","Spring","Utilities",{"v":300,"d":"$300"}]
[null,"Dad","Spring","Insurance",{"v":200,"d":"$200"}]
[null,"Dad","Spring","Rent",{"v":1000,"d":"$1,000"}]
[null,"Dad","Spring","Utilities",{"v":220,"d":"$220"}]
[null,"Dad","Spring","Insurance",{"v":400,"d":"$400"}]
[null,"Dad","Spring","Rent",{"v":200,"d":"$200"}]
[null,"Dad","Spring","Utilities",{"v":400,"d":"$400"}]
[null,"Mom","Summer","Insurance",{"v":100,"d":"$100"}]
[null,"Mom","Summer","Rent",{"v":30,"d":"$30"}]
[null,"Mom","Summer","Utilities",{"v":123,"d":"$123"}]
[null,"Mom","Summer","Insurance",{"v":300,"d":"$300"}]
[null,"Mom","Summer","Rent",{"v":350,"d":"$350"}]
[null,"Mom","Summer","Utilities",{"v":230,"d":"$230"}]
[null,"Mom","Summer","Insurance",{"v":120,"d":"$120"}]
[null,"Mom","Summer","Rent",{"v":640,"d":"$640"}]
[null,"Mom","Summer","Utilities",{"v":530,"d":"$530"}]
[null,"Mom","Summer","Insurance",{"v":560,"d":"$560"}]
[null,"Mom","Summer","Rent",{"v":240,"d":"$240"}]
[null,"Mom","Summer","Utilities",{"v":250,"d":"$250"}]
[null,"Mom","Fall","Insurance",{"v":62,"d":"$62"}]
[null,"Mom","Fall","Rent",{"v":600,"d":"$600"}]
[null,"Mom","Fall","Utilities",{"v":340,"d":"$340"}]
[null,"Mom","Fall","Insurance",{"v":205,"d":"$205"}]
[null,"Mom","Fall","Rent",{"v":500,"d":"$500"}]
[null,"Mom","Fall","Utilities",{"v":403,"d":"$403"}]
[null,"Mom","Fall","Insurance",{"v":503,"d":"$503"}]
[null,"Mom","Fall","Rent",{"v":2000,"d":"$2,000"}]
[null,"Mom","Fall","Utilities",{"v":140,"d":"$140"}]
[null,"Mom","Fall","Insurance",{"v":502,"d":"$502"}]
[null,"Mom","Fall","Rent",{"v":120,"d":"$120"}]
[null,"Mom","Fall","Utilities",{"v":50,"d":"$50"}]

{"sheet":"19","index":19,"n_rows":55,"n_cols":5,"rows_kept":55}
["Ready for more practice? Take a chance to review the data below in cells B7 to E55. When you're ready, go to the next sheet and you'll practice what you've learned so far. "]
["There's no need to review all the rows of data. Just review field names in the row 7. You'll be working with these on the next sheet. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[]
[]
[null,"Season","Sales rep","Product","Units sold"]
[null,"Winter","Jenny","Oranges",300]
[null,"Winter","George","Grapefruit",200]
[null,"Winter","Dave","Apples",400]
[null,"Winter","Jenny","Bananas",300]
[null,"Winter","George","Oranges",800]
[null,"Winter","Dave","Grapefruit",400]
[null,"Winter","Jenny","Apples",200]
[null,"Winter","George","Bananas",300]
[null,"Winter","Dave","Oranges",450]
[null,"Winter","Jenny","Grapefruit",230]
[null,"Winter","George","Apples",120]
[null,"Winter","Dave","Bananas",400]
[null,"Spring","Jenny","Beets",210]
[null,"Spring","George","Potatoes",300]
[null,"Spring","Dave","Lettuce",400]
[null,"Spring","Jenny","Radishes",230]
[null,"Spring","George","Beets",900]
[null,"Spring","Dave","Potatoes",300]
[null,"Spring","Jenny","Lettuce",200]
[null,"Spring","George","Radishes",1000]
[null,"Spring","Dave","Beets",220]
[null,"Spring","Jenny","Potatoes",400]
[null,"Spring","George","Lettuce",200]
[null,"Spring","Dave","Radishes",400]
[null,"Summer","Jenny","Blueberries",100]
[null,"Summer","George","Strawberries",30]
[null,"Summer","Dave","Grapes",123]
[null,"Summer","Jenny","Pumpkins",300]
[null,"Summer","George","Blueberries",350]
[null,"Summer","Dave","Strawberries",230]
[null,"Summer","Jenny","Grapes",120]
[null,"Summer","George","Pumpkins",640]
[null,"Summer","Dave","Blueberries",530]
[null,"Summer","Jenny","Strawberries",560]
[null,"Summer","George","Grapes",240]
[null,"Summer","Dave","Pumpkins",250]
[null,"Fall","Jenny","Squash",62]
[null,"Fall","George","Zucchini",600]
[null,"Fall","Dave","Apples",340]
[null,"Fall","Jenny","Oranges",205]
[null,"Fall","George","Squash",500]
[null,"Fall","Dave","Zucchini",403]
[null,"Fall","Jenny","Apples",503]
[null,"Fall","George","Oranges",2000]
[null,"Fall","Dave","Squash",140]
[null,"Fall","Jenny","Zucchini",502]
[null,"Fall","George","Apples",120]
[null,"Fall","Dave","Oranges",50]

{"sheet":"20","index":20,"n_rows":17,"n_cols":11,"rows_kept":17}
["1. The PivotTable Area for this example is in cells B12 through C17. Navigate to any of those cells. \n\n"]
["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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Press your arrow keys to move to the Sales Rep field. Press SPACEBAR to add the Sales Rep field to the Rows area. If you want to display Sales Rep details in the Columns area, use your Tab keys to move to the Sales Rep field in the Row section, then press SPACEBAR, and select \"Move to Column Labels\". Press ESC key to exit PivotTable Fields pane. "]
["4. Determine who sold the most items in the fall, then make a selection in cell K8. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[{"$nulls":10},"Pick one:"]
[]
[{"$nulls":10},{"$f":"IF($K$8=\"George\",\"You're right!\",IF($K$8=\"Dave\",\"Try again...\",IF($K$8=\"Jenny\",\"Not quite...\",IF($K$8=\" \",\" \",\" \"))))","v":" "}]
[]
[]
[null,"Row Labels","Sum of Units sold"]
[null,"Fall",{"v":5425,"d":"5,425 "}]
[null,"Spring",{"v":4760,"d":"4,760 "}]
[null,"Summer",{"v":3473,"d":"3,473 "}]
[null,"Winter",{"v":4100,"d":"4,100 "}]
[null,"Grand Total",{"v":17758,"d":"17,758 "}]

{"sheet":"21","index":21,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Click cell B14 to activate the PivotTable named \"Sum of Units sold\".\n\n"]
["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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Use your arrow and SPACEBAR keys to expand the example into a vertical PivotTable that has seasons on the left, and the sales reps indented under the seasons.Press ESC key to exit PivotTable Fields pane. "]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP.",{"$nulls":8},{"$f":"IF(AND($B$14=\"Buyer\",$I$18=1175),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Fall\",$C$17=1272),\"Good job! You placed a\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Fall\",$C$17=1272),\"secondary row field. Now\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"Fall\",$C$17=1272),\"scroll down and click Next.\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,"Sum of Units sold"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"22","index":22,"n_rows":14,"n_cols":10,"rows_kept":14}
["1. Click cell B14 to activate the PivotTable named \"Sum of Units sold\"."]
["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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Use your arrow and SPACEBAR keys to modify the example so that it shows each product in its own row, and each season in its own column."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP.",{"$nulls":8},{"$f":"IF(AND($B$15=\"Apples\",$G$28=1505),\"Good job! You placed\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apples\",$G$28=1505),\"a row field on the left,\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apples\",$G$28=1505),\"and a column field with\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apples\",$G$28=1505),\"four new columns. Scroll\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"Apples\",$G$28=1505),\"down and click Next...\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Sum of Units sold"]
[null,{"v":17758,"d":"17,758"}]

{"sheet":"23","index":23,"n_rows":16,"n_cols":18,"rows_kept":16}
["1. Click cell B13 to activate the PivotTable named \"Sum of Units sold\".\n\n"]
["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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Use your Tab, arrow and SPACEBAR keys to modify the example so that it shows Sales Reps on the left with Seasons indented beneath them."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Dave\",$C$14=5036),\"Good job! Now the data is\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Dave\",$C$14=5036),\"easier to read. Scroll down\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"Dave\",$C$14=5036),\"and click Next...\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,null,"Column Labels"]
[null,null,"Dave",{"$nulls":3},"Dave Total","George",{"$nulls":3},"George Total","Jenny",{"$nulls":3},"Jenny Total","Grand Total"]
[null,null,"Fall","Spring","Summer","Winter",null,"Fall","Spring","Summer","Winter",null,"Fall","Spring","Summer","Winter"]
[null,"Sum of Units sold",{"v":933,"d":"933 "},{"v":1320,"d":"1,320 "},{"v":1133,"d":"1,133 "},{"v":1650,"d":"1,650 "},{"v":5036,"d":"5,036 "},{"v":3220,"d":"3,220 "},{"v":2400,"d":"2,400 "},{"v":1260,"d":"1,260 "},{"v":1420,"d":"1,420 "},{"v":8300,"d":"8,300 "},{"v":1272,"d":"1,272 "},{"v":1040,"d":"1,040 "},{"v":1080,"d":"1,080 "},{"v":1030,"d":"1,030 "},{"v":4422,"d":"4,422 "},{"v":17758,"d":"17,758 "}]

{"sheet":"24","index":24,"n_rows":14,"n_cols":9,"rows_kept":14}
["1. Click cell B13 to activate the PivotTable named \"Sum of Units sold\"."]
["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. NOTE: if the Field List doesn't launch, press ALT+JT, L again."]
["3. Use your Tab, arrow and SPACEBAR keys to modify the example so that each Sales Reps has their own column fields with Seasons on the left, and Products indented beneath them."]
["4. Select cell I9 and pick how many grapefruit Dave sold in winter."]
["To continue with this tutorial, press CTRL+PAGE DOWN. To go to the previous sheet, press CTRL+PAGE UP."]
[]
[null,{"$f":"IF(AND($B$14=\"Dave\",$C$16=4422),\"Good job!\",\" \")","v":" "}]
[{"$nulls":8},"Pick one:"]
[]
[{"$nulls":8},{"$f":"IF($I$9=400,\"You're right!\",IF($I$9=530,\"Try again…\",IF($I$9=123,\"Not quite…\",\" \")))","v":" "}]
[]
[]
[null,"Sum of Units sold"]
[null,{"v":17758,"d":"17,758 "}]

{"sheet":"Learn more","index":25,"n_rows":8,"n_cols":1,"rows_kept":8}
["Good job. Aren't PivotTables great?"]
["But we encourage you to keep going! There's more to discover..."]
["More Pivot info\nDiscover more you can do by reading this helpful article on PivotTables."]
["About refresh\nRead this important article about how to refresh PivotTables. "]
["LinkedIn Learning\nVideo courses for all levels—from beginner to advanced. Take at your own pace."]
["Community\nConnect with other Excel fans. They can help you, and you can help them."]
[]
[" "]