Microsoft Excel 進階
本課程幫助您掌握 Microsoft Excel 作為行政與財務工具來執行各種函數計算和資料篩選等高階運用。
Using Conditional Formatting
Creating a Formula by using a Function
Logical Function
Database functions
LOOKUP Function
Sort Data
Custom Lists
Filter Advanced Filter
Subtotal
Importing Text Files
Using Text to Columns
Pivot Tables
Consolidate Data