Computer Academy

EXCEL FORMULAS AND FUNCTIONS COURSE

Enquire Now

Course Information

Schedules
  • 7 Feb 2023 (Tue) 10:00 AM - 5:00 PM
  • 8 Mar 2023 (Wed) 10:00 AM - 5:00 PM
Registration period
25 Nov 2022 (Fri) - 22 Feb 2023 (Wed)
Price
HKD 1,780
Course Level
Study Mode
Duration
1 Day(s)
Language
English
Location
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong
1 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

 



Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed