{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["开始","1","2","3","4","5","了解详细信息"],"not_rendered":{"images":12,"defined_names":8,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["欢迎\n屏幕阅读器说明：Excel 提示及技巧。在本教程中接下来的五张工作表中，了解有趣的 Excel 提示及技巧。每个工作表的说明在单元格 A1 中开始，每个后续步骤在 A2、A3 等单元格中。\n说明将指示要导航到哪些单元格以使用功能或进一步阅读。"]
["提示与技巧"]
["准备好提高工作效率了吗？这里有五个快速提示，可帮助你在 Excel 中节省时间。\n\n"]
["按 Ctrl+Home 返回页首。若要开始教程，请按 Ctrl+Page Down。"]

{"sheet":"1","index":1,"n_rows":13,"n_cols":5,"rows_kept":13}
["提示 #1：推荐的图表。单元格 B7 到 E13 中有一个数据表。导航到该区域内的任意单元格，然后按 ALT+N > R 以启动“推荐的图表”对话框。按 Tab，然后使用向上/向下键滚动浏览选项。按 Enter 在工作表上插入所选图表。"]
["你知道吗？\n你的 Excel 版本提供许多图表可供选择。但在 Excel for Office 365 中，还提供更新的图表，如漏斗图、瀑布图，甚至填充地图。"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[null,"产品","1 月","2 月","3 月"]
[null,"苹果",500,700,300]
[null,"橙子",600,{"v":1010,"d":"1,010"},200]
[null,"香蕉",800,500,400]
[null,"柠檬",700,200,560]
[null,"樱桃",{"v":1010,"d":"1,010"},300,734]
[null,"梨",500,100,234]

{"sheet":"2","index":2,"n_rows":17,"n_cols":3,"rows_kept":17}
["提示 #2：快速填充。在单元格 C8 中键入“Xiang.Tao”，然后按 Enter。接下来，按 Ctrl+E 填充 C8 中示例后面的空白单元格。也可以输入“陶，湘”或所需的其他任意组合。"]
["你知道吗？\n如果导入和刷新了数据，快速填充将不会再次进行自动清理。但是，如果升级到 Excel for Office 365，就可以使用新的“获取数据”按钮。该按钮可用于导入和清理数据。随后，如果需要刷新数据，Excel 将清除任何新加入的数据。 "]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+Page Up。"]
[]
[]
[]
[null,"产品","姓名"]
[null,"Xiang.Tao@contoso.com"]
[null,"Shen.Mai@fabrikam.com"]
[null,"Michael.Kang@relecloud.com"]
[null,"Dewei.Peng@contoso.com"]
[null,"Kuan-Yin.Tu@fabrikam.com"]
[null,"Qiang.Chiu@relecloud.com"]
[null,"Ming.Ts'ui@contoso.com"]
[null,"Zhen.Sung@fabrikam.com"]
[null,"Michael.Kang@relecloud.com"]
[null,"Sun.Pai@fabrikam.com "]

{"sheet":"3","index":3,"n_rows":3,"n_cols":1,"rows_kept":3}
["提示 #3：共同创作。将 Excel 文件上传到 OneDrive.com 并共享它，这样大家就可以使用 Web 浏览器同时编辑它了。"]
["你知道吗？\n如果你和你的同事升级到 Excel for Office 365，你们就不限于在 Web 浏览器中共同创作了。你们可以使用 Excel 桌面应用同时进行编辑。 "]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+PageUp。"]

{"sheet":"4","index":4,"n_rows":117,"n_cols":6,"rows_kept":117}
["提示 #4：表格数据透视表。在此数据透视表中，单元格 B8 标题中有一个名为“行标签”的标签，但它不是很具体。单击数据透视表中的任意位置（从单元格 B7 到 F15），然后在“设计”选项卡上单击“报表布局”>“以表格形式显示”。这样好多了。"]
["你知道吗？\n如果升级到 Excel for Office 365，就可以选择喜欢的数据透视表布局设置。这样，就不必每次创建新数据透视表时都更改布局了。 "]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+PageUp。"]
[]
[]
[]
[null,"求和项:支出","列标签"]
[null,"行标签","燃气","日用品","食品","水电费"]
[null,"康霓",{"v":55,"d":"¥55"},null,{"v":325,"d":"¥325"},{"v":55,"d":"¥55"}]
[null,"孔西明",{"v":95,"d":"¥95"},null,null,{"v":95,"d":"¥95"}]
[null,"廖磊",null,{"v":250,"d":"¥250"},{"v":250,"d":"¥250"},{"v":250,"d":"¥250"}]
[null,"林恪",null,{"v":125,"d":"¥125"},{"v":20,"d":"¥20"},{"v":270,"d":"¥270"}]
[null,"任月英",{"v":325,"d":"¥325"},null,{"v":325,"d":"¥325"}]
[null,"王锷",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"}]
[null,"袁洛",{"v":95,"d":"¥95"},null,{"v":250,"d":"¥250"}]
{"$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-01-17","王锷","日用品",{"v":100,"d":"¥100"}]
[null,"2017-01-21","王锷","燃气",{"v":75,"d":"¥75"}]
[null,"2017-02-02","康霓","燃气",{"v":55,"d":"¥55"}]
[null,"2017-02-20","林恪","水电费",{"v":20,"d":"¥20"}]
[null,"2017-02-25","林恪","水电费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","孔西明","燃气",{"v":95,"d":"¥95"}]
[null,"2017-02-20","任月英","食品",{"v":325,"d":"¥325"}]
[null,"2017-02-25","廖磊","食品",{"v":250,"d":"¥250"}]
[null,"2017-02-20","任月英","燃气",{"v":325,"d":"¥325"}]
[null,"2017-02-25","廖磊","日用品",{"v":250,"d":"¥250"}]
[null,"2017-02-20","林恪","食品",{"v":20,"d":"¥20"}]
[null,"2017-02-25","林恪","水电费",{"v":125,"d":"¥125"}]
[null,"2017-02-02","康霓","水电费",{"v":55,"d":"¥55"}]
[null,"2017-02-02","孔西明","水电费",{"v":95,"d":"¥95"}]
[null,"2017-02-25","廖磊","水电费",{"v":250,"d":"¥250"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":4,"rows_kept":17}
["提示 #5：使用 IF 函数。导航到 D8 单元格，然后按 F2 进入编辑模式并查看公式。如果高声朗读，Excel 将会朗读：如果 C8 大于或等于 70，则显示“是”，否则显示“否”。"]
["你知道吗？\n在 Excel for Office 365 中，可使用新的 IFS 函数来指定多个条件，而不止一个。"]
["示例：=IFS(C8>=90,\"A\",\nC8>=80,\"B\",\nC8>70,\"C\",\nC8>=60,\"D\",\nTRUE,\"F\")"]
["若要继续学习本教程，请按 Ctrl+PageDown。若要转到上一个工作表，请按 Ctrl+PageUp。"]
[]
[]
[null,"学生","得分","及格成绩？"]
[null,"陶湘",78,{"$f":"IF(C8>=70,\"是\",\"否\")","v":"是"}]
[null,"米申",90,"是"]
[null,"康迈克",85,"是"]
[null,"彭德威",27,"否"]
[null,"杜梡寅",57,"否"]
[null,"赵强",78,"是"]
[null,"徐铭",81,"是"]
[null,"宋臻",44,"否"]
[null,"康迈克",65,"否"]
[null,"柏隼",70,"是"]

{"sheet":"了解详细信息","index":6,"n_rows":5,"n_cols":1,"rows_kept":5}
["好样的"]
["浏览到这里，请查看其他这些有用的页面。"]
["为什么要升级？了解升级到 Office 365 时可执行的其他操作。"]
["键入提示 - 查看 Excel 中键盘快捷方式的方便列表"]
["社区 - 提问并与其他 Excel 爱好者联系。"]