{"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 的祕訣和訣竅。在本教學課程的後續 5 個工作表中，挑選有趣的 Excel 祕訣和訣竅。每個工作表的指示都從儲存格 A1 開始，而每個後續步驟則在儲存格 A2、A3 等儲存格中。\n指示會指出要瀏覽到哪個儲存格，以便使用特定功能或進一步閱讀詳細資訊。"]
["祕訣和訣竅"]
["準備好提高生產力了嗎？以下是保證能讓您在 Excel 中節省時間的\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 版本有很多圖表可供選擇。但在 Office 365 的 Excel 中，有更新的圖表可供使用，例如漏斗圖、瀑布圖，甚至是區域分布圖。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 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 中輸入 \"Nancy Smith\"，然後按 Enter。接下來，按 CTRL+E 以填入 C8 的範例後面的空白儲存格。您也可以輸入 \"Smith, Nancy\"，或您喜歡的任何其他組合。"]
["您知道嗎...\n如果您的資料已匯入並重新整理，[快速填入] 不會再次進行自動清理。不過，如果您升級到 Office 365 的 Excel，您可以使用全新的 [取得資料] 按鈕。該按鈕可讓您匯入和清理資料。之後，如果您需要重新整理資料，Excel 會清理匯入的任何新資料。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[null,"產品","名字和姓氏"]
[null,"Nancy.Smith@contoso.com"]
[null,"Andy.North@fabrikam.com"]
[null,"Dave.Ludwig@relecloud.com"]
[null,"Chuck.Degrute@contoso.com"]
[null,"Alfred.Cortland@fabrikam.com"]
[null,"John.Massente@relecloud.com"]
[null,"Geoff.Moore@contoso.com"]
[null,"Jorge.Johnson@fabrikam.com"]
[null,"Dave.Ludwig@relecloud.com"]
[null,"Yvonne.McKay@fabrikam.com "]

{"sheet":"3","index":3,"n_rows":3,"n_cols":1,"rows_kept":3}
["祕訣 #3：共同撰寫。將 Excel 檔案上傳到 OneDrive.com，共用該檔案，這樣所有人就可以同時使用網頁瀏覽器來編輯檔案。"]
["您知道嗎...\n如果您和您的同儕都升級到 Office 365 的 Excel，就不會受限於需要使用網頁瀏覽器來進行共同撰寫。您可以使用 Excel 傳統型應用程式來同時進行編輯。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]

{"sheet":"4","index":4,"n_rows":117,"n_cols":6,"rows_kept":117}
["祕訣 #4：表格式樞紐分析表。在此樞紐分析表中，儲存格 B8 中有一個標題為「列標籤」的標籤，但它沒有非常明確。在樞紐分析表內按一下任何位置 (從儲存格 B7 到 F15)，然後在 [設計] 索引標籤上，按一下 [報表版面配置] > [以列表方式顯示]。這樣看起來好多了。"]
["您知道嗎...\n如果您升級到 Office 365 的 Excel，您可以選擇您偏好使用的樞紐分析表版面配置設定。如此一來，您就不必在每次建立新樞紐分析表時變更版面配置。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[null,"加總 - 支出","欄標籤"]
[null,"列標籤","日用品","水電費","瓦斯費","伙食"]
[null,"立民",null,{"v":95,"d":"HK$95.00"},{"v":95,"d":"HK$95.00"}]
[null,"邦良",{"v":250,"d":"HK$250.00"},{"v":250,"d":"HK$250.00"},null,{"v":250,"d":"HK$250.00"}]
[null,"冠廷",null,null,{"v":95,"d":"HK$95.00"},{"v":250,"d":"HK$250.00"}]
[null,"庭宇",{"v":125,"d":"HK$125.00"},{"v":270,"d":"HK$270.00"},null,{"v":20,"d":"HK$20.00"}]
[null,"捷生",{"v":100,"d":"HK$100.00"},null,{"v":75,"d":"HK$75.00"}]
[null,"梨莎",null,{"v":55,"d":"HK$55.00"},{"v":55,"d":"HK$55.00"},{"v":325,"d":"HK$325.00"}]
[null,"舒慧",null,null,{"v":325,"d":"HK$325.00"},{"v":325,"d":"HK$325.00"}]
{"$rows_empty":82}
[null,"日期","家庭成員","購買類型","支出"]
[null,"2017-01-01","冠廷","瓦斯費",{"v":95,"d":"HK$95.00"}]
[null,"2017-01-15","梨莎","伙食",{"v":325,"d":"HK$325.00"}]
[null,"2017-01-17","冠廷","伙食",{"v":250,"d":"HK$250.00"}]
[null,"2017-01-21","庭宇","日用品",{"v":125,"d":"HK$125.00"}]
[null,"2017-01-17","捷生","日用品",{"v":100,"d":"HK$100.00"}]
[null,"2017-01-21","捷生","瓦斯費",{"v":75,"d":"HK$75.00"}]
[null,"2017-02-02","梨莎","瓦斯費",{"v":55,"d":"HK$55.00"}]
[null,"2017-02-20","庭宇","水電費",{"v":20,"d":"HK$20.00"}]
[null,"2017-02-25","庭宇","水電費",{"v":125,"d":"HK$125.00"}]
[null,"2017-02-02","立民","瓦斯費",{"v":95,"d":"HK$95.00"}]
[null,"2017-02-20","舒慧","伙食",{"v":325,"d":"HK$325.00"}]
[null,"2017-02-25","邦良","伙食",{"v":250,"d":"HK$250.00"}]
[null,"2017-02-20","舒慧","瓦斯費",{"v":325,"d":"HK$325.00"}]
[null,"2017-02-25","邦良","日用品",{"v":250,"d":"HK$250.00"}]
[null,"2017-02-20","庭宇","伙食",{"v":20,"d":"HK$20.00"}]
[null,"2017-02-25","庭宇","水電費",{"v":125,"d":"HK$125.00"}]
[null,"2017-02-02","梨莎","水電費",{"v":55,"d":"HK$55.00"}]
[null,"2017-02-02","立民","水電費",{"v":95,"d":"HK$95.00"}]
[null,"2017-02-25","邦良","水電費",{"v":250,"d":"HK$250.00"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":4,"rows_kept":17}
["祕訣 #5：使用 IF 函數。瀏覽到儲存格 D8，然後按 F2 以進入 [編輯] 模式並檢視公式。如果大聲唸出，Excel 會朗讀：如果 C8 大於或等於 70，則會顯示 [是]，如果不是，則會顯示 [否]。"]
["您知道嗎...\n在 Office 365 的 Excel 中，您可以使用全新的 IFS 函數來指定多個條件，而不只是指定一個條件。"]
["範例：=IFS(C8>=90,\"A\",\nC8>=80,\"B\",\nC8>70,\"C\",\nC8>=60,\"D\",\nTRUE,\"F\")"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[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 粉絲交流互動。"]