證書課程
Excel mastery certificate: Beyond the basics
Excel Academy
中級8 集數 · 1小時 38分鐘觀看次數 9K 次 Excel
Pivot Tables
Data Visualization
Forecasting
Dashboards
certificate
集數
1. Learn Excel: From basics to pro
4分鐘 09秒
Learn the key differences between Excel skill levels and solutions to common workplace challenges.
Learn the key differences between Excel skill levels and solutions to common workplace challenges.
2. How to master Excel pivot tables?
11分鐘 04秒
Let's organise and analyse complex data using Excel's powerful pivot table features in just minutes!
Let's organise and analyse complex data using Excel's powerful pivot table features in just minutes!
3. How to use Excel for duplicate cleanup?
8分鐘 27秒
Transform messy data into clean insights with Excel's distinct count for powerful data summaries.
Transform messy data into clean insights with Excel's distinct count for powerful data summaries.
4. Turn Excel data into stunning charts
3分鐘 35秒
Turn boring Excel pivot tables into dynamic visuals with powerful slicers and interactive timelines!
Turn boring Excel pivot tables into dynamic visuals with powerful slicers and interactive timelines!
5. Master interactive charts and dashboards
12分鐘 11秒
Combine pivot tables, charts, slicers, and timelines into powerful interactive Excel dashboards.
Combine pivot tables, charts, slicers, and timelines into powerful interactive Excel dashboards.
6. How Excel's waterfall charts show trend?
19分鐘 20秒
Master waterfall charts and sparklines to reveal data patterns and create compelling visual stories.
Master waterfall charts and sparklines to reveal data patterns and create compelling visual stories.
7. Sort and organize Excel data fast
25分鐘 47秒
Control messy spreadsheets using advanced sorting, filtering, and validation techniques in Excel.
Control messy spreadsheets using advanced sorting, filtering, and validation techniques in Excel.
8. Learn Excel solver for smart projections
13分鐘 51秒
Navigate best-case and worst-case scenarios using Excel's Goal Seek and Solver forecasting tools.
Navigate best-case and worst-case scenarios using Excel's Goal Seek and Solver forecasting tools.
工具與範本
以下必備工具與範本，助你的求職準備更充足
