<div class="MsoNormal"> <br /></div> <div class="MsoNormal"> <a href="https://www.youtube.com/watch?v=ettXxnWobOg&index=1&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC" style="font-family: 新細明體, serif; font-size: x-large;"><span style="color: #0563c1; font-family: 新細明體, serif; font-size: large; text-decoration-line: none;">01 </span><span lang="EN-US" style="color: #0563c1; font-family: 新細明體, serif; font-size: large; text-decoration-line: none;"><span lang="EN-US">基本操作快速存取工具列</span></span></a></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=x-QpbnjClU4&index=2&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">02 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">基本操作</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">介面說明</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=mLI6ilr269E&index=3&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">03 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">基本操作</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">欄列說明</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ff1mJBtAMzE&index=4&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">04 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">畫面縮放</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=z_0jrfYmlt0&index=5&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">05 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">並排檢視與基本輸入</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=qtOyfF9ucQ0&index=6&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">06 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">框線設定與跨欄置中</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=HNsx-nre__I&index=7&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">07 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">框線設定</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=j4AvqVsQVx4&index=8&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">08 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">換行</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=GBu9zd3trco&index=9&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">09 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">填滿控點說明</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=gcpvtCcWh2c&index=10&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">10 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">編輯自訂清單</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=-cXUADAfjs0&index=11&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">11 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">填滿控點其他說明</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=b45m5ew3ZPg&index=12&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">12 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">填滿但不填格式</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=C8ALyGHyG34&index=13&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">13 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">表格美化與大小調整</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=fHWj3dz5zWk&index=14&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">14 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料移動</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=teH6puD2R2E&index=15&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">15 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">公式計算練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=XLFbU95OC-I&index=16&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">16 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">插入與刪除欄列</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ct2Ld3o3p0I&index=17&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">17 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">儲存檔案</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=AjkWU-2ZJN0&index=18&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">18 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">網頁資料複製與貼上</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=oSmcqwklpBQ&index=19&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">19 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">取得外部資料</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">從Web</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=7pY-ShJR8jc&index=20&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">20 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">凍結窗格</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=8Y508The0-I&index=21&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">21 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料排序與搜尋資料</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=uc_k526adLQ&index=22&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">22 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">篩選</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ePi-pS6nq5c&index=23&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">23 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">公式計算練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=QupqvZeSoZ4&index=24&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">24 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">邏輯運算</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=i0VuLpc1_y0&index=25&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">25 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">儲存格計算</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=qJwY-DBm9XI&index=26&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">26 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">儲存格計算練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=Oc_tRyuuXK4&index=27&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">27 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">儲存格參照</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=gD34EvTOdsY&index=28&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">28 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">儲存格參照練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=VUzU4hgDdHA&index=29&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">29 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料選取</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=b555G9_jtqQ&index=30&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">30 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">輸入資料</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=uxpOpBp1noM&index=31&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">31 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">自動加總按鈕</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=IsLBHI4-KMs&index=32&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">32 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">插入函數</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=Y4zMtQxQRgY&index=33&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">33 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">移除重複資料</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=58qU8KJ9uPs&index=34&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">34 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數 COUNTIF</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">判斷符合條件的數量</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ZtXgYNB86Cs&index=35&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">35 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數 SUMIF</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">符合條件加總</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=gvJgD-vr4wU&index=36&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">36 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數 ROUND</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">四捨五入與INT</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">取整數</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=wz0DtukEw6U&index=37&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">37 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">多層函數說明練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=w7LkYXTZsfk&index=38&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">38 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">日期輸入說明與格式修改</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=_kPsI5waDy4&index=39&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">39 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料驗證</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">清單</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">下拉式選單</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=RH5EEatNt5o&index=40&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">40 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">名稱定義與名稱管理員</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=sqZoX34hMqg&index=41&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">41 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">多重下拉式選單</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=lS-hUrd7oHU&index=42&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">42 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料驗證</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">數值</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=gn-P357J2h4&index=43&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">43 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料驗證</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">日期與圈選錯誤資料</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=qPaQYg42Gl0&index=44&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">44 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">選擇性貼上驗證的設定內容</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=UqGLVSfKLxo&index=45&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">45 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料驗證設定清單與整數驗證</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=A-i3I-sfXvs&index=46&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">46 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">使用VLOOKUP</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數查詢欄位資料</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=dCmzDVkCMN8&index=47&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">47 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">使用VLOOKUP</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數查詢欄位資料增加IFERROR</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數判斷錯誤訊息</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=-mljH63-UDM&index=48&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">48 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">小計與總計計算</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=OzMbviFs384&index=49&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">49 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">限制內容輸入與保護工作表</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=FbnrRQfxXFE&index=50&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">50 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">保護活頁簿</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=SRUeUGpDbWQ&index=51&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">51 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">進貨單練習</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">檔案加上密碼保護</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=jodfNzMGL3A&index=52&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">52 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">營運業績達成表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">達成業績與達成率計算</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ZIiGfwNc6L8&index=53&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">53 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">營運業績達成表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">達成標示<span lang="EN-US">使用IF</span></span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數判斷條件</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=oS174VUL3BY&index=54&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">54 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">營運業績達成表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">業績排名使用RANK</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">函數</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=qnKaVXgEqZ4&index=55&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">55 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">醒目提示儲存格規則</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=LDl8e3yk6cY&index=56&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">56 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">頂端與底端</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=HR4AVUyPL0I&index=57&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">57 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料橫條</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=TmsCIM_kzHY&index=58&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">58 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">色階</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=YVGozEY5vb0&index=59&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">59 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">圖示集</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=2PGe-e5eUr8&index=60&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">60 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">設定格式化條件</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">管理規則與清除規則</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=JFdWgR7c168&index=61&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">61 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">多個欄位排序、顏色排序、圖示排序</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=rW_GAnSqWDs&index=62&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">62 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">自訂排序規格</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=98v9sWXnGYA&index=63&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">63 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">顏色篩選</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=UY8_7v3HAfw&index=64&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">64 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">樞紐分析表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">收支表分析練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=cKnBp4QUSv0&index=65&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">65 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">樞紐分析表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">收支表分析練習</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=Y3PqVPcYkrI&index=66&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">66 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">樞紐分析表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">插入交叉分析篩選器</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=jYyiPiYdZPc&index=67&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">67 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">樞紐分析<span lang="EN-US">表</span></span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">日期群組欄位</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=fnLw3WmgrlY&index=68&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">68 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">樞紐分析表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">欄位設定</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=uLu5On_Cga4&index=69&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">69 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">圖表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">直條圖</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=WYqR88DM25E&index=70&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">70 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">圖表</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">折線圖與圓形圖</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=BGgoNjFqhus&index=71&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">71 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">選單</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">文字藝術師與插入圖案</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=BaRtV1VO4-k&index=72&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">72 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">選單</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">插入超連結</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=enUurr1N7X8&index=73&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">73 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">選單</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">超連結檔案及網址</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=6iI8UBAETNs&index=74&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">74 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">合併彙算</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=2AvkikeJtJQ&index=75&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">75 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">目標搜尋</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=Vvhmtd-W0P8&index=76&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">76 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">特殊目標</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=QgfX4mId03Q&index=77&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">77 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">隱藏儲存格與群組大綱</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=e58CUhIkY3A&index=78&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">78 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料剖析</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">符號</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=Z7KAuB8GvuY&index=79&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">79 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料剖析</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">固定寬度</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=ax_4JXrgchY&index=80&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">80 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">資料合併使用&</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">與貼上值</span></span></a> <o:p></o:p></span></span></div> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><span style="font-size: large;"><a href="https://www.youtube.com/watch?v=-32nb6r0BwA&index=81&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="color: #0563c1; text-decoration-line: none;">81 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">格式化為表格</span></span></a> <o:p></o:p></span></span></div> <br /> <div class="MsoNormal"> <span lang="EN-US" style="color: #0563c1; font-family: "新細明體",serif; mso-bidi-font-family: 新細明體; mso-bidi-font-size: 12.0pt; mso-font-kerning: 0pt;"><a href="https://www.youtube.com/watch?v=mA868RAbAvo&index=82&list=PLwwPq48LW7z_oN6JmYTmqNd_bvfMo-mmC"><span style="font-size: large;"><span style="color: #0563c1; text-decoration-line: none;">82 </span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">網頁資料整理</span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US"> </span></span><span lang="EN-US" style="color: #0563c1; text-decoration-line: none;"><span lang="EN-US">刪除圖片、移除重覆資料、取代內容</span></span></span></a> <o:p></o:p></span></div> <br><br>--<br> 由 Blogger 於 4/27/2017 09:56:00 上午 張貼在 <a href="http://www.pclearncenter.com/2017/04/excel-2013.html">電腦學習園地</a>
