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

{"sheet":"开始","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["欢迎\n用于屏幕阅读器的说明：制作你的第一张数据透视表。数据透视表不像你想的那样困难。学习了本教程中 21 张工作表后，将知道如何快速创建一个。每个工作表的说明在单元格 A1 中开始，每个后续步骤在 A2、A3 等单元格中。\n说明将指示要导航到哪些单元格以使用功能或进一步阅读。\n若要开始，请按 Ctrl+PageDown。"]
["制作你的第一张数据透视表"]
["数据透视表不像你想的那样困难。学习了这些简单步骤后，\n将知道如何快速创建一个。"]
["按 Ctrl+Home 返回页首。若要开始教程，请按 Ctrl+PageDown。"]

{"sheet":"1","index":1,"n_rows":17,"n_cols":9,"rows_kept":17}
["什么是数据透视表？在最基本的数据透视表形式中，数据透视表获取数据并进行汇总，这样人们能够了解数字含义，而无需键入任何公式！"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 H10 到 I14 包含对数据进行汇总的数据透视表。数据透视表有两列：“购买者”和“求和项:金额”。“购买者”列包含值“爸爸”、“妈妈”、“康霓”和“总计”；“求和项:金额”列包含值“¥20”、“¥544”、“¥270”和“¥834”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"购买者","求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,"爸爸",{"v":20,"d":"¥20"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,null,"康霓",{"v":270,"d":"¥270"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,null,"妈妈",{"v":544,"d":"¥544"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,null,"总计",{"v":834,"d":"¥834"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]

{"sheet":"2","index":2,"n_rows":18,"n_cols":11,"rows_kept":18}
["这是一个简单的示例。这有一个更复杂的。它显示按购买类型和购买者划分的支出金额。"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 G10 到 K18 包含更复杂的数据透视表，对数据进行汇总。数据透视表有五列：类型、爸爸、康霓、妈妈和总计。“类型”列包含值“书籍”、“食品”、“油费”、“音乐”、“运动”和“门票”。“爸爸”、“康霓”和“妈妈”列包含各种金额（美元），“总计”列包含每种类型的总金额。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,"求和项:金额","购买者"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,"类型","爸爸","康霓","妈妈","总计"]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,"门票",null,{"v":125,"d":"¥125"},null,{"v":125,"d":"¥125"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,"食品",null,null,{"v":470,"d":"¥470"},{"v":470,"d":"¥470"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,"书籍",null,{"v":125,"d":"¥125"},null,{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"},null,"音乐",null,{"v":20,"d":"¥20"},null,{"v":20,"d":"¥20"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"},null,"油费",null,null,{"v":74,"d":"¥74"},{"v":74,"d":"¥74"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"},null,"运动",{"v":20,"d":"¥20"},null,null,{"v":20,"d":"¥20"}]
[{"$nulls":6},"总计",{"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}
["还有数据透视图，让人更直观的了解数据及其汇总。我们不会介绍，但要知道它们存在。"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["数据右侧是数据透视图，其中汇总并直观显示了数据。若要选择它，请按 Alt+H、FD、P。然后使用箭头键移动到数据透视图示例并按 Enter。完成后，按 CTRL+G，键入 A4，再按 Enter。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,"求和项:金额","列标签"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,"行标签","爸爸","康霓","妈妈","总计"]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,"门票",null,{"v":125,"d":"¥125"},null,{"v":125,"d":"¥125"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,"食品",null,null,{"v":470,"d":"¥470"},{"v":470,"d":"¥470"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,"书籍",null,{"v":125,"d":"¥125"},null,{"v":125,"d":"¥125"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"},null,"音乐",null,{"v":20,"d":"¥20"},null,{"v":20,"d":"¥20"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"},null,"油费",null,null,{"v":74,"d":"¥74"},{"v":74,"d":"¥74"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"},null,"运动",{"v":20,"d":"¥20"},null,null,{"v":20,"d":"¥20"}]
[{"$nulls":6},"总计",{"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}
["然后我们回来。要制成好的数据透视表，先要确保数据的良好恰当。因此在创建前确保执行以下操作： "]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。每列均包含值，且没有重复值和空值。"]
["有一个指向列的标签，显示有“命名你的列”。还有一个指向行的标签，显示有“并且确保没有重复的行或空单元格”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":5,"rows_kept":17}
["请记住：很多人会用“列”这个词。但对数据透视表来说，列就是一个“字段”。在学习本教程时随时记着这点。"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。每列都有一个指向它的标签，上面显示有“字段”。"]
["扩展知识：为什么使用“字段”这个词？它只是一个传统术语，用在处理数据和数据表时。数据透视表菜单和按钮大量使用“字段”一词。如果现在习惯了它，制作数据透视表时将事半功倍。 "]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"6","index":6,"n_rows":17,"n_cols":5,"rows_kept":17}
["我们重点看一个字段。下面的一个字段 -“金额”可能是最重要的。如果对其求和，岂不是很好？"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。“金额”列有一个指向它的标签，显示有“应对此字段求和”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"7","index":7,"n_rows":17,"n_cols":8,"rows_kept":17}
["我们做到了。我们用数据透视表对“金额”字段进行了求和。（真的吗？）是的。“求和项:金额”和“¥834”构成了一张小的数据透视表，将“金额”字段汇总求和。 "]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 H10 和 H11 包含汇总“金额”列的数据透视表。数据透视表有一列：求和项:金额。而该列仅有一个值：¥834。有一个指向数据透视表的标签，显示有“它看起来内容很少，但确实是一个数据透视表。”"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,{"v":834,"d":"¥834"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":8,"rows_kept":18}
["为什么制作如此小的数据透视表？因为它强调了数据透视表值字段的概念。如果数据中的一个字段包含数字值，数据透视表就可以汇总求和。汇总求和后，它被称为数据透视表值字段。"]
["单元格 B11 到 E18 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。有一个指向“金额”列的标签，显示有“此字段包含数字值...”"]
["单元格 H11 和 H12 包含汇总“金额”列的数据透视表。数据透视表有一列：求和项:金额。而该列仅有一个值：¥834。有一个指向数据透视表的标签，显示有“…并且此数据透视表将其转变成‘值字段’。”"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,{"v":834,"d":"¥834"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"9","index":9,"n_rows":18,"n_cols":9,"rows_kept":18}
["当你添加划分值字段的条件时数据透视表开始变得有趣。本例中，我们添加了新的条件“购买者”来划分值字段。 "]
["单元格 B11 到 E18 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 H11 到 I15 包含对数据进行汇总的数据透视表。数据透视表有两列：“购买者”和“求和项:金额”。“购买者”列包含值“爸爸”、“康霓”、“妈妈”和“总计”；“求和项:金额”列包含值“¥20”、“¥544”、“¥270”和“¥834”。有一个指向“购买者”列的标签，显示有“我们在此添加了一个条件，按‘购买者’划分值字段。”还有一个指向“求和项:金额”的标签，显示有“值字段”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"购买者","求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,"爸爸",{"v":20,"d":"¥20"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,null,"康霓",{"v":270,"d":"¥270"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,null,"妈妈",{"v":544,"d":"¥544"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,null,"总计",{"v":834,"d":"¥834"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]

{"sheet":"10","index":10,"n_rows":17,"n_cols":9,"rows_kept":17}
["还有另一个数据透视表，这次我们添加的条件是“类型”，看看每种购买类型花费了多少钱。"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 H10 到 I17 包含对数据进行汇总的数据透视表。数据透视表有两列：“类型”和“求和项:金额”。“类型”列包含值“书籍”、“食品”、“油费”、“音乐”、“运动”、“门票”和“总计”；“求和项:金额”列包含值“¥125”、“¥470”、“¥74”、“¥20”、“¥20”、“¥125”和“¥834”。有一个指向“类型”列的标签，显示有“我们在此添加了一个条件，按‘类型’划分值字段。”还有一个指向“求和项:金额”的标签，显示有“值字段”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"类型","求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,"门票",{"v":125,"d":"¥125"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,null,"食品",{"v":470,"d":"¥470"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,null,"书籍",{"v":125,"d":"¥125"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,null,"音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"},null,null,"油费",{"v":74,"d":"¥74"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"},null,null,"运动",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"},null,null,"总计",{"v":834,"d":"¥834"}]

{"sheet":"11","index":11,"n_rows":17,"n_cols":9,"rows_kept":17}
["另一个数据透视表术语：我们目前添加的条件称之为数据透视表行字段。这些示例中，依据行字段对值字段进行划分。"]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["单元格 H10 到 I14 包含对数据进行汇总的数据透视表。数据透视表有两列：“购买者”和“求和项:金额”。“购买者”列包含值“爸爸”、“康霓”、“妈妈”和“总计”；“求和项:金额”列包含值“¥20”、“¥544”、“¥270”和“¥834”。有一个指向“购买者”列的标签，显示有“行字段”。还有一个指向“求和项:金额”列的标签，显示有“值字段”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"购买者","求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,"爸爸",{"v":20,"d":"¥20"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,null,"康霓",{"v":270,"d":"¥270"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,null,"妈妈",{"v":544,"d":"¥544"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,null,"总计",{"v":834,"d":"¥834"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]

{"sheet":"12","index":12,"n_rows":17,"n_cols":9,"rows_kept":17}
["复习。稍后将了解如何实际操作创建数据透视表。但我们先复习下目前为止已学习的概念："]
["单元格 B10 到 E17 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。有一个指向数据的标签，显示有“先从良好数据开始。”"]
["单元格 H10 到 I14 包含对数据进行汇总的数据透视表。 "]
["数据透视表有两列：“购买者”和“求和项:金额”。“购买者”列包含值“爸爸”、“康霓”、“妈妈”和“总计”。“求和项:金额”列包含值“¥20”、“¥270”、“¥544”和“¥834”。有一个指向“购买者”列的标签，显示有“‘行字段’划分…”还有一个指向“求和项:金额”列的标签，显示有“…‘值字段’”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[null,"日期","购买者","类型","金额",null,null,"购买者","求和项:金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"},null,null,"爸爸",{"v":20,"d":"¥20"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"},null,null,"康霓",{"v":270,"d":"¥270"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"},null,null,"妈妈",{"v":544,"d":"¥544"}]
[null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"},null,null,"总计",{"v":834,"d":"¥834"}]
[null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]

{"sheet":"13","index":13,"n_rows":21,"n_cols":6,"rows_kept":21}
["稍后创建数据透视表时，将看到“数据透视表字段”列表。但它不仅是一个列表，更像是一个面板。将在顶部看到数据中的字段。 "]
["单元格 C14 到 F21 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["有一个指向数据字段的标签，显示有“Excel 查看你的数据...”"]
["有一个箭头从字段名称的顶部开始并指向“数据透视表字段”列表图的相同字段名称。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":8}
[null,null,"日期","购买者","类型","金额"]
[null,null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[null,null,"2017-01-21","康霓","书籍",{"v":125,"d":"¥125"}]
[null,null,"2017-02-02","妈妈","食品",{"v":235,"d":"¥235"}]
[null,null,"2017-02-20","康霓","音乐",{"v":20,"d":"¥20"}]
[null,null,"2017-02-25","康霓","门票",{"v":125,"d":"¥125"}]

{"sheet":"14","index":14,"n_rows":4,"n_cols":1,"rows_kept":4}
["不会立马生成数据透视表，但几个步骤后，将看到一张数据透视表。首先是创建值字段。将“金额”字段拖到“值”区域即可完成。"]
["“数据透视表字段”列表图显示一个箭头光标，将“金额”字段拖到“值”区域。"]
["最佳做法：对你而言，如果不确定如何开始创建数据透视表，可以考虑首先创建值字段。最适合值字段的字段是具有数值的字段。此示例中，“金额”为最佳选择。其他字段（日期、购买者、类型）不包含数值，因此它们不是值字段的最佳选择。  \n"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+Page Up。"]

{"sheet":"15","index":15,"n_rows":13,"n_cols":5,"rows_kept":13}
["将字段拖到“值”区域后，“求和项：金额”将显示在“数据透视表字段列表”底部。（有时 Excel 没有空间来显示完整名称 -“求和项：金额”。）"]
["单元格 E12 和 E13 包含汇总“金额”列的数据透视表。数据透视表有一列：求和项:金额。而该列仅有一个值：¥834。有一个指向数据透视表的标签，显示有“创建值字段将加总‘金额’字段并生成如下的小数据透视表”。"]
["“数据透视表字段”列表图显示了“值”区域中突出显示的“求和项：金额”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":7}
[{"$nulls":4},"求和项:金额"]
[{"$nulls":4},{"v":834,"d":"¥834"}]

{"sheet":"16","index":16,"n_rows":13,"n_cols":5,"rows_kept":13}
["然后需要一个划分值字段所依据的条件。为此，将任何其他字段向下拖到“行”区域。 "]
["“数据透视表字段”列表图显示一个箭头光标，将“购买者”字段拖到“行”区域。“行”区域突出显示。"]
["单元格 E12 和 E13 包含汇总“金额”列的数据透视表。数据透视表有一列：求和项:金额。而该列仅有一个值：¥834。 "]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":7}
[{"$nulls":4},"求和项:金额"]
[{"$nulls":4},{"v":834,"d":"¥834"}]

{"sheet":"17","index":17,"n_rows":16,"n_cols":5,"rows_kept":16}
["“购买者”字段位于行区域，因此将在数据透视表中看到每个购买者的购买金额。稍后将看到这有多么简单…并且很棒的是，不需要键入任何公式！"]
["单元格 D12 和 E16 包含数据透视表。数据透视表有两列：“行标签”和“求和项:金额”。“行标签”包含值“爸爸”、“康霓”、“妈妈”和“总计”。“求和项:金额”包含值“¥20”、“¥270”、“¥544”和“¥834”。 "]
["有一个指向“行标签”列的标签，显示有“行字段‘购买者’”；还有一个指向“求和项:金额”列的标签，显示有“划分值字段‘求和项:金额’。”"]
["“数据透视表字段”列表图显示了“行”区域中突出显示的“购买者”。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"行标签","求和项:金额"]
[{"$nulls":3},"爸爸",{"v":20,"d":"¥20"}]
[{"$nulls":3},"康霓",{"v":270,"d":"¥270"}]
[{"$nulls":3},"妈妈",{"v":544,"d":"¥544"}]
[{"$nulls":3},"总计",{"v":834,"d":"¥834"}]

{"sheet":"18","index":18,"n_rows":21,"n_cols":8,"rows_kept":21}
["使用“数据透视表字段”列表"]
["单元格 B14 到 E21 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["1.单元格 H14 到 J31 是数据透视表区域。导航到其中任意单元格。"]
["2.按 Alt+JT、L 启动“数据透视表字段”列表。焦点默认位于“搜索”文本框：“键入要搜索的字词”编辑框。不要键入任何内容，而是按一次 Tab。"]
["3.按箭头键移到“金额”字段。按空格键将“金额”字段添加到“值”区域。 "]
["4.按箭头键移到“购买者”字段。按空格键将“购买者”字段添加到“行”区域。按 Esc 键退出“数据透视表字段”窗格。"]
["注意：完成步骤 3 和 4 后，可能需要加宽列来查看数据透视表中的所有文本和数字。（这是创建数据透视表后需执行的一个常见“额外步骤”。）"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($H$14=\"购买者\",$I$18=834),\"好样的！你已正确放置了字段。\",\" \")","v":" "}]
[]
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"19","index":19,"n_rows":7,"n_cols":1,"rows_kept":7}
["接下来，将从头创建数据透视表。创建时，需要记住：Excel 将数据透视表放在当前工作表左侧的新的独立工作表上。 "]
["有一张图片显示名为 17、18、19、20 的 4 张工作表标签，以及“了解详细信息”。20 是活动的标签页。"]
["图片下方有说明文字显示“例如，假设你的数据位于名为‘20’的工作表上。如果你创建了数据透视表…”"]
["有一张图片显示名为“Sheet12”的新工作表标签页，它位于工作表 19 和 20 之间。"]
["如果你创建了数据透视表，Excel 会将其放在左侧的新工作表上。将其命名为“Sheet”，并向其分配一个数字，如“12”、“13”等。可始终选择该工作表，Alt+H、O、R，并将其命名为其他名称，如“数据透视表”。"]
["为什么会这样？你看，数据透视表的完整名称是：数据透视表报表。报表基于数据，通常人们倾向于将报表独立于数据本身来看待。现在，可以将数据透视表放在数据所在的同一工作表。但大多数时候，数据透视表需要占用大量空间，因此最好将它放在新工作表上。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+Page Up。"]

{"sheet":"20","index":20,"n_rows":22,"n_cols":5,"rows_kept":22}
["从头开始创建数据透视表"]
["单元格 B15 到 E22 包含数据。有四列：日期、购买者、类型和金额。各列的各行中有各种值。"]
["1.导航到任意数据单元格。"]
["2.请记住，步骤 4 之后将创建新的工作表。在此情况下，务必使用 Alt+JT、L 打开“数据透视表字段”列表（如未打开）。然后向“值”区域添加“金额”字段，向“行”区域添加“购买者”字段。"]
["3.按 Alt+N、V 转到“创建数据透视表”对话框。"]
["4.按 Enter 接受默认选项。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一张工作表，请按 Ctrl+Page Up。"]
{"$rows_empty":7}
[null,"日期","购买者","类型","金额"]
[null,"2017-01-01","妈妈","油费",{"v":74,"d":"¥74"}]
[null,"2017-01-15","妈妈","食品",{"v":235,"d":"¥235"}]
[null,"2017-01-17","爸爸","运动",{"v":20,"d":"¥20"}]
[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"}]

{"sheet":"了解详细信息","index":21,"n_rows":5,"n_cols":1,"rows_kept":5}
["干得好。成功了。"]
["但保持前进！以下是更多学习内容..."]
["更多数据透视表信息：阅读此数据透视表相关帮助文章，发现更多可以完成的操作。"]
["有效数据是关键：Excel 可提供帮助。查看本文，了解有关获取和转换的详细信息。"]
["社区：与其他 Excel 爱好者相连。他们可以帮助你，你可以帮助他们。"]