Course Information
Schedules
- 4 Jun 2021 (Fri) - 25 Jun 2021 (Fri) 7:00 PM - 10:00 PM
Registration period
20 Apr 2021 (Tue) - 28 May 2021 (Fri)
Price
HKD 2,860
Course Level
Study Mode
Duration
12 Hour(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
67 views
Course Overview
Excel is a powerful tool used in most companies. Managements can formulate strategies and decisions on data after being processed and analyzed with Excel. It explains why most companies would like to recruit candidates with good knowledge in Excel. The course is packed with two hottest courses, Excel and Advanced Excel, that can match today's business needs.
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
