適合已有基礎Excel知識人士報讀
Professional Formulas Usage | 專業公式應用 & Data Extraction across Workbooks | 跨活頁簿提取數據
Applying formulas for Table structure | 從表格架構中套用公式 & Data Validation with custom formulas | 自定公式進行資料驗證
Workflow Automation of Sales Transactions | 銷售系統 的 工作流程自動化, Online Form Submit to Excel | 在線表格提交到 Excel & Import Web Data & automatically update Excel | 導入網頁數據並自動更新 Excel
Combine Multiple Sheets with Power Query I | 用Power Query合併多張工作表 I
Combine Multiple Sheets with Power Query II | 用Power Query合併多張工作表 II Setup formula for Conditional Formatting | 設定條件式公式設置 Workflow Automation of Sales Transactions, Schedule Duty List, Payroll, Inventory Control & Reservation System
Plot a Graph with different Y-axis | 單一圖表有著不同的 Y 軸 Interactive Graph Design | 互動式圖表設計 Dashboard Design Concept | 儀表板設計理念
Dashboard Design Concept | 儀表板設計理念 Apply slider to graph showcase | 將交叉分析篩選器應用於圖表展示
Apply slider to graph showcase | 將交叉分析篩選器應用於圖表展示 Producing Report across different worksheets/workbooks by Power Pivot | 以 Power Pivot 在跨工作表/活頁簿層面建立報表
Advanced Data Column Design on Power Query | Power Query 上的進階資料欄設計 Integrate with Power BI Desktop | Power BI 桌面版 整合
Integrate with Power BI Desktop | Power BI 桌面版 整合 Mastering Power BI DAX code | 掌握 Power BI DAX 程式碼 Dashboard Integration with Side Menu Bar | 整合側菜單到儀表板