10:00 AM - 5:00 PM
(Enrolling this course on or before 30th November can receive early bird discount of $200)
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.
- 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
10:00 AM - 5:00 PM
(Enrolling this course on or before 30th November can receive early bird discount of $200)