Course Code: excelpowerbili
Duration: 14 hours
Course Outline:

培训时间:

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