Excel Dashboard
Excel 儀表板和報告是改進 Excel 數據可視化的強大手段。儀表板報告是一種以摘要形式直觀呈現重要數據的方式，以便您可以做出快速有效的決策，其工作方式與汽車儀表板的工作方式大致相同。
Excel dashboards and reports are powerful means to improve Excel data visualization. A dashboard report is a way to visually present important data in summary form so that you can make quick and effective decisions, in much the same way that a car dashboard works.
你將學習：
- 為儀表板和報告構建數據模型
- 規劃和構建引人注目的儀表板
- 使用有效的圖表類型來呈現不同類型的業務數據
- 為專業匯報定製圖表
- 創建樞紐分析圖
- 創建迷你圖以顯示數據趨勢或分佈
- 先進的圖表技術來創建交互式圖表和動態內容
- 使用巨集操作儀表板
You will Learn:
- Building data models for dashboards and reports
- Planning and building eye-catching dashboards
- Using effective chart types to present different types of business data
- Customizing charts for professional presentation
- Creating PivotCharts
- Creating Sparklines to show data trends or distribution
- Advanced charting techniques to create interactive charts and with dynamic contents
- Using Macros in manipulating dashboards
由於其靈活性，您幾乎可以按照自己的方式在 Excel 中設計任何儀表板。本課程專為希望通過充分利用 Excel 中的儀表板和報告功能來執行數據建模和創建交互式報告的 Excel 用戶而設計。
Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you want. This course is designed for Excel users who want to perform data modeling and create interactive reports by making the best use of the dashboard and reporting features in Excel.
學員修畢課程會獲頒修業證書。
本課程的凝方網校 (線上學習) 版本現正努力開發中！期間你的面授課程仍會有優良的導師和教材的支援，也有靈活的免費補課務求讓你學有所成！
Microsoft Learning
面授時間表 | 留位報名
系統預設展示和收取為全期學費。如果有相關的優惠和顯示的金額不同，請在結帳時選擇 “到校付款”，我們的客戶服務主任很樂意為閣下辦理。
| Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Enrol 報名 | |
|---|---|---|---|---|---|---|---|---|
| SEDR-23101K | Cantonese / PC / MongKok | 24/10 | 25/10 | TUE,WED | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20231024 |
$3,100Add to cart |
| SEDR-45C26K | Cantonese / PC / MongKok | 26/10 | 03/11 | THU,FRI | 1900-2200 | 12 hours / 4 sessions | 20231026 |
$3,100Add to cart |
| SEDR-23111K | Cantonese / PC / MongKok | 09/11 | 10/11 | THU,FRI | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20231109 |
$3,100Add to cart |
| SEDR-6D02K | Cantonese / PC / MongKok | 02/12 | 09/12 | SAT | 1000-1300;1400-1700 | 12 hours / 4 sessions | 20231202 |
$3,100Add to cart |
| SEDR-23121K | Cantonese / PC / MongKok | 13/12 | 14/12 | WED,THU | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20231213 |
$3,100Add to cart |
| SEDR-24011K | Cantonese / PC / MongKok | 15/01 | 16/01 | MON,TUE | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20240115 |
$3,100Add to cart |
| SEDR-24021K | Cantonese / PC / MongKok | 19/02 | 20/02 | MON,TUE | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20240219 |
$3,100Add to cart |
| SEDR-24031K | Cantonese / PC / MongKok | 14/03 | 15/03 | THU,FRI | 0930-1230;1400-1700 | 12 hours / 4 sessions | 20240314 |
$3,100Add to cart |
課程大綱
客製課程 | 企業培訓
本課程歡迎機構和企業報讀，亦可按閣下需要客製你所需的培訓，歡迎使用以下表格聯絡我們
