Course Information
Schedules
- 26 Nov 2024 (Tue) - 11 Dec 2024 (Wed) 7:00 PM - 10:00 PM
Registration period
21 Nov 2024 (Thu) - 26 Nov 2024 (Tue)
Price
HKD 2,860
(Promotion discount $600 till to 23 Nov)
(Promotion discount $600 till to 23 Nov)
Course Level
Study Mode
Duration
4 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
27 views
Course Overview
The Certificate Course in Microsoft Excel is a comprehensive program that equips individuals with the skills needed to succeed in today's data-driven world. Participants will gain proficiency in essential Excel functions like lookup and what-if analysis, as well as advanced features such as advanced filtering, macro automation, and data processing. Through hands-on exercises and real-world examples, participants will learn to apply these techniques to solve business problems effectively.
This course is ideal for everyone seeking to enhance their analytical capabilities or aspiring data analysts looking to kickstart their careers. Upon completion of the Certificate Course in Excel, participants will have the skills and confidence to become Excel power users.
What You’ll Learn
Excel Module
- Understanding Excel's elements
- Editing techniques
- Writing formulas
- File operations
- Printing worksheets
- Useful functions
- Tips in editing a worksheets
- Understanding address notations
- Polishing worksheets
- Number format
- Exchange files with other applications
- Styles
- Managing Records
- Drawing
- Charting
- Using Layout tab
Advanced Excel Module
- Naming cells and ranges
- Database
- Advanced data sorting and subtotal
- Using database functions
- Managing multiple worksheets
- 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
