Infocan Training Limited

Microsoft Excel Formulas and Functions for Accounting & Financial Professionals

Enquire Now

Course Information

Schedules
  • 5 Jun 2021 (Sat) 9:30 AM - 4:30 PM
  • 12 Jun 2021 (Sat) 9:30 AM - 12:30 PM
Registration period
1 Apr 2021 (Thu) - 1 Jun 2021 (Tue)
Price
HKD 2,000
Course Level
Study Mode
Duration
9 Hour(s)
Language
Cantonese
Location
-
8 views

Course Overview

Physical Class in Kwun Tong Training Center and Private Class are available, click "Enquire Now" for enrollment and more training details

Microsoft Excel has a range of simple and easy to understand functions that can be used to calculate a variety of outcomes. This course will cover many common and useful functions in Excel. We explore how and when to use formulas and functions in Excel.

Upon completion of this course, participants will be able to:
-Use Information, Lookup Logical And Array Functions To Handle Large Amount Of Data Stored In Excel
-Use Date And Time Functions To Handle Time-Related Information
-Use Financial, Math And Trigonometry Functions To Process Data
-Use Text Functions To Handle Text

What you'll learn

• Date and Time Functions
‒ TODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
• Information Functions
‒ COUNTBLANK, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT
• Logical Functions
‒ IF, AND, OR, NOT, TRUE, FALSE
• Lookup Functions
‒ HLOOKUP, VLOOKUP, LOOKUP, MATCH
‒ New Function: XLOOKUP
• Math and Trigonometry Functions
‒ ABS, COUNTIF, INT, MOD, RAND, PRODUCT ‒ SUMIF, SUMPRODUCT, ROUND, ROUNDUP, ROUNDDOWN
• Statistical Functions
‒ AVERAGEA, COUNTA, MODE, MEDIAN
• Text Functions
‒ EXACT, LEFT, RIGHT,MID, LEN, SUBSTITUTE, TEXT, VALUE, TRIM, UPPER, LOWER, PROPER, CONCATENATE, DOLLAR
• Accounting Functions
‒ SLN, DDB, SYD, VDB
• Financial Functions and Formulas
‒ PMT, IPMT, PPMT, PV, FV
‒ Introduction to financial formulas
‒ Uses of financial functions and formulas



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