{"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+PAGE DOWN。"]
["製作您的第一個樞紐分析表"]
["使用樞紐分析表，遠比您想像中還要來得簡單。在您逐步完成\n這些簡單的步驟後，您就會了解如何快速建立帳戶。"]
["按 CTRL+HOME 即可回到頁首。若要進行導覽，請按 CTRL+PAGE DOWN。"]

{"sheet":"1","index":1,"n_rows":17,"n_cols":9,"rows_kept":17}
["什麼是樞紐分析表？最基礎的樞紐分析表會擷取資料，並依照您的邏輯彙整資料，全程無須輸入任何公式！"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 H10 到 I14 含有彙整資料摘要的樞紐分析表。樞紐分析表有兩個欄：「購買者」和「加總 - 金額」。「購買者」欄包含「爸爸」、「媽媽」、「梨莎」和「總計」的值；而「加總 - 金額」欄則包含「NT$20」、「NT$544」、「NT$270」和「NT$834」的值。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"購買者","加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,"爸爸",{"v":20,"d":"NT$20"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,null,"媽媽",{"v":544,"d":"NT$544"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,null,"總計",{"v":834,"d":"NT$834"}]
[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"}]

{"sheet":"2","index":2,"n_rows":18,"n_cols":11,"rows_kept":18}
["剛剛的範例比較簡單。現在我們來看複雜一點的例子。這個樞紐分析表顯示了按購買類型和購買者劃分的花費金額。"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 G10 到 K18 含有更精細的資料摘要樞紐分析表。此樞紐分析表有五個欄：「類型」、「爸爸」、「梨莎」、「媽媽」和「總計」。「類型」欄包含「書籍」、「食物」、「油資」、「音樂」、「運動」和「票券」的值。「爸爸」、「梨莎」和「媽媽」欄包含多筆金額，而「總計」欄則含有每個「類型」的總金額。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,"加總 - 金額","購買者"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,"類型","爸爸","梨莎","媽媽","總計"]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,"書籍",null,{"v":125,"d":"NT$125"},null,{"v":125,"d":"NT$125"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,"食物",null,null,{"v":470,"d":"NT$470"},{"v":470,"d":"NT$470"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,"油資",null,null,{"v":74,"d":"NT$74"},{"v":74,"d":"NT$74"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"},null,"音樂",null,{"v":20,"d":"NT$20"},null,{"v":20,"d":"NT$20"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"},null,"運動",{"v":20,"d":"NT$20"},null,null,{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"},null,"票券",null,{"v":125,"d":"NT$125"},null,{"v":125,"d":"NT$125"}]
[{"$nulls":6},"總計",{"v":20,"d":"NT$20"},{"v":270,"d":"NT$270"},{"v":544,"d":"NT$544"},{"v":834,"d":"NT$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+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,"加總 - 金額","欄標籤"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,"列標籤","爸爸","梨莎","媽媽","總計"]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,"書籍",null,{"v":125,"d":"NT$125"},null,{"v":125,"d":"NT$125"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,"食物",null,null,{"v":470,"d":"NT$470"},{"v":470,"d":"NT$470"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,"油資",null,null,{"v":74,"d":"NT$74"},{"v":74,"d":"NT$74"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"},null,"音樂",null,{"v":20,"d":"NT$20"},null,{"v":20,"d":"NT$20"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"},null,"運動",{"v":20,"d":"NT$20"},null,null,{"v":20,"d":"NT$20"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"},null,"票券",null,{"v":125,"d":"NT$125"},null,{"v":125,"d":"NT$125"}]
[{"$nulls":6},"總計",{"v":20,"d":"NT$20"},{"v":270,"d":"NT$270"},{"v":544,"d":"NT$544"},{"v":834,"d":"NT$834"}]

{"sheet":"4","index":4,"n_rows":17,"n_cols":5,"rows_kept":17}
["但讓我們回歸正題吧。製作優質樞紐分析表的第一步，就是要確認資料要素正確。因此，請確認您完成下列檢查項目，再製作樞紐分析表： "]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄都有值，沒有重複的值，也沒有空格。"]
["有個指向欄的標籤，標示「為您的欄命名」。此外，還有個指向列的標籤，標示「請確認沒有重複的列或空白的儲存格」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"5","index":5,"n_rows":17,"n_cols":5,"rows_kept":17}
["留意事項：許多使用者都會使用「欄」這個字。但對樞紐分析表而言，欄就等於「欄位」。觀看本教學課程期間請別忘了這點。"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄都有個指向的標籤，標示「欄位」。"]
["不可不知：為什麼使用「欄位」這個字？這只是處理資料和資料庫應用程式時的慣用字詞。樞紐分析表功能表和按鈕常用「欄位」這個字。只要您習慣，製作樞紐分析表時就會更加得心應手。 "]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"6","index":6,"n_rows":17,"n_cols":5,"rows_kept":17}
["讓我們來看看其中一個欄位。在以下的欄位中，「金額」欄位可能是最重要的一個。若能將這個欄位加總，不是會更方便嗎？"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。「金額」欄有個指向的標籤，標示「此欄位應加總」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"7","index":7,"n_rows":17,"n_cols":8,"rows_kept":17}
["因此我們就將這個欄位加總了。我們加總了樞紐分析表中的「金額」欄位。(真的嗎？)是的。「加總 - 金額」和 NT$834 即是加總「金額」欄位的小樞紐分析表要素。 "]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 H10 和 H11 含有樞紐分析表，其中加總了「金額」欄。此樞紐分析表有一個欄：加總 - 金額。而該欄只有一個值：NT$834。有個指向樞紐分析表的標籤，標示「雖然這看起來並不像，但這確實是個樞紐分析表」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,{"v":834,"d":"NT$834"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"8","index":8,"n_rows":18,"n_cols":8,"rows_kept":18}
["為什麼要製作這麼小的樞紐分析表？因為這強調了樞紐分析表值欄位的概念。若您資料中的其中一個欄位含有數值，樞紐分析表就可以將數值加總。將值加總的欄位，就稱為樞紐分析表值欄位。"]
["儲存格 B11 到 E18 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。有個指向「金額」欄的標籤，標示「此欄位含有數值...」"]
["儲存格 H11 和 H12 含有樞紐分析表，其中加總了「金額」欄。此樞紐分析表有一個欄：加總 - 金額。而該欄只有一個值：NT$834。有個指向樞紐分析表的標籤，標示「...而此樞紐分析表將它轉換成『值欄位』」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,{"v":834,"d":"NT$834"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"9","index":9,"n_rows":18,"n_cols":9,"rows_kept":18}
["當您加入用來劃分值欄位的條件時，樞紐分析表就會越來越有意義。在本例中，我們新增了「購買者」的新條件，藉此劃分值欄位。 "]
["儲存格 B11 到 E18 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 H11 到 I15 含有彙整資料摘要的樞紐分析表。樞紐分析表有兩個欄：「購買者」和「加總 - 金額」。「購買者」欄包含「爸爸」、「梨莎」、「媽媽」和「總計」的值；而「加總 - 金額」欄則包含「NT$20」、「NT$270」、「NT$544」和「NT$834」的值。有個指向「購買者」欄的標籤，標示「我們在這裡加入了條件，以根據『購買者』劃分值欄位。」還有個標籤指向「加總 - 金額」欄，標示「值欄位」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"購買者","加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,"爸爸",{"v":20,"d":"NT$20"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,null,"媽媽",{"v":544,"d":"NT$544"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,null,"總計",{"v":834,"d":"NT$834"}]
[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"}]

{"sheet":"10","index":10,"n_rows":17,"n_cols":9,"rows_kept":17}
["以下是樞紐分析表的另外一個版本，但這次我們加入了「類型」條件，以了解每個採購類型的花費。"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 H10 到 I17 含有彙整資料摘要的樞紐分析表。樞紐分析表有兩個欄：「類型」和「加總 - 金額」。「購買者」欄包含「書籍」、「食物」、「油資」、「音樂」、「運動」、「票券」和「總計」的值；而「加總 - 金額」欄則包含「NT$125」、「NT$470」、「NT$74」、「NT$20」、「NT$20」、「NT$125」和「NT$834」的值。有個指向「類型」欄的標籤，標示「我們在這裡新增了條件，以根據『類型』劃分值欄位。」還有個標籤指向「加總 - 金額」欄，標示「值欄位」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"類型","加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,"書籍",{"v":125,"d":"NT$125"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"食物",{"v":470,"d":"NT$470"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,null,"油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,null,"音樂",{"v":20,"d":"NT$20"}]
[null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"運動",{"v":20,"d":"NT$20"}]
[null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"},null,null,"票券",{"v":125,"d":"NT$125"}]
[null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"},null,null,"總計",{"v":834,"d":"NT$834"}]

{"sheet":"11","index":11,"n_rows":17,"n_cols":9,"rows_kept":17}
["另一個樞紐分析表詞彙：我們目前為止加入的條件，都稱為樞紐分析表列欄位。在這些範例中，列欄位將值欄位進行劃分。"]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["儲存格 H10 到 I14 含有彙整資料摘要的樞紐分析表。樞紐分析表有兩個欄：「購買者」和「加總 - 金額」。「購買者」欄包含「爸爸」、「梨莎」、「媽媽」和「總計」的值；而「加總 - 金額」欄則包含「NT$20」、「NT$270」、「NT$544」和「NT$834」的值。有個指向「購買者」欄的標籤，標示「列欄位」。還有個指向「加總 - 金額」欄的標籤，標示「值欄位」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"購買者","加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,"爸爸",{"v":20,"d":"NT$20"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,null,"媽媽",{"v":544,"d":"NT$544"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,null,"總計",{"v":834,"d":"NT$834"}]
[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"}]

{"sheet":"12","index":12,"n_rows":17,"n_cols":9,"rows_kept":17}
["複習時間。我們接下來會向您說明如何實際在短短幾分鐘內製作樞紐分析表。但讓我們先來複習目前學過的概念："]
["儲存格 B10 到 E17 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。有個指向資料的標籤，標示「首先，準備一筆可用的資料」。"]
["儲存格 H10 到 I14 含有彙整資料摘要的樞紐分析表。 "]
["樞紐分析表有兩個欄：「購買者」和「加總 - 金額」。「購買者」欄含有「爸爸」、「梨莎」、「媽媽」和「總計」的值。「加總 - 金額」欄含有「NT$20」、「NT$270」、「NT$544」和「NT$834」的值。有個指向「購買者」欄的標籤，標示「『列欄位』劃分成」。還有個指向「...『加總 - 金額』」欄的標籤，標示「值欄位」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[null,"日期","購買者","類型","金額",null,null,"購買者","加總 - 金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"},null,null,"爸爸",{"v":20,"d":"NT$20"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"},null,null,"梨莎",{"v":270,"d":"NT$270"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"},null,null,"媽媽",{"v":544,"d":"NT$544"}]
[null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"},null,null,"總計",{"v":834,"d":"NT$834"}]
[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"}]

{"sheet":"13","index":13,"n_rows":21,"n_cols":6,"rows_kept":21}
["當您快速建立樞紐分析表時，您會看見樞紐分析表欄位清單。與其說這是一份清單，不如說這是一個窗格。您會在頂端看見從您資料擷取的欄位。 "]
["儲存格 C14 到 F21 含有資料。共有四個欄：「日期」、「購買者」、「類型」和「金額」。每個欄在每個列都有不同的值。"]
["有個指向資料欄位的標籤，標示「Excel 會查看您的資料...」"]
["有個箭號從欄位名稱上方指向樞紐分析表欄位清單圖片中的相同欄位名稱。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":8}
[null,null,"日期","購買者","類型","金額"]
[null,null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[null,null,"2017-01-21","梨莎","書籍",{"v":125,"d":"NT$125"}]
[null,null,"2017-02-02","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,null,"2017-02-20","梨莎","音樂",{"v":20,"d":"NT$20"}]
[null,null,"2017-02-25","梨莎","票券",{"v":125,"d":"NT$125"}]

{"sheet":"14","index":14,"n_rows":4,"n_cols":1,"rows_kept":4}
["現在先別急著使用這份樞紐分析表，您會在後續幾個步驟中處理它。首先，您需建立值欄位，方法是將「金額」欄位拖曳至「值」區域。"]
["樞紐分析表欄位清單圖片顯示將「金額」欄位拖曳至「值」區域的箭號游標。"]
["最佳做法：在您的情況中，如果您不確定要如何開始製作樞紐分析表，請考慮先建立值欄位。最適合值欄位的欄位類型，就是數值金額。在此範例中，「金額」欄位最適合。其他欄位 (「日期」、「購買者」、「類型」) 不含數值，因此不是值欄位最適合的欄位類型。  \n"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]

{"sheet":"15","index":15,"n_rows":13,"n_cols":5,"rows_kept":13}
["當您將欄位拖曳至「值」區域後，「總金...」會出現在樞紐分析表欄位清單的底部(有時 Excel 會沒有足夠的空間顯示「加總 - 金額」的完整名稱)。"]
["儲存格 E12 和 E13 含有樞紐分析表，其中加總了「金額」欄。此樞紐分析表有一個欄：加總 - 金額。而該欄只有一個值：NT$834。有個指向樞紐分析表的標籤，標示「建立加總『金額』欄位的值欄位，並製作與這類似的小型樞紐分析表」。"]
["樞紐分析表欄位清單圖片，醒目提示「值」區域中的「總金...」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":7}
[{"$nulls":4},"加總 - 金額"]
[{"$nulls":4},{"v":834,"d":"NT$834"}]

{"sheet":"16","index":16,"n_rows":14,"n_cols":5,"rows_kept":14}
["然後，您需要一個劃分值欄位的條件。若要這麼做，您需將任何其他欄位向下拖曳至「列」區域。 "]
["樞紐分析表欄位清單圖片顯示將「購買者」欄位拖曳至「列」區域的箭號游標。已醒目提示的「列」區域。"]
["儲存格 E13 和 E14 含有樞紐分析表，其中加總了「金額」欄。此樞紐分析表有一個欄：加總 - 金額。而該欄只有一個值：NT$834。 "]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":8}
[{"$nulls":4},"加總 - 金額"]
[{"$nulls":4},{"v":834,"d":"NT$834"}]

{"sheet":"17","index":17,"n_rows":16,"n_cols":5,"rows_kept":16}
["「購買者」欄位即在「列」區域，而樞紐分析表會顯示每個購買者花費的金額。看看這有多麼簡單快速...更棒的地方是，您不必輸入任何公式！"]
["儲存格 D12 和 E16 含有樞紐分析表。樞紐分析表有兩個欄：「列標籤」和「加總 - 金額」。「列標籤」含有「爸爸」、「梨莎」、「媽媽」和「總計」的值。「加總 - 金額」則含有「NT$20」、「NT$270」、「NT$544」和「NT$834」的值。 "]
["有個指向「列標籤」欄的標籤，標示「列欄位『購買者』」；其他指向「加總 - 金額」欄的標籤，則標示「劃分『加總 - 金額』欄位的值」。"]
["樞紐分析表欄位清單圖片，醒目提示「列」區域中的「購買者」。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"列標籤","加總 - 金額"]
[{"$nulls":3},"爸爸",{"v":20,"d":"NT$20"}]
[{"$nulls":3},"梨莎",{"v":270,"d":"NT$270"}]
[{"$nulls":3},"媽媽",{"v":544,"d":"NT$544"}]
[{"$nulls":3},"總計",{"v":834,"d":"NT$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+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(AND($H$14=\"購買者\",$I$18=834),\"大功告成！您已正確地放置欄位。\",\" \")","v":" "}]
[]
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"19","index":19,"n_rows":7,"n_cols":1,"rows_kept":7}
["在下個步驟中，您將會從頭開始建立樞紐分析表。建立期間請留意：Excel 會將樞紐分析表放在您所在工作表左側的全新獨立工作表中。 "]
["有張圖片，顯示命名為「17」、「18」、「19」、「20」和「深入了解」的 4 個工作表索引標籤。20 是使用中的索引標籤。"]
["圖片下方的標題標示「例如，假設您的資料置於名為『20』的工作表上。如果您建立了樞紐分析表...」"]
["圖片顯示名為「工作表 12」的全新工作表索引標籤，介於「工作表 19」和「工作表 20」之間。"]
["如果您建立了樞紐分析表，Excel 會將它放在左側的全新工作表中。系統會將它命名為「工作表」，並指定「12」、「13」等數字。您隨時可以選取工作表，按 Alt+H、O、R，然後將它命名為「樞紐分析表」這類名稱。"]
["為什麼會這樣呢？這是因為樞紐分析表的完整名稱是：「樞紐分析表報表」。報表是以資料為依據建立的，而使用者通常習慣將報表和資料本身分開來瀏覽。不過現在您也可以將樞紐分析表放在與資料相同的工作表上。但在大多數情況下，樞紐分析表很佔空間，因此我們較建議您將分析表放在新的工作表中。"]
["若要繼續本教學課程，請按 CTRL+PAGE DOWN。若要移至上一個工作表，請按 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+PAGE DOWN。若要移至上一個工作表，請按 CTRL+PAGE UP。"]
{"$rows_empty":7}
[null,"日期","購買者","類型","金額"]
[null,"2017-01-01","媽媽","油資",{"v":74,"d":"NT$74"}]
[null,"2017-01-15","媽媽","食物",{"v":235,"d":"NT$235"}]
[null,"2017-01-17","爸爸","運動",{"v":20,"d":"NT$20"}]
[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"}]

{"sheet":"深入了解","index":21,"n_rows":5,"n_cols":1,"rows_kept":5}
["太好了，您做到了！"]
["請繼續保持！還有更多精彩的教學課程..."]
["更多樞紐分析表資訊：閱讀這篇有關樞紐分析表的實用文章，探索更多功能。"]
["完善的資料是關鍵：Excel 可以為您提供協助。請參閱這篇文章，深入了解「取得及轉換」功能。"]
["社群：與其他 Excel 粉絲交流互動，並互相協助彼此。"]