Course Information
- 8 Jan 2025 (Wed) 9:30 AM - 5:00 PM
- 27 Feb 2025 (Thu) 9:30 AM - 5:00 PM
Course Overview
利用 Excel 強大的數據分析功能來幫助您提高工作效率。 學習有用的技能,以更有效的方式組織、分析和總結數據。
Take advantage of Excel’s powerful data analysis features to help you improve work productivity. Learn useful skills to organise, analyse and summarise data in a more effective way.
參加者有基本的 Excel 操作經驗。
What You’ll Learn
- 自動篩選
- 小計
- 按鍵功能
- 樞紐分析表/樞紐分析圖
- 條件格式
- AutoFilter
- Subtotals
- Key functions
- PivotTable/PivotChart
- Conditional formatting
Microsoft Excel 是 PC 上使用最廣泛的電子表格應用程式。它也是商業世界以及不同領域的數據分析方便而強大的工具。這門簡短而實用的課程著重於 Excel 的數據分析功能。您將學習各種技能,包括數據和列表管理、相關功能、樞紐分析表和樞紐分析圖、條件格式設置等。
Microsoft Excel is the most widely used spreadsheet application for PCs. It is also a convenient and powerful tool for data analysis in the business world as well as in different fields. This short but practical course focuses on the data analysis function of Excel. You will learn a variety of skills including data and list management, relevant functions, pivot tables and pivot charts, conditional formatting, etc.