課程資料
時間表
- 隨時開課
報名日期
全年招生
價錢
-
課程級別
學習模式
修業期
4 小時
教學語言
英語
地點
-
130次瀏覽
課程簡介
This course begins with getting you familiar with the MS Excel interface, menu systems, and Ribbon and how to enter and organize, format data, how to create formulas using simple functions and learn how to use absolute and relative referencing with your functions in Excel.
課程內容
Then it progresses to more advanced features like building charts, conditional formatting, SmartArt, PivotTables and PivotCharts, working with multiple worksheets, using advanced functions like IF, VLookup, PMT. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and the Scenario Manager.