excel資料剖析練習 === ### 1.複製文件資料 ![](https://hackmd.io/_uploads/rktVwhBv3.jpg) ### 2.貼到excel ![](https://hackmd.io/_uploads/HyR9v3Hvn.jpg) ### 3.將excel A欄寬度，拉開到文件適合寬度 ![](https://hackmd.io/_uploads/Hysq_3SDn.jpg) ![](https://hackmd.io/_uploads/SkEiu3Hv2.jpg) ### 4.選取A欄裡，想要剖析的資料 ![](https://hackmd.io/_uploads/Bky-tYUP3.jpg) ### 5.點擊excel功能分類的"資料"項目，找到資料剖析 ![](https://hackmd.io/_uploads/ryMotKUDh.jpg) ### 6.步驟一 直接點選下一步 ![](https://hackmd.io/_uploads/SJ6T5tUv2.jpg) 步驟二、將tab鍵選項取消，改為以"空格"為切割選項 ![](https://hackmd.io/_uploads/SJUrjt8wh.jpg) 步驟三、直接點選完成 ![](https://hackmd.io/_uploads/H1AIsKUv3.jpg) ### 7.將欄寬度拉寬至適合寬度，將讓資料能在格子裡 ![](https://hackmd.io/_uploads/S1EToYUP3.jpg) ### 8.使用選取、搬移技巧，將資料搬到正確位置 ![](https://hackmd.io/_uploads/B1XXnKUPh.jpg) ### 9.調整A、B、C欄位寬度 ![](https://hackmd.io/_uploads/rysaht8P3.jpg) ### 10.選取資料加上框線 ![](https://hackmd.io/_uploads/ryb8pKLwn.jpg) ![](https://hackmd.io/_uploads/rkqI6YUPh.jpg) ### 11.選取excel資料，複製貼到google文件上 ![](https://hackmd.io/_uploads/S1NIRYLD2.jpg) ### 12.選取表格內範圍 ![](https://hackmd.io/_uploads/Hyp80t8Pn.jpg) ### 13.選取--格式/表格/表格屬性，將"顏色"選項寬度，改為1pt ![](https://hackmd.io/_uploads/BkWClqLDh.jpg) ### 14.可以調整字形大小、行距，將頁面縮至一頁顯示 ![](https://hackmd.io/_uploads/BJvMb58wh.jpg) ![](https://hackmd.io/_uploads/r1k7W98vh.jpg)