Course Information
Registration period
19 Aug 2024 (Mon) - 25 Sep 2024 (Wed)
Price
HKD 2,860
(Enrolling this course on or before 31st August can receive early bird discount of $400
)
(Enrolling this course on or before 31st August can receive early bird discount of $400
)
Course Level
Study Mode
Duration
12 Hour(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
25 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
