課程資料
時間表
- 2026年5月21日(週四) 上午 10:00 - 下午 5:00
報名日期
2025年12月17日(週三) - 2026年5月11日(週一)
價錢
HKD 1,180
(Enrolling this course on or before 27th December can receive early bird discount of $300)
(Enrolling this course on or before 27th December can receive early bird discount of $300)
課程級別
學習模式
修業期
1 日
教學語言
廣東話
地點
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
課程簡介
The advanced Excel training course targets intermediate Excel users they want to use Excel to analyze , calculate , manage data and prepare management reports.
The course covers a wide range of spreadsheet features including advanced search, consolidating multiple worksheets, database functions, lookup functions, what-if analysis, scenario analysis and data protection. With all these features, students can streamline the repetitive workflow and save a lot of time in their work.
The course is supplemented with lots of real world examples and the adoption of small class size teaching approach can further enhance the overall learning experience of our students.
課程內容
- Naming cells and ranges
- Database
- Advanced data sorting and subtotal
- Using database functions
- Managing documents with workbooks
- Consolidation with several worksheets
- Data table
- Lookup table
- Document protection
- File linking
- Filter and advanced filter
- Building A Pivottable
- Manipulating Your Pivottable
- Conditional format
- Data validation
- What-If Analysis
- Inserting a hyperlink to a workbook
- Creating and using Macros
