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

{"sheet":"开始","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
["欢迎\n用于屏幕阅读器的说明：更好地利用数据透视表。简单的数据透视表可提供数据的总体摘要，但有时也需要特定问题的详细回答。这可以通过添加更多列字段和行字段做到。\n说明将指示要导航到哪些单元格以使用功能或进一步阅读。\n若要开始，请按 Ctrl+Page Down。"]
["更好地利用数据透视表"]
["简单的数据透视表可提供数据的总体摘要，\n但有时也需要特定问题的详细回答。\n这可以通过添加更多列字段和行字段做到。"]
["扩展知识\n完成第一个教程了吗？如果没有，请转到“文件”>“新建”，查找“制作你的第一张数据透视表”。"]
["按 Ctrl+Home 返回页首。若要开始教程，请按 Ctrl+Page Down。"]

{"sheet":"1","index":1,"n_rows":16,"n_cols":9,"rows_kept":16}
["在第一个教程中，我们介绍了数据透视表的概念。我们还说明了如何使用行字段作为划分值字段的条件。   "]
["单元格 H10 到 I14 包含对单元格 B8 到 E16 中的数据进行汇总的数据透视表。数据透视表有两列：“购买者”和“金额总和”。“购买者”列包含值“爸爸”、“妈妈”、“康霓”和“总计”；“金额总和”列包含值“¥220”、“¥270”、“¥810”和“¥1,300”。“购买者”列由“行字段”组成，“金额总和”列由“值字段”组成。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额"]
["此示例显示行字段如何...","2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
["...划分值字段。","2017-01-15","妈妈","食物",{"v":325,"d":"¥325"},null,null,"购买者","金额总和"]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"},null,null,"爸爸",{"v":220,"d":"¥220"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"},null,null,"康霓",{"v":270,"d":"¥270"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"},null,null,"妈妈",{"v":810,"d":"¥810"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"},null,null,"Grand Total",{"v":1300,"d":"¥1,300"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"2","index":2,"n_rows":108,"n_cols":7,"rows_kept":108}
["但在你首次查看数据透视表时，可能会发现需要其中的更多答案。"]
["首先查看数据透视表时，可能会问：“这些是什么时候买的？”、“每个人都花钱买了什么？”、“妈妈买了什么东西这么贵？”。"]
["在此示例中，单元格 F11 到 G15 显示了和前面一样的两列数据透视表。“购买者”列是“行字段”，包含值“爸爸”、“妈妈”、“康霓”和“总计”；“金额总和”列是“值字段”，包含值“¥220”、“¥270”、“¥810”和“¥1,300”。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"购买者","金额总和"]
[{"$nulls":5},"爸爸",{"v":220,"d":"¥220"}]
[{"$nulls":5},"康霓",{"v":270,"d":"¥270"}]
[{"$nulls":5},"妈妈",{"v":810,"d":"¥810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"¥1,300"}]
{"$rows_empty":84}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"3","index":3,"n_rows":108,"n_cols":7,"rows_kept":108}
["这些都是好问题，但就目前而言，让我们只关注一个问题。"]
["每个人都花钱买了什么？"]
["作为参考，单元格 F11 到 G15 显示了和前面一样的两列数据透视表。“购买者”列是“行字段”，包含值“爸爸”、“妈妈”、“康霓”和“总计”；“金额总和”列是“值字段”，包含值“¥220”、“¥270”、“¥810”和“¥1,300”。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"购买者","金额总和"]
[{"$nulls":5},"爸爸",{"v":220,"d":"¥220"}]
[{"$nulls":5},"康霓",{"v":270,"d":"¥270"}]
[{"$nulls":5},"妈妈",{"v":810,"d":"¥810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"¥1,300"}]
{"$rows_empty":84}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"4","index":4,"n_rows":108,"n_cols":9,"rows_kept":108}
["最后一个问题是“每个人都花钱买了什么？”"]
["我们通过为“类型”添加列字段已经回答了这个问题。因此，数据透视表现在有五个新列，显示每个人的购买类型。 "]
["新的数据透视表现在从单元格 C10 到 I15，其中的列有“购买者”、“食物”、“音乐”、“运动”、“门票”、“礼品”和“总计”。“购买者”和“总计”与之前一样，新的详细列在它们中间。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,null,"金额总和","类型"]
[null,null,"购买者","食物","音乐","运动","门票","礼品","Grand Total"]
[null,null,"爸爸",{"v":125,"d":"¥125"},{"$nulls":3},{"v":95,"d":"¥95"},{"v":220,"d":"¥220"}]
[null,null,"康霓",null,{"v":20,"d":"¥20"},{"v":125,"d":"¥125"},{"v":125,"d":"¥125"},null,{"v":270,"d":"¥270"}]
[null,null,"妈妈",{"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,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"5","index":5,"n_rows":108,"n_cols":9,"rows_kept":108}
["如果数据透视表不便于理解，请尝试：从左侧阅读，然后从顶部，然后向下。在下面示例中，“爸爸”位于单元格 C12、“食物”的“¥125”位于单元格 D12、“礼品”的“¥95”位于单元格 E12、“总计”的“¥220”位于单元格 I12。行 13 和 14 显示“康霓”和“妈妈”的详细信息，行 15 显示“总计”。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":7}
[null,null,"金额总和","类型"]
[null,null,"购买者","食物","礼品","音乐","运动","门票","Grand Total"]
[null,null,"爸爸",{"v":125,"d":"¥125"},{"v":95,"d":"¥95"},{"$nulls":3},{"v":220,"d":"¥220"}]
[null,null,"康霓",null,null,{"v":20,"d":"¥20"},{"v":125,"d":"¥125"},{"v":125,"d":"¥125"},{"v":270,"d":"¥270"}]
[null,null,"妈妈",{"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,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"6","index":6,"n_rows":3,"n_cols":1,"rows_kept":3}
["不会立即生成数据透视表，但几个步骤后，将看到一张数据透视表。首先，在“列”中创建详细信息。将通过在“列”区域放置“类型”字段执行该操作。"]
["“数据透视表字段”列表图显示一个箭头光标，将“类型”字段拖到“列”区域。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]

{"sheet":"7","index":7,"n_rows":108,"n_cols":8,"rows_kept":108}
["1.此示例中的“数据透视表”区域在单元格 B13 到 C17。导航到其中任意单元格。"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“搜索”编辑"]
["3.按箭头键选择“类型”字段。选择后，按空格键将“类型”字段添加到“行”区域。 "]
["4.按 Tab 选择“类型”字段。按 Enter，然后按箭头键选择“移动到列标签”，再按 Enter 将“类型”字段添加到列区域。按 Alt+JT+L 退出“数据透视表字段”窗格。"]
["要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"购买者\",$H$17=810),\"好样的！已放置\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"购买者\",$H$17=810),\"第一列字段。单击\",\" \")","v":" "}]
[{"$nulls":7},{"$f":"IF(AND($B$14=\"购买者\",$H$17=810),\"“下一步”继续...\",\" \")","v":" "}]
[]
[null,"购买者","金额总和"]
[null,"爸爸",{"v":220,"d":"¥220"}]
[null,"康霓",{"v":270,"d":"¥270"}]
[null,"妈妈",{"v":810,"d":"¥810"}]
[null,"Grand Total",{"v":1300,"d":"¥1,300"}]
{"$rows_empty":82}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"8","index":8,"n_rows":108,"n_cols":9,"rows_kept":108}
["让我们查看刚才所做的数据透视表，但这次我们添加了一些特殊颜色以区分行、列和值字段。"]
["行字段从单元格 C10 到 C13，且带黄色底纹。"]
["列字段从单元格 D9 到 H10，且带橙色底纹。"]
["值字段从单元格 D11 到 H13，且带蓝色底纹。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[null,null,"求和项:金额","类型"]
[null,null,"购买者","礼品","门票","食物","音乐","运动","Grand Total"]
[null,null,"爸爸",{"v":95,"d":"¥95"},null,{"v":125,"d":"¥125"},null,null,{"v":220,"d":"¥220"}]
[null,null,"康霓",null,{"v":125,"d":"¥125"},null,{"v":20,"d":"¥20"},{"v":125,"d":"¥125"},{"v":270,"d":"¥270"}]
[null,null,"妈妈",null,{"v":250,"d":"¥250"},{"v":560,"d":"¥560"},null,null,{"v":810,"d":"¥810"}]
[null,null,"Grand Total",{"v":95,"d":"¥95"},{"v":375,"d":"¥375"},{"v":685,"d":"¥685"},{"v":20,"d":"¥20"},{"v":125,"d":"¥125"},{"v":1300,"d":"¥1,300"}]
{"$rows_empty":85}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","爸爸","礼品",{"v":95,"d":"¥95"}]
[null,"2017-01-15","妈妈","食物",{"v":325,"d":"¥325"}]
[null,"2017-01-17","妈妈","门票",{"v":250,"d":"¥250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-02-25","康霓","运动",{"v":125,"d":"¥125"}]

{"sheet":"9","index":9,"n_rows":3,"n_cols":1,"rows_kept":3}
["下面是另一种方法：行字段位于左侧，列字段位于顶部。每个字段都为值字段提供了一个条件，值字段对它们进行求和。"]
["概念图显示了一个分为 4 部分的矩形区域，行字段位于左下角为黄色，列字段位于右上角为橙色，值字段位于右下角为蓝色。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]

{"sheet":"10","index":10,"n_rows":3,"n_cols":1,"rows_kept":3}
["在使用字段列表时，可以这样想。行字段位于左侧，列字段位于顶部。每个字段都为值字段提供了一个条件，值字段对它们进行求和。"]
["概念图显示了“数据透视表字段”列表，行字段位于左下角为黄色，列字段位于右上角为橙色，值字段位于右下角为蓝色。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]

{"sheet":"11","index":11,"n_rows":121,"n_cols":24,"rows_kept":121}
["有一件事需要注意：如果列字段向数据透视表添加大量列，则会导致其非常宽。 "]
["在此示例中，数据透视表现在的范围从单元格 C10 到 X15，列字段添加了 20 个新列。这是非常多的列！这将导致大量滚动..."]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[null,null,"金额总和","类型"]
[null,null,"购买者","车险","电费","电子产品","机票","家庭保险","健康保险","就餐","俱乐部会费","门票","食物","书籍","税款","停车费","牙科","衣物","医疗","音乐","音乐课","油费","运动","Grand Total"]
[null,null,"爸爸",{"$nulls":3},{"v":500,"d":"¥500"},{"$nulls":7},{"v":500,"d":"¥500"},{"$nulls":7},{"v":1000,"d":"¥1,000"},{"v":2000,"d":"¥2,000"}]
[null,null,"康霓",null,null,{"v":125,"d":"¥125"},{"$nulls":3},{"v":20,"d":"¥20"},null,{"v":125,"d":"¥125"},null,{"v":250,"d":"¥250"},null,{"v":20,"d":"¥20"},null,{"v":125,"d":"¥125"},null,{"v":20,"d":"¥20"},{"v":250,"d":"¥250"},null,null,{"v":935,"d":"¥935"}]
[null,null,"妈妈",{"v":74,"d":"¥74"},{"v":70,"d":"¥70"},null,null,{"v":235,"d":"¥235"},{"v":70,"d":"¥70"},null,{"v":125,"d":"¥125"},null,{"v":470,"d":"¥470"},{"$nulls":3},{"v":235,"d":"¥235"},null,{"v":74,"d":"¥74"},null,null,{"v":74,"d":"¥74"},null,{"v":1427,"d":"¥1,427"}]
[null,null,"Grand Total",{"v":74,"d":"¥74"},{"v":70,"d":"¥70"},{"v":125,"d":"¥125"},{"v":500,"d":"¥500"},{"v":235,"d":"¥235"},{"v":70,"d":"¥70"},{"v":20,"d":"¥20"},{"v":125,"d":"¥125"},{"v":125,"d":"¥125"},{"v":470,"d":"¥470"},{"v":250,"d":"¥250"},{"v":500,"d":"¥500"},{"v":20,"d":"¥20"},{"v":235,"d":"¥235"},{"v":125,"d":"¥125"},{"v":74,"d":"¥74"},{"v":20,"d":"¥20"},{"v":250,"d":"¥250"},{"v":74,"d":"¥74"},{"v":1000,"d":"¥1,000"},{"v":4362,"d":"¥4,362"}]
{"$rows_empty":84}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-17","爸爸","运动",{"v":1000,"d":"¥1,000"}]
[null,"2017-01-17","爸爸","机票",{"v":500,"d":"¥500"}]
[null,"2017-01-17","爸爸","税款",{"v":500,"d":"¥500"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","就餐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","衣物",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","音乐课",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","停车费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","电子产品",{"v":125,"d":"¥125"}]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-21","妈妈","俱乐部会费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","医疗",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","电费",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","牙科",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","车险",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","健康保险",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","家庭保险",{"v":235,"d":"¥235"}]

{"sheet":"12","index":12,"n_rows":119,"n_cols":5,"rows_kept":119}
["有一种替代超宽数据透视表的方法：可以改用第二行字段。第二行字段将在第一行字段下缩进显示。"]
["在此示例中，数据透视表从单元格 D8 到 E32。D 列中的第一行字段显示为“爸爸”、“康霓”和“妈妈”。然后，其下面的第二行字段显示为支出类型，包含“运动”、“机票”、“就餐”等项目。"]
["扩展知识\n第二行字段生成垂直方向的数据透视表，而不是水平的。有些人认为垂直透视表更容易阅读，因为不需要从一侧滚动到另一侧。"]
["EXCEL 表示\n第二行字段有时也叫做“辅助行字段”。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[{"$nulls":3},"Row Labels","金额总和"]
[{"$nulls":3},"爸爸",{"v":2000,"d":"¥2,000"}]
[{"$nulls":3},"机票",{"v":500,"d":"¥500"}]
[{"$nulls":3},"税款",{"v":500,"d":"¥500"}]
[{"$nulls":3},"运动",{"v":1000,"d":"¥1,000"}]
[{"$nulls":3},"康霓",{"v":935,"d":"¥935"}]
[{"$nulls":3},"电子产品",{"v":125,"d":"¥125"}]
[{"$nulls":3},"就餐",{"v":20,"d":"¥20"}]
[{"$nulls":3},"门票",{"v":125,"d":"¥125"}]
[{"$nulls":3},"书籍",{"v":250,"d":"¥250"}]
[{"$nulls":3},"停车费",{"v":20,"d":"¥20"}]
[{"$nulls":3},"衣物",{"v":125,"d":"¥125"}]
[{"$nulls":3},"音乐",{"v":20,"d":"¥20"}]
[{"$nulls":3},"音乐课",{"v":250,"d":"¥250"}]
[{"$nulls":3},"妈妈",{"v":1427,"d":"¥1,427"}]
[{"$nulls":3},"车险",{"v":74,"d":"¥74"}]
[{"$nulls":3},"电费",{"v":70,"d":"¥70"}]
[{"$nulls":3},"家庭保险",{"v":235,"d":"¥235"}]
[{"$nulls":3},"健康保险",{"v":70,"d":"¥70"}]
[{"$nulls":3},"俱乐部会费",{"v":125,"d":"¥125"}]
[{"$nulls":3},"食物",{"v":470,"d":"¥470"}]
[{"$nulls":3},"牙科",{"v":235,"d":"¥235"}]
[{"$nulls":3},"医疗",{"v":74,"d":"¥74"}]
[{"$nulls":3},"油费",{"v":74,"d":"¥74"}]
[{"$nulls":3},"Grand Total",{"v":4362,"d":"¥4,362"}]
{"$rows_empty":65}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-17","爸爸","运动",{"v":1000,"d":"¥1,000"}]
[null,"2017-01-17","爸爸","机票",{"v":500,"d":"¥500"}]
[null,"2017-01-17","爸爸","税款",{"v":500,"d":"¥500"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","就餐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","衣物",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","音乐课",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","停车费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","电子产品",{"v":125,"d":"¥125"}]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-21","妈妈","俱乐部会费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","医疗",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","电费",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","牙科",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","车险",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","健康保险",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","家庭保险",{"v":235,"d":"¥235"}]

{"sheet":"13","index":13,"n_rows":3,"n_cols":1,"rows_kept":3}
["在下一个工作表上将添加第二行字段。将通过在行字段中把“类型”字段放置到“购买者”字段下面来执行此操作。"]
["“数据透视表字段”列表图显示一个箭头光标，将“类型”字段拖到“行”区域。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]

{"sheet":"14","index":14,"n_rows":122,"n_cols":9,"rows_kept":122}
["1.此示例中的“数据透视表”区域在单元格 B13 到 C17。导航到其中任意单元格。 "]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.按箭头键移到“类型”字段。按空格键将“类型”字段添加到“行”区域。 "]
["4.按 Esc 键退出“数据透视表字段”窗格。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。",{"$nulls":7},{"$f":"IF(AND($B$15=\"机票\",$C$36=74),\"干得好！已向数据\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"机票\",$C$36=74),\"透视表​​添加第二行\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"机票\",$C$36=74),\"字段。向下滚动并\",\" \")","v":" "}]
[{"$nulls":8},{"$f":"IF(AND($B$15=\"机票\",$C$36=74),\"单击“下一步”…\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"Row Labels","金额总和"]
[null,"爸爸",{"v":2000,"d":"¥2,000"}]
[null,"康霓",{"v":935,"d":"¥935"}]
[null,"妈妈",{"v":1427,"d":"¥1,427"}]
[null,"Grand Total",{"v":4362,"d":"¥4,362"}]
{"$rows_empty":83}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-17","爸爸","运动",{"v":1000,"d":"¥1,000"}]
[null,"2017-01-17","爸爸","机票",{"v":500,"d":"¥500"}]
[null,"2017-01-17","爸爸","税款",{"v":500,"d":"¥500"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","就餐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","衣物",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","音乐课",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","停车费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","电子产品",{"v":125,"d":"¥125"}]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-21","妈妈","俱乐部会费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","医疗",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","电费",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","牙科",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","车险",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","健康保险",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","家庭保险",{"v":235,"d":"¥235"}]

{"sheet":"15","index":15,"n_rows":121,"n_cols":7,"rows_kept":121}
["如需简化数据透视表，可以“向上”折叠个第二行字段的数据并隐藏。 "]
["此示例中的数据透视表位于单元格 F7 到 G31。选择单元格 F8 以选择“爸爸”的第一行字段。然后，按 Alt+JT > X 展开第二个字段，或按 P 将其折叠。"]
["要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"康霓\",$G$9=935),\"很好！\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","金额总和"]
[{"$nulls":5},"爸爸",{"v":2000,"d":"¥2,000"}]
[{"$nulls":5},"机票",{"v":500,"d":"¥500"}]
[{"$nulls":5},"税款",{"v":500,"d":"¥500"}]
[{"$nulls":5},"运动",{"v":1000,"d":"¥1,000"}]
[{"$nulls":5},"康霓",{"v":935,"d":"¥935"}]
[{"$nulls":5},"电子产品",{"v":125,"d":"¥125"}]
[{"$nulls":5},"就餐",{"v":20,"d":"¥20"}]
[{"$nulls":5},"门票",{"v":125,"d":"¥125"}]
[{"$nulls":5},"书籍",{"v":250,"d":"¥250"}]
[{"$nulls":5},"停车费",{"v":20,"d":"¥20"}]
[{"$nulls":5},"衣物",{"v":125,"d":"¥125"}]
[{"$nulls":5},"音乐",{"v":20,"d":"¥20"}]
[{"$nulls":5},"音乐课",{"v":250,"d":"¥250"}]
[{"$nulls":5},"妈妈",{"v":1427,"d":"¥1,427"}]
[{"$nulls":5},"车险",{"v":74,"d":"¥74"}]
[{"$nulls":5},"电费",{"v":70,"d":"¥70"}]
[{"$nulls":5},"家庭保险",{"v":235,"d":"¥235"}]
[{"$nulls":5},"健康保险",{"v":70,"d":"¥70"}]
[{"$nulls":5},"俱乐部会费",{"v":125,"d":"¥125"}]
[{"$nulls":5},"食物",{"v":470,"d":"¥470"}]
[{"$nulls":5},"牙科",{"v":235,"d":"¥235"}]
[{"$nulls":5},"医疗",{"v":74,"d":"¥74"}]
[{"$nulls":5},"油费",{"v":74,"d":"¥74"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"¥4,362"}]
{"$rows_empty":68}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-17","爸爸","运动",{"v":1000,"d":"¥1,000"}]
[null,"2017-01-17","爸爸","机票",{"v":500,"d":"¥500"}]
[null,"2017-01-17","爸爸","税款",{"v":500,"d":"¥500"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","就餐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","衣物",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","音乐课",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","停车费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","电子产品",{"v":125,"d":"¥125"}]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-21","妈妈","俱乐部会费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","医疗",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","电费",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","牙科",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","车险",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","健康保险",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","家庭保险",{"v":235,"d":"¥235"}]

{"sheet":"16","index":16,"n_rows":121,"n_cols":7,"rows_kept":121}
["还可以折叠或展开整个第二行字段以进一步简化数据透视表。"]
["要点"]
["选择从单元格 F7 到 G31 的数据透视表数据区域，然后转到 ALT+JT > P 折叠整个组。相反，ALT+JT > X 将展开整个组。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[{"$nulls":5},{"$f":"IF(AND($F$9=\"康霓\",$G$9=935),\"好极了！\",\" \")","v":" "}]
[{"$nulls":5},"Row Labels","金额总和"]
[{"$nulls":5},"爸爸",{"v":2000,"d":"¥2,000"}]
[{"$nulls":5},"机票",{"v":500,"d":"¥500"}]
[{"$nulls":5},"税款",{"v":500,"d":"¥500"}]
[{"$nulls":5},"运动",{"v":1000,"d":"¥1,000"}]
[{"$nulls":5},"康霓",{"v":935,"d":"¥935"}]
[{"$nulls":5},"电子产品",{"v":125,"d":"¥125"}]
[{"$nulls":5},"就餐",{"v":20,"d":"¥20"}]
[{"$nulls":5},"门票",{"v":125,"d":"¥125"}]
[{"$nulls":5},"书籍",{"v":250,"d":"¥250"}]
[{"$nulls":5},"停车费",{"v":20,"d":"¥20"}]
[{"$nulls":5},"衣物",{"v":125,"d":"¥125"}]
[{"$nulls":5},"音乐",{"v":20,"d":"¥20"}]
[{"$nulls":5},"音乐课",{"v":250,"d":"¥250"}]
[{"$nulls":5},"妈妈",{"v":1427,"d":"¥1,427"}]
[{"$nulls":5},"车险",{"v":74,"d":"¥74"}]
[{"$nulls":5},"电费",{"v":70,"d":"¥70"}]
[{"$nulls":5},"家庭保险",{"v":235,"d":"¥235"}]
[{"$nulls":5},"健康保险",{"v":70,"d":"¥70"}]
[{"$nulls":5},"俱乐部会费",{"v":125,"d":"¥125"}]
[{"$nulls":5},"食物",{"v":470,"d":"¥470"}]
[{"$nulls":5},"牙科",{"v":235,"d":"¥235"}]
[{"$nulls":5},"医疗",{"v":74,"d":"¥74"}]
[{"$nulls":5},"油费",{"v":74,"d":"¥74"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"¥4,362"}]
{"$rows_empty":68}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-17","爸爸","运动",{"v":1000,"d":"¥1,000"}]
[null,"2017-01-17","爸爸","机票",{"v":500,"d":"¥500"}]
[null,"2017-01-17","爸爸","税款",{"v":500,"d":"¥500"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","就餐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","衣物",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","音乐课",{"v":250,"d":"¥250"}]
[null,"2017-02-20","康霓","停车费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","电子产品",{"v":125,"d":"¥125"}]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-21","妈妈","俱乐部会费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食物",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","医疗",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","电费",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","牙科",{"v":235,"d":"¥235"}]
[null,"2017-01-01","妈妈","车险",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","健康保险",{"v":70,"d":"¥70"}]
[null,"2017-02-02","妈妈","家庭保险",{"v":235,"d":"¥235"}]

{"sheet":"17","index":17,"n_rows":107,"n_cols":13,"rows_kept":107}
["还可以有多个列字段。还可以折叠或展开这些列字段。"]
["本示例中的数据透视表从单元格 B13 到 M19。在本例中，列部分中有一个“类型”类别，其中包括“食物”和“水电费”的项。"]
["试一下\n选择单元格 C14 中的“食物”，然后转到 ALT+JT > P 以折叠整个字段。ALT+JT > X 将展开它。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":7}
[null,null,{"$f":"IF(AND($C$16=398,$D$15=\"1 月\"),\"做得好！\",\" \")","v":" "}]
[null,"金额总和","Column Labels"]
[null,null,"食物",{"$nulls":3},"食物 Total","水电费",{"$nulls":3},"水电费 Total","Grand Total"]
[null,"Row Labels","1 月","2 月","3 月","4 月",null,"1 月","2 月","3 月","4 月"]
[null,"康霓",{"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,"爸爸",{"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,"妈妈",{"$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,"月份","购买者","类型","金额"]
[null,"1 月","康霓","食物",{"v":74,"d":"¥74"}]
[null,"1 月","爸爸","食物",{"v":235,"d":"¥235"}]
[null,"1 月","妈妈","水电费",{"v":1000,"d":"¥1,000"}]
[null,"2 月","康霓","食物",{"v":74,"d":"¥74"}]
[null,"2 月","爸爸","食物",{"v":235,"d":"¥235"}]
[null,"2 月","妈妈","水电费",{"v":1000,"d":"¥1,000"}]
[null,"3 月","康霓","食物",{"v":125,"d":"¥125"}]
[null,"3 月","爸爸","食物",{"v":235,"d":"¥235"}]
[null,"3 月","妈妈","水电费",{"v":20,"d":"¥20"}]
[null,"4 月","康霓","食物",{"v":125,"d":"¥125"}]
[null,"4 月","爸爸","食物",{"v":74,"d":"¥74"}]
[null,"4 月","妈妈","水电费",{"v":70,"d":"¥70"}]

{"sheet":"18","index":18,"n_rows":146,"n_cols":5,"rows_kept":146}
["请记住：如需更多详细信息，可添加更多行字段或列字段。在此示例中，有三个行字段。"]
["此示例中的数据透视表从单元格 D8 到 E29，并且在列 D 中包含“季度”、“购买者”和“类型”的字段，列 E 中包含“金额总和”。"]
["专家提示\n可以添加多个字段，但不是必须。在此示例中可正常工作。但有时过多字段，以及其所有缩进，会使数据透视表变得过于复杂，其他人难以理解。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[{"$nulls":3},"Row Labels","金额总和"]
[{"$nulls":3},"春季",{"v":4760,"d":"¥4,760"}]
[{"$nulls":3},"爸爸",{"v":4760,"d":"¥4,760"}]
[{"$nulls":3},"保险",{"v":1040,"d":"¥1,040"}]
[{"$nulls":3},"水电费",{"v":1320,"d":"¥1,320"}]
[{"$nulls":3},"租金",{"v":2400,"d":"¥2,400"}]
[{"$nulls":3},"冬季",{"v":4100,"d":"¥4,100"}]
[{"$nulls":3},"爸爸",{"v":4100,"d":"¥4,100"}]
[{"$nulls":3},"保险",{"v":1030,"d":"¥1,030"}]
[{"$nulls":3},"水电费",{"v":1650,"d":"¥1,650"}]
[{"$nulls":3},"租金",{"v":1420,"d":"¥1,420"}]
[{"$nulls":3},"秋季",{"v":5425,"d":"¥5,425"}]
[{"$nulls":3},"妈妈",{"v":5425,"d":"¥5,425"}]
[{"$nulls":3},"保险",{"v":1272,"d":"¥1,272"}]
[{"$nulls":3},"水电费",{"v":933,"d":"¥933"}]
[{"$nulls":3},"租金",{"v":3220,"d":"¥3,220"}]
[{"$nulls":3},"夏季",{"v":3473,"d":"¥3,473"}]
[{"$nulls":3},"妈妈",{"v":3473,"d":"¥3,473"}]
[{"$nulls":3},"保险",{"v":1080,"d":"¥1,080"}]
[{"$nulls":3},"水电费",{"v":1133,"d":"¥1,133"}]
[{"$nulls":3},"租金",{"v":1260,"d":"¥1,260"}]
[{"$nulls":3},"Grand Total",{"v":17758,"d":"¥17,758"}]
{"$rows_empty":68}
[null,"购买者","季度","类型","金额"]
[null,"爸爸","冬季","保险",{"v":300,"d":"¥300"}]
[null,"爸爸","冬季","租金",{"v":200,"d":"¥200"}]
[null,"爸爸","冬季","水电费",{"v":400,"d":"¥400"}]
[null,"爸爸","冬季","保险",{"v":300,"d":"¥300"}]
[null,"爸爸","冬季","租金",{"v":800,"d":"¥800"}]
[null,"爸爸","冬季","水电费",{"v":400,"d":"¥400"}]
[null,"爸爸","冬季","保险",{"v":200,"d":"¥200"}]
[null,"爸爸","冬季","租金",{"v":300,"d":"¥300"}]
[null,"爸爸","冬季","水电费",{"v":450,"d":"¥450"}]
[null,"爸爸","冬季","保险",{"v":230,"d":"¥230"}]
[null,"爸爸","冬季","租金",{"v":120,"d":"¥120"}]
[null,"爸爸","冬季","水电费",{"v":400,"d":"¥400"}]
[null,"爸爸","春季","保险",{"v":210,"d":"¥210"}]
[null,"爸爸","春季","租金",{"v":300,"d":"¥300"}]
[null,"爸爸","春季","水电费",{"v":400,"d":"¥400"}]
[null,"爸爸","春季","保险",{"v":230,"d":"¥230"}]
[null,"爸爸","春季","租金",{"v":900,"d":"¥900"}]
[null,"爸爸","春季","水电费",{"v":300,"d":"¥300"}]
[null,"爸爸","春季","保险",{"v":200,"d":"¥200"}]
[null,"爸爸","春季","租金",{"v":1000,"d":"¥1,000"}]
[null,"爸爸","春季","水电费",{"v":220,"d":"¥220"}]
[null,"爸爸","春季","保险",{"v":400,"d":"¥400"}]
[null,"爸爸","春季","租金",{"v":200,"d":"¥200"}]
[null,"爸爸","春季","水电费",{"v":400,"d":"¥400"}]
[null,"妈妈","夏季","保险",{"v":100,"d":"¥100"}]
[null,"妈妈","夏季","租金",{"v":30,"d":"¥30"}]
[null,"妈妈","夏季","水电费",{"v":123,"d":"¥123"}]
[null,"妈妈","夏季","保险",{"v":300,"d":"¥300"}]
[null,"妈妈","夏季","租金",{"v":350,"d":"¥350"}]
[null,"妈妈","夏季","水电费",{"v":230,"d":"¥230"}]
[null,"妈妈","夏季","保险",{"v":120,"d":"¥120"}]
[null,"妈妈","夏季","租金",{"v":640,"d":"¥640"}]
[null,"妈妈","夏季","水电费",{"v":530,"d":"¥530"}]
[null,"妈妈","夏季","保险",{"v":560,"d":"¥560"}]
[null,"妈妈","夏季","租金",{"v":240,"d":"¥240"}]
[null,"妈妈","夏季","水电费",{"v":250,"d":"¥250"}]
[null,"妈妈","秋季","保险",{"v":62,"d":"¥62"}]
[null,"妈妈","秋季","租金",{"v":600,"d":"¥600"}]
[null,"妈妈","秋季","水电费",{"v":340,"d":"¥340"}]
[null,"妈妈","秋季","保险",{"v":205,"d":"¥205"}]
[null,"妈妈","秋季","租金",{"v":500,"d":"¥500"}]
[null,"妈妈","秋季","水电费",{"v":403,"d":"¥403"}]
[null,"妈妈","秋季","保险",{"v":503,"d":"¥503"}]
[null,"妈妈","秋季","租金",{"v":2000,"d":"¥2,000"}]
[null,"妈妈","秋季","水电费",{"v":140,"d":"¥140"}]
[null,"妈妈","秋季","保险",{"v":502,"d":"¥502"}]
[null,"妈妈","秋季","租金",{"v":120,"d":"¥120"}]
[null,"妈妈","秋季","水电费",{"v":50,"d":"¥50"}]

{"sheet":"19","index":19,"n_rows":55,"n_cols":5,"rows_kept":55}
["准备好做更多练习了吗？查看下面单元格 B7 到 E55 中的数据。准备好后，转到下一个工作表，然后将练习目前为止所学到的内容。 "]
["无需查看所有行的数据。只需查看行 7 中的字段名称。将在下一个工作表上使用这些。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[null,"季度","销售代表","产品","销量"]
[null,"冬季","陶湘","橙子",300]
[null,"冬季","贾文","西柚",200]
[null,"冬季","康迈克","苹果",400]
[null,"冬季","陶湘","香蕉",300]
[null,"冬季","贾文","橙子",800]
[null,"冬季","康迈克","西柚",400]
[null,"冬季","陶湘","苹果",200]
[null,"冬季","贾文","香蕉",300]
[null,"冬季","康迈克","橙子",450]
[null,"冬季","陶湘","西柚",230]
[null,"冬季","贾文","苹果",120]
[null,"冬季","康迈克","香蕉",400]
[null,"春季","陶湘","甜菜",210]
[null,"春季","贾文","土豆",300]
[null,"春季","康迈克","莴苣",400]
[null,"春季","陶湘","萝卜",230]
[null,"春季","贾文","甜菜",900]
[null,"春季","康迈克","土豆",300]
[null,"春季","陶湘","莴苣",200]
[null,"春季","贾文","萝卜",1000]
[null,"春季","康迈克","甜菜",220]
[null,"春季","陶湘","土豆",400]
[null,"春季","贾文","莴苣",200]
[null,"春季","康迈克","萝卜",400]
[null,"夏季","陶湘","蓝莓",100]
[null,"夏季","贾文","草莓",30]
[null,"夏季","康迈克","葡萄",123]
[null,"夏季","陶湘","南瓜",300]
[null,"夏季","贾文","蓝莓",350]
[null,"夏季","康迈克","草莓",230]
[null,"夏季","陶湘","葡萄",120]
[null,"夏季","贾文","南瓜",640]
[null,"夏季","康迈克","蓝莓",530]
[null,"夏季","陶湘","草莓",560]
[null,"夏季","贾文","葡萄",240]
[null,"夏季","康迈克","南瓜",250]
[null,"秋季","陶湘","西葫芦",62]
[null,"秋季","贾文","胡瓜",600]
[null,"秋季","康迈克","苹果",340]
[null,"秋季","陶湘","橙子",205]
[null,"秋季","贾文","西葫芦",500]
[null,"秋季","康迈克","胡瓜",403]
[null,"秋季","陶湘","苹果",503]
[null,"秋季","贾文","橙子",2000]
[null,"秋季","康迈克","西葫芦",140]
[null,"秋季","陶湘","胡瓜",502]
[null,"秋季","贾文","苹果",120]
[null,"秋季","康迈克","橙子",50]

{"sheet":"20","index":20,"n_rows":17,"n_cols":11,"rows_kept":17}
["1.此示例中的“数据透视表”区域在单元格 B12 到 C17。导航到其中任意单元格。 \n\n"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.按箭头键移到“销售代表”字段。按空格键将“销售代表”字段添加到“行”区域。若要在“列”区域中显示“销售代表”详细信息，请使用 Tab 键移到“行”部分中的“销售代表”字段，然后按空格键，然后选择“移动到列标签”。按 Esc 键退出“数据透视表字段”窗格。 "]
["4.确定谁在秋季卖出最多的产品，然后在单元格 K8 中进行选择。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[{"$nulls":10},"选择一个："]
[]
[{"$nulls":10},{"$f":"IF($K$8=\"贾文\",\"做得对！\",IF($K$8=\"康迈克\",\"再试一次...\",IF($K$8=\"陶湘\",\"尚未完成...\",IF($K$8=\" \",\" \",\" \"))))","v":" "}]
[]
[]
[null,"Row Labels","销量总和"]
[null,"秋季",{"v":5425,"d":"5,425 "}]
[null,"春季",{"v":4760,"d":"4,760 "}]
[null,"夏季",{"v":3473,"d":"3,473 "}]
[null,"冬季",{"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.单击单元格 B13 激活名为“销量总和”的数据透视表。\n\n"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.使用箭头键和空格键将示例展开到垂直数据透视表，季度在该表的左侧，销售代表在季度下缩进。按 Esc 键退出“数据透视表字段”窗格。 "]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"春季\",$C$17=1040),\"好样的！已放置辅助\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"春季\",$C$17=1040),\"行字段。现在请向下滚\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"春季\",$C$17=1040),\"动并单击“下一步”。\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,"销量总和"]
[null,{"v":17758,"d":"17,758 "}]

{"sheet":"22","index":22,"n_rows":14,"n_cols":10,"rows_kept":14}
["1.单击单元格 B13 激活名为“销量总和”的数据透视表。"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.使用箭头键和空格键修改示例，使其在其行中显示每个产品，在其列中显示每个季度。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。",{"$nulls":8},{"$f":"IF(AND($B$15=\"草莓\",$G$28=1000),\"好样的！已在左侧\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"草莓\",$G$28=1000),\"放置行字段，并在\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"草莓\",$G$28=1000),\"列字段中放置了四个\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"草莓\",$G$28=1000),\"新列。向下滚动并\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"草莓\",$G$28=1000),\"单击“下一步”...\",\" \")","v":" "}]
[]
[]
[]
[]
[null,"销量总和"]
[null,{"v":17758,"d":"17,758 "}]

{"sheet":"23","index":23,"n_rows":16,"n_cols":18,"rows_kept":16}
["1.单击单元格 B13 激活名为“销量总和”的数据透视表。\n\n"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.使用 Tab 键、箭头键和空格键来修改示例，使其在左侧显示“销售代表”，并在其下面缩进“季度”。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"康迈克\",$C$14=5036),\"好样的！现在数据\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"康迈克\",$C$14=5036),\"更容易阅读。向下滚动\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$14=\"康迈克\",$C$14=5036),\"并单击“下一步”...\",\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,null,"Column Labels"]
[null,null,"康迈克",{"$nulls":3},"康迈克 Total","贾文",{"$nulls":3},"贾文 Total","陶湘",{"$nulls":3},"陶湘 Total","Grand Total"]
[null,null,"秋季","春季","夏季","冬季",null,"秋季","春季","夏季","冬季",null,"秋季","春季","夏季","冬季"]
[null,"销量总和",{"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.单击单元格 B13 激活名为“销量总和”的数据透视表。"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。注意：如果“字段”列表没有启动，请再次按 Alt+JT、L。"]
["3.使用 Tab 键、箭头键和空格键来修改示例，使每个“销售代表”的列字段左侧为“季度”，其下面为“产品”缩进。"]
["4.选择单元格 I9，选择康迈克在冬季卖出的西柚的数量。"]
["若要继续学习本教程，请按 Ctrl+Page Down。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[{"$nulls":8},"选择一个："]
[]
[{"$nulls":8},{"$f":"IF($I$9=400,\"做得对！\",IF($I$9=530,\"再试一次...\",IF($I$9=123,\"尚未完成...\",\" \")))","v":" "}]
[]
[]
[null,"销量总和"]
[null,{"v":17758,"d":"17,758 "}]

{"sheet":"了解详细信息","index":25,"n_rows":7,"n_cols":1,"rows_kept":7}
["干得好。数据透视表是不是很棒？"]
["但我们鼓励你继续查看！还可发现更多内容..."]
["更多数据透视表信息\n阅读此数据透视表相关帮助文章，发现更多可以完成的操作。"]
["有关刷新\n阅读这篇关于如何刷新数据透视表的重要文章。 "]
["社区\n与其他 Excel 爱好者相连。你和他们可相互帮助。"]
[]
[" "]