本課程涵蓋5大主軸
1.建構excel分析操作資料技能
2.excel的資訊視覺化技巧
3.Excel的繪圖技巧
4.樞紐分析徹底剖析
5.大數據與Excel BI的運用
6.VBA實作演練This course covers 5 major axes
1. Construct excel analysis and operation data skills
2. Excel information visualization skills
3.Excel drawing skills
4. Thorough analysis of pivot analysis
5. Application of big data and Excel BI
6.VBA practice drill
從樞紐分析到大數據分析：Power Query、Power Pivot、Power View、Power Map應用解析
From hub analysis to big data analysis: Power Query, Power Pivot, Power View, Power Map application analysis
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 小考與作業小考與作業 Quiz and homework |
70 | |
| 期末心得報告期末心得報告 Final report |
30 |
