Course Information
Schedules
- 2 May 2025 (Fri) 10:00 AM - 5:00 PM
- 3 May 2025 (Sat) - 10 May 2025 (Sat) 10:00 AM - 1:00 PM
Registration period
18 Feb 2025 (Tue) - 23 Apr 2025 (Wed)
Price
HKD 1,780
Course Level
Study Mode
Duration
2 Day(s)
Language
Cantonese
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
8 views
Course Overview
Excel Function is the integral part in spreadsheet calculation. Knowing how to write Excel formulas is an essential skill in today competitive world. It helps users manage huge volume of data and simplify complex calculations.
The Excel Formulas and Functions course is suitable for those who want to write excel formulas in the following areas, logic, database, text and date, and finance or will use the Excel VBA in their spreadsheets.
Graded exercises are used throughout the class which allows users follow the lessons with confidence, the adoption of small class size teaching approach can further enhance the overall learning experience of our students.
What You’ll Learn
- Building formulas
- Working with links in formulas
- Formatting numbers, dates and times
- Understanding Excel’s error values
- Handling errors
- Working with Math functions
- Working with text functions
- Working with date and time functions
- Working with Financial functions
- Working with Logical functions
- Working with lookup functions
【CFA vs FRM有咩分別？CFA有甚麼考試資格？】特許金融分析師(CFA)定金融風險管理師(FRM)更值得考？一文睇清兩種金融專業資格認證出路(附考試內容、費用及優缺點)
【點先入到投行？】大學GPA好影響你入唔入到投行做嘢同實習機會？ GPA幾多可以報咩行業提高成功率？一文睇清各大行業對GPA要求！
【2024更新│行政人員│自我增值】Admin工作內容是？月薪有幾多？行政人員職責、發展前景、薪酬及建議進修課程一覽！
