Excel & Power BI培訓

培訓時間：

2天，14小時(每日含1小時休息)

培訓內容：

Excel

Excel Workbook Quick Start

*   Create Workbook

*   Share & Print

*   Excel ShortCut Key

Excel Formula & Functions

*   Aggregate Function

*   Logic Function

*   Reference Function

*   Common Function in Work

Working on Chart in Excel

*   Create Chart in Excel

*   Chart Type

*   Pivot Table

Macro in Excel

Collocate with other Power Query/Power BI

Power BI

Power BI Overview

*   Power BI Desktop Introduction

*   Connect to Data

*   Load data into Power BI

Data Modeling

Data Visualization

*   Chart Creation

*   Mobile View

*   AI Function

*   Security Setting

Report Publish and Share

*   Power BI Service Overview

*   Dashboard

DAX Basic