Course Information
Schedules
- 15 May 2025 (Thu) 10:00 AM - 5:00 PM
- 15 May 2025 (Thu) - 22 May 2025 (Thu) 7:00 PM - 10:00 PM
- 30 May 2025 (Fri) 10:00 AM - 5:00 PM
Registration period
5 Mar 2025 (Wed) - 20 May 2025 (Tue)
Price
HKD 1,480
(Enrolling this course on or before 30th November can receive early bird discount of $200)
(Enrolling this course on or before 30th November can receive early bird discount of $200)
Course Level
Study Mode
Duration
2 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
4 views
Course Overview
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.
What You’ll Learn
- 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
Skills covered in this course
Start FollowingSee all
Courses that Might Interest You
- Certificate In Search Engine Optimization Form.Welkin
- Microsoft Office 綜合應用證書 (資歷架構第 3 級 及 CEF 資助課程) Excel Pro Education
- FINANCIAL ANALYSIS AND MODELLING WITH EXCEL Computer Academy
【自我增值】被譽為21世紀最性感職業？！數據分析師8個必備技能
【自我增值】IT創科行業職位逆市增長 自學進修有錢途！
【自我增值】想學好Microsoft Office？ 而家喺屋企都有得上堂！
