{"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":6,"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 中資料的樞紐分析表。此樞紐分析表有兩個欄：[購買者] 和 [總金額]。[購買者] 欄包含的值有 [爸爸]、[媽媽]、[梨莎] 和 [總計]；而 [總金額] 欄包含的值則有 [NT$220]、[NT$270]、[NT$810] 和 [NT$1,300]。[購買者] 欄由 [列] 欄位組成，而 [總金額] 欄由 [值] 欄位組成。"]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額"]
["此範例顯示列欄位如何...","2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
["...分割值欄位。","2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"},null,null,"購買者","總金額"]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"},null,null,"爸爸",{"v":220,"d":"NT$220"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"},null,null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"媽媽",{"v":810,"d":"NT$810"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"},null,null,"Grand Total",{"v":1300,"d":"NT$1,300"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$125"}]

{"sheet":"2","index":2,"n_rows":108,"n_cols":7,"rows_kept":108}
["但是當您第一次看某個樞紐分析表時，您可能覺得需要從中得到更多解答。"]
["當您第一次看某個樞紐分析表時，您可能會有如下的問題：「在何時購買？」、「每個人將錢花費在哪些項目上？」、「媽媽買了什麼那麼貴？」。"]
["在本範例中，儲存格 F11 到 G15 顯示與之前相同的兩欄樞紐分析表。[購買者] 欄是列欄位，包含的值有 [爸爸]、[媽媽]、[梨莎] 和 [總計]；而 [總金額] 欄是值欄位，包含的值有 [NT$220]、[NT$270]、[NT$810] 和 [NT$1,300]。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"購買者","總金額"]
[{"$nulls":5},"爸爸",{"v":220,"d":"NT$220"}]
[{"$nulls":5},"梨莎",{"v":270,"d":"NT$270"}]
[{"$nulls":5},"媽媽",{"v":810,"d":"NT$810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":84}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$125"}]

{"sheet":"3","index":3,"n_rows":108,"n_cols":7,"rows_kept":108}
["這些問題都很好，但現在我們先只關注一個問題。"]
["每個人將錢花費在哪些項目上？"]
["供您參考，儲存格 F11 到 G15 顯示與之前相同的兩欄樞紐分析表。[購買者] 欄是列欄位，包含的值有 [爸爸]、[媽媽]、[梨莎] 和 [總計]；而 [總金額] 欄是值欄位，包含的值有 [NT$220]、[NT$270]、[NT$810] 和 [NT$1,300]。 "]
["若要繼續使用本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"購買者","總金額"]
[{"$nulls":5},"爸爸",{"v":220,"d":"NT$220"}]
[{"$nulls":5},"梨莎",{"v":270,"d":"NT$270"}]
[{"$nulls":5},"媽媽",{"v":810,"d":"NT$810"}]
[{"$nulls":5},"Grand Total",{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":84}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$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":"NT$125"},{"$nulls":3},{"v":95,"d":"NT$95"},{"v":220,"d":"NT$220"}]
[null,null,"梨莎",null,{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":125,"d":"NT$125"},null,{"v":270,"d":"NT$270"}]
[null,null,"媽媽",{"v":560,"d":"NT$560"},null,null,{"v":250,"d":"NT$250"},null,{"v":810,"d":"NT$810"}]
[null,null,"Grand Total",{"v":685,"d":"NT$685"},{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":375,"d":"NT$375"},{"v":95,"d":"NT$95"},{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":84}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$125"}]

{"sheet":"5","index":5,"n_rows":108,"n_cols":9,"rows_kept":108}
["如果樞紐分析表令人難以理解，請試試看：從左邊讀起，然後從上面，再往下讀。在下方的範例中，[爸爸] 在儲存格 C12、[食物] 的 [NT$125] 在儲存格 D12 中、[禮物] 的 [NT$95] 在儲存格 E12 中，而 [總計] 的 [NT$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":"NT$125"},{"v":95,"d":"NT$95"},{"$nulls":3},{"v":220,"d":"NT$220"}]
[null,null,"梨莎",null,null,{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":125,"d":"NT$125"},{"v":270,"d":"NT$270"}]
[null,null,"媽媽",{"v":560,"d":"NT$560"},{"$nulls":3},{"v":250,"d":"NT$250"},{"v":810,"d":"NT$810"}]
[null,null,"Grand Total",{"v":685,"d":"NT$685"},{"v":95,"d":"NT$95"},{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":375,"d":"NT$375"},{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":84}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$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+PAGE DOWN。若要移至上一個工作表，請按 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":"NT$220"}]
[null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"媽媽",{"v":810,"d":"NT$810"}]
[null,"總計",{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":82}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$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":125,"d":"NT$125"},{"v":95,"d":"NT$95"},{"$nulls":3},{"v":220,"d":"NT$220"}]
[null,null,"梨莎",null,null,{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":125,"d":"NT$125"},{"v":270,"d":"NT$270"}]
[null,null,"媽媽",{"v":560,"d":"NT$560"},{"$nulls":3},{"v":250,"d":"NT$250"},{"v":810,"d":"NT$810"}]
[null,null,"Grand Total",{"v":685,"d":"NT$685"},{"v":95,"d":"NT$95"},{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":375,"d":"NT$375"},{"v":1300,"d":"NT$1,300"}]
{"$rows_empty":85}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","爸爸","禮物",{"v":95,"d":"NT$95"}]
[null,"2017-01-15","媽媽","食物",{"v":325,"d":"NT$325"}]
[null,"2017-01-17","媽媽","票券",{"v":250,"d":"NT$250"}]
[null,"2017-01-21","爸爸","食物",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","運動",{"v":125,"d":"NT$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":4},{"v":1000,"d":"NT$1,000"},{"$nulls":5},{"v":500,"d":"NT$500"},{"$nulls":3},{"v":500,"d":"NT$500"},{"$nulls":5},{"v":2000,"d":"NT$2,000"}]
[null,null,"梨莎",{"v":250,"d":"NT$250"},null,null,{"v":20,"d":"NT$20"},null,{"v":125,"d":"NT$125"},{"v":20,"d":"NT$20"},{"$nulls":5},{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},null,{"v":125,"d":"NT$125"},{"v":250,"d":"NT$250"},{"$nulls":3},{"v":935,"d":"NT$935"}]
[null,null,"媽媽",null,{"v":470,"d":"NT$470"},{"v":74,"d":"NT$74"},{"$nulls":4},{"v":70,"d":"NT$70"},{"v":74,"d":"NT$74"},{"v":235,"d":"NT$235"},null,{"v":74,"d":"NT$74"},{"$nulls":5},{"v":125,"d":"NT$125"},{"v":70,"d":"NT$70"},{"v":235,"d":"NT$235"},{"v":1427,"d":"NT$1,427"}]
[null,null,"Grand Total",{"v":250,"d":"NT$250"},{"v":470,"d":"NT$470"},{"v":74,"d":"NT$74"},{"v":20,"d":"NT$20"},{"v":1000,"d":"NT$1,000"},{"v":125,"d":"NT$125"},{"v":20,"d":"NT$20"},{"v":70,"d":"NT$70"},{"v":74,"d":"NT$74"},{"v":235,"d":"NT$235"},{"v":500,"d":"NT$500"},{"v":74,"d":"NT$74"},{"v":20,"d":"NT$20"},{"v":125,"d":"NT$125"},{"v":500,"d":"NT$500"},{"v":125,"d":"NT$125"},{"v":250,"d":"NT$250"},{"v":125,"d":"NT$125"},{"v":70,"d":"NT$70"},{"v":235,"d":"NT$235"},{"v":4362,"d":"NT$4,362"}]
{"$rows_empty":84}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-17","爸爸","運動",{"v":1000,"d":"NT$1,000"}]
[null,"2017-01-17","爸爸","機票",{"v":500,"d":"NT$500"}]
[null,"2017-01-17","爸爸","稅金",{"v":500,"d":"NT$500"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","書籍",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","用餐",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","衣物",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","音樂課",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","停車",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","電子產品",{"v":125,"d":"NT$125"}]
[null,"2017-01-01","媽媽","燃料費",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-21","媽媽","會費",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","醫療",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","電費",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","牙醫",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","汽車保險",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","健康保險",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","房屋保險",{"v":235,"d":"NT$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":"NT$2,000"}]
[{"$nulls":3},"運動",{"v":1000,"d":"NT$1,000"}]
[{"$nulls":3},"稅金",{"v":500,"d":"NT$500"}]
[{"$nulls":3},"機票",{"v":500,"d":"NT$500"}]
[{"$nulls":3},"梨莎",{"v":935,"d":"NT$935"}]
[{"$nulls":3},"書籍",{"v":250,"d":"NT$250"}]
[{"$nulls":3},"音樂",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"票券",{"v":125,"d":"NT$125"}]
[{"$nulls":3},"用餐",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"停車",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"電子產品",{"v":125,"d":"NT$125"}]
[{"$nulls":3},"衣物",{"v":125,"d":"NT$125"}]
[{"$nulls":3},"音樂課",{"v":250,"d":"NT$250"}]
[{"$nulls":3},"媽媽",{"v":1427,"d":"NT$1,427"}]
[{"$nulls":3},"食物",{"v":470,"d":"NT$470"}]
[{"$nulls":3},"燃料費",{"v":74,"d":"NT$74"}]
[{"$nulls":3},"電費",{"v":70,"d":"NT$70"}]
[{"$nulls":3},"醫療",{"v":74,"d":"NT$74"}]
[{"$nulls":3},"牙醫",{"v":235,"d":"NT$235"}]
[{"$nulls":3},"汽車保險",{"v":74,"d":"NT$74"}]
[{"$nulls":3},"會費",{"v":125,"d":"NT$125"}]
[{"$nulls":3},"健康保險",{"v":70,"d":"NT$70"}]
[{"$nulls":3},"房屋保險",{"v":235,"d":"NT$235"}]
[{"$nulls":3},"Grand Total",{"v":4362,"d":"NT$4,362"}]
{"$rows_empty":65}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-17","爸爸","運動",{"v":1000,"d":"NT$1,000"}]
[null,"2017-01-17","爸爸","機票",{"v":500,"d":"NT$500"}]
[null,"2017-01-17","爸爸","稅金",{"v":500,"d":"NT$500"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","書籍",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","用餐",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","衣物",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","音樂課",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","停車",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","電子產品",{"v":125,"d":"NT$125"}]
[null,"2017-01-01","媽媽","燃料費",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-21","媽媽","會費",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","醫療",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","電費",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","牙醫",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","汽車保險",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","健康保險",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","房屋保險",{"v":235,"d":"NT$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":"NT$2,000"}]
[null,"梨莎",{"v":935,"d":"NT$935"}]
[null,"媽媽",{"v":1427,"d":"NT$1,427"}]
[null,"Grand Total",{"v":4362,"d":"NT$4,362"}]
{"$rows_empty":83}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-17","爸爸","運動",{"v":1000,"d":"NT$1,000"}]
[null,"2017-01-17","爸爸","機票",{"v":500,"d":"NT$500"}]
[null,"2017-01-17","爸爸","稅金",{"v":500,"d":"NT$500"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","書籍",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","用餐",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","衣物",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","音樂課",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","停車",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","電費",{"v":125,"d":"NT$125"}]
[null,"2017-01-01","媽媽","燃料費",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-21","媽媽","會費",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","醫療",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","電費",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","牙醫",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","汽車保險",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","健康保險",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","房屋保險",{"v":235,"d":"NT$235"}]

{"sheet":"15","index":15,"n_rows":121,"n_cols":7,"rows_kept":121}
["如果您需要簡化樞紐分析表，您可以將第二個列欄位的資料「向上」摺疊加以隱藏。 "]
["此範例的樞紐分析表位於儲存格 F7 到 G31。選取儲存格 F8 以選取第一個列欄位 [爸爸]。接著，按 Alt+JT > X 以展開第二個欄位，或按 P 以將欄位摺疊。"]
["若要繼續本教學課程，請按 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":"NT$2,000"}]
[{"$nulls":5},"運動",{"v":1000,"d":"NT$1,000"}]
[{"$nulls":5},"稅金",{"v":500,"d":"NT$500"}]
[{"$nulls":5},"機票",{"v":500,"d":"NT$500"}]
[{"$nulls":5},"梨莎",{"v":935,"d":"NT$935"}]
[{"$nulls":5},"書籍",{"v":250,"d":"NT$250"}]
[{"$nulls":5},"用餐",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"電子產品",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"音樂",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"停車",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"票券",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"衣物",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"音樂課",{"v":250,"d":"NT$250"}]
[{"$nulls":5},"媽媽",{"v":1427,"d":"NT$1,427"}]
[{"$nulls":5},"牙醫",{"v":235,"d":"NT$235"}]
[{"$nulls":5},"汽車保險",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"房屋保險",{"v":235,"d":"NT$235"}]
[{"$nulls":5},"食物",{"v":470,"d":"NT$470"}]
[{"$nulls":5},"健康保險",{"v":70,"d":"NT$70"}]
[{"$nulls":5},"會費",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"電費",{"v":70,"d":"NT$70"}]
[{"$nulls":5},"燃料費",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"醫療",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"NT$4,362"}]
{"$rows_empty":68}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-17","爸爸","運動",{"v":1000,"d":"NT$1,000"}]
[null,"2017-01-17","爸爸","機票",{"v":500,"d":"NT$500"}]
[null,"2017-01-17","爸爸","稅金",{"v":500,"d":"NT$500"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","書籍",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","用餐",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","衣物",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","音樂課",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","停車",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","電子產品",{"v":125,"d":"NT$125"}]
[null,"2017-01-01","媽媽","燃料費",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-21","媽媽","會費",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","醫療",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","電費",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","牙醫",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","汽車保險",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","健康保險",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","房屋保險",{"v":235,"d":"NT$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":"NT$2,000"}]
[{"$nulls":5},"運動",{"v":1000,"d":"NT$1,000"}]
[{"$nulls":5},"稅金",{"v":500,"d":"NT$500"}]
[{"$nulls":5},"機票",{"v":500,"d":"NT$500"}]
[{"$nulls":5},"梨莎",{"v":935,"d":"NT$935"}]
[{"$nulls":5},"書籍",{"v":250,"d":"NT$250"}]
[{"$nulls":5},"用餐",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"電子產品",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"音樂",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"停車",{"v":20,"d":"NT$20"}]
[{"$nulls":5},"票券",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"衣物",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"音樂課",{"v":250,"d":"NT$250"}]
[{"$nulls":5},"媽媽",{"v":1427,"d":"NT$1,427"}]
[{"$nulls":5},"汽車保險",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"牙醫",{"v":235,"d":"NT$235"}]
[{"$nulls":5},"電費",{"v":70,"d":"NT$70"}]
[{"$nulls":5},"食物",{"v":470,"d":"NT$470"}]
[{"$nulls":5},"燃料費",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"醫療",{"v":74,"d":"NT$74"}]
[{"$nulls":5},"會費",{"v":125,"d":"NT$125"}]
[{"$nulls":5},"健康保險",{"v":70,"d":"NT$70"}]
[{"$nulls":5},"房屋保險",{"v":235,"d":"NT$235"}]
[{"$nulls":5},"Grand Total",{"v":4362,"d":"NT$4,362"}]
{"$rows_empty":68}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-17","爸爸","運動",{"v":1000,"d":"NT$1,000"}]
[null,"2017-01-17","爸爸","機票",{"v":500,"d":"NT$500"}]
[null,"2017-01-17","爸爸","稅金",{"v":500,"d":"NT$500"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","書籍",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","用餐",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","衣物",{"v":125,"d":"NT$125"}]
[null,"2017-01-21","梨莎","音樂課",{"v":250,"d":"NT$250"}]
[null,"2017-02-20","梨莎","停車",{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","電子產品",{"v":125,"d":"NT$125"}]
[null,"2017-01-01","媽媽","燃料費",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-21","媽媽","會費",{"v":125,"d":"NT$125"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","醫療",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","電費",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","牙醫",{"v":235,"d":"NT$235"}]
[null,"2017-01-01","媽媽","汽車保險",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","健康保險",{"v":70,"d":"NT$70"}]
[null,"2017-02-02","媽媽","房屋保險",{"v":235,"d":"NT$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":"NT$74"},{"v":74,"d":"NT$74"},{"v":125,"d":"NT$125"},{"v":125,"d":"NT$125"},{"v":398,"d":"NT$398"},{"$nulls":5},{"v":398,"d":"NT$398"}]
[null,"爸爸",{"v":235,"d":"NT$235"},{"v":235,"d":"NT$235"},{"v":235,"d":"NT$235"},{"v":74,"d":"NT$74"},{"v":779,"d":"NT$779"},{"$nulls":5},{"v":779,"d":"NT$779"}]
[null,"媽媽",{"$nulls":5},{"v":1000,"d":"NT$1,000"},{"v":1000,"d":"NT$1,000"},{"v":20,"d":"NT$20"},{"v":70,"d":"NT$70"},{"v":2090,"d":"NT$2,090"},{"v":2090,"d":"NT$2,090"}]
[null,"Grand Total",{"v":309,"d":"NT$309"},{"v":309,"d":"NT$309"},{"v":360,"d":"NT$360"},{"v":199,"d":"NT$199"},{"v":1177,"d":"NT$1,177"},{"v":1000,"d":"NT$1,000"},{"v":1000,"d":"NT$1,000"},{"v":20,"d":"NT$20"},{"v":70,"d":"NT$70"},{"v":2090,"d":"NT$2,090"},{"v":3267,"d":"NT$3,267"}]
{"$rows_empty":75}
[null,"月份","購買者","類型","金額"]
[null,"1 月","梨莎","食物",{"v":74,"d":"NT$74"}]
[null,"1 月","爸爸","食物",{"v":235,"d":"NT$235"}]
[null,"1 月","媽媽","水電費",{"v":1000,"d":"NT$1,000"}]
[null,"2 月","梨莎","食物",{"v":74,"d":"NT$74"}]
[null,"2 月","爸爸","食物",{"v":235,"d":"NT$235"}]
[null,"2 月","媽媽","水電費",{"v":1000,"d":"NT$1,000"}]
[null,"3 月","梨莎","食物",{"v":125,"d":"NT$125"}]
[null,"3 月","爸爸","食物",{"v":235,"d":"NT$235"}]
[null,"3 月","媽媽","水電費",{"v":20,"d":"NT$20"}]
[null,"4 月","梨莎","食物",{"v":125,"d":"NT$125"}]
[null,"4 月","爸爸","食物",{"v":74,"d":"NT$74"}]
[null,"4 月","媽媽","水電費",{"v":70,"d":"NT$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":5425,"d":"NT$5,425"}]
[{"$nulls":3},"媽媽",{"v":5425,"d":"NT$5,425"}]
[{"$nulls":3},"保險",{"v":1272,"d":"NT$1,272"}]
[{"$nulls":3},"房租",{"v":3220,"d":"NT$3,220"}]
[{"$nulls":3},"水電費",{"v":933,"d":"NT$933"}]
[{"$nulls":3},"春天",{"v":4760,"d":"NT$4,760"}]
[{"$nulls":3},"爸爸",{"v":4760,"d":"NT$4,760"}]
[{"$nulls":3},"保險",{"v":1040,"d":"NT$1,040"}]
[{"$nulls":3},"房租",{"v":2400,"d":"NT$2,400"}]
[{"$nulls":3},"水電費",{"v":1320,"d":"NT$1,320"}]
[{"$nulls":3},"夏天",{"v":3473,"d":"NT$3,473"}]
[{"$nulls":3},"媽媽",{"v":3473,"d":"NT$3,473"}]
[{"$nulls":3},"保險",{"v":1080,"d":"NT$1,080"}]
[{"$nulls":3},"房租",{"v":1260,"d":"NT$1,260"}]
[{"$nulls":3},"水電費",{"v":1133,"d":"NT$1,133"}]
[{"$nulls":3},"冬天",{"v":4100,"d":"NT$4,100"}]
[{"$nulls":3},"爸爸",{"v":4100,"d":"NT$4,100"}]
[{"$nulls":3},"保險",{"v":1030,"d":"NT$1,030"}]
[{"$nulls":3},"房租",{"v":1420,"d":"NT$1,420"}]
[{"$nulls":3},"水電費",{"v":1650,"d":"NT$1,650"}]
[{"$nulls":3},"Grand Total",{"v":17758,"d":"NT$17,758"}]
{"$rows_empty":68}
[null,"購買者","季節","類型","金額"]
[null,"爸爸","冬天","保險",{"v":300,"d":"NT$300"}]
[null,"爸爸","冬天","房租",{"v":200,"d":"NT$200"}]
[null,"爸爸","冬天","水電費",{"v":400,"d":"NT$400"}]
[null,"爸爸","冬天","保險",{"v":300,"d":"NT$300"}]
[null,"爸爸","冬天","房租",{"v":800,"d":"NT$800"}]
[null,"爸爸","冬天","水電費",{"v":400,"d":"NT$400"}]
[null,"爸爸","冬天","保險",{"v":200,"d":"NT$200"}]
[null,"爸爸","冬天","房租",{"v":300,"d":"NT$300"}]
[null,"爸爸","冬天","水電費",{"v":450,"d":"NT$450"}]
[null,"爸爸","冬天","保險",{"v":230,"d":"NT$230"}]
[null,"爸爸","冬天","房租",{"v":120,"d":"NT$120"}]
[null,"爸爸","冬天","水電費",{"v":400,"d":"NT$400"}]
[null,"爸爸","春天","保險",{"v":210,"d":"NT$210"}]
[null,"爸爸","春天","房租",{"v":300,"d":"NT$300"}]
[null,"爸爸","春天","水電費",{"v":400,"d":"NT$400"}]
[null,"爸爸","春天","保險",{"v":230,"d":"NT$230"}]
[null,"爸爸","春天","房租",{"v":900,"d":"NT$900"}]
[null,"爸爸","春天","水電費",{"v":300,"d":"NT$300"}]
[null,"爸爸","春天","保險",{"v":200,"d":"NT$200"}]
[null,"爸爸","春天","房租",{"v":1000,"d":"NT$1,000"}]
[null,"爸爸","春天","水電費",{"v":220,"d":"NT$220"}]
[null,"爸爸","春天","保險",{"v":400,"d":"NT$400"}]
[null,"爸爸","春天","房租",{"v":200,"d":"NT$200"}]
[null,"爸爸","春天","水電費",{"v":400,"d":"NT$400"}]
[null,"媽媽","夏天","保險",{"v":100,"d":"NT$100"}]
[null,"媽媽","夏天","房租",{"v":30,"d":"NT$30"}]
[null,"媽媽","夏天","水電費",{"v":123,"d":"NT$123"}]
[null,"媽媽","夏天","保險",{"v":300,"d":"NT$300"}]
[null,"媽媽","夏天","房租",{"v":350,"d":"NT$350"}]
[null,"媽媽","夏天","水電費",{"v":230,"d":"NT$230"}]
[null,"媽媽","夏天","保險",{"v":120,"d":"NT$120"}]
[null,"媽媽","夏天","房租",{"v":640,"d":"NT$640"}]
[null,"媽媽","夏天","水電費",{"v":530,"d":"NT$530"}]
[null,"媽媽","夏天","保險",{"v":560,"d":"NT$560"}]
[null,"媽媽","夏天","房租",{"v":240,"d":"NT$240"}]
[null,"媽媽","夏天","水電費",{"v":250,"d":"NT$250"}]
[null,"媽媽","秋天","保險",{"v":62,"d":"NT$62"}]
[null,"媽媽","秋天","房租",{"v":600,"d":"NT$600"}]
[null,"媽媽","秋天","水電費",{"v":340,"d":"NT$340"}]
[null,"媽媽","秋天","保險",{"v":205,"d":"NT$205"}]
[null,"媽媽","秋天","房租",{"v":500,"d":"NT$500"}]
[null,"媽媽","秋天","水電費",{"v":403,"d":"NT$403"}]
[null,"媽媽","秋天","保險",{"v":503,"d":"NT$503"}]
[null,"媽媽","秋天","房租",{"v":2000,"d":"NT$2,000"}]
[null,"媽媽","秋天","水電費",{"v":140,"d":"NT$140"}]
[null,"媽媽","秋天","保險",{"v":502,"d":"NT$502"}]
[null,"媽媽","秋天","房租",{"v":120,"d":"NT$120"}]
[null,"媽媽","秋天","水電費",{"v":50,"d":"NT$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=1650),\"太棒了！您放置了第二個\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"冬天\",$C$17=1650),\"列欄位。現在，向下捲動，\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND(B$14=\"冬天\",$C$17=1650),\"然後按一下 [下一步]。\",\" \")","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=1630),\"太棒了！您已將列欄位\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"南瓜\",$G$28=1630),\"放置在左側，並放置了\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"南瓜\",$G$28=1630),\"有四個新欄的欄欄位。\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"南瓜\",$G$28=1630),\"向下捲動，然後\",\" \")","v":" "}]
[{"$nulls":9},{"$f":"IF(AND($B$15=\"南瓜\",$G$28=1630),\"按一下 [下一步]...\",\" \")","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 粉絲交流互動，你們可以互相幫助。"]
[]
[" "]