Excel Formulas and Functions Course

Excel Formulas and Functions Training Course

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.

Excel Formulas and Functions Training Course

What you’ll learn

Building formulas

  • Understanding Operator Precedence
  • Relative and Absolute Address notation

Working with links in formulas

  • Concepts of external references
  • Updating links and changing link source

Formatting numbers, dates and times

  • Numeric display formats
  • Date and time display formats

Understanding Excel’s error values

  • #DIV/0 !
  • #N/A
  • #NAME?
  • #NULL!
  • #REF!
  • #VALUE!

Handling errors

  • IfError(),IsError()

Working with Math functions

  • Round(), mround(), rounddown(), roundup(), ceiling(), floor(),Int(),Abs()

Working with text functions

  • lower(), upper(),proper(), dollar(), fixed(),text(),len(),trim(), clean(),rept(),left(),right(), mid(),find(),replace(),substitute()
  • Extracting first name, last name

Working with date and time functions

  • datevalue(), date(), year(),month(),day(),today(),now()
  • weeknum(),weekday()
  • Returning part of a date or part of a time
  • Calculating the difference between two dates or between two times

Working with Financial functions

  • Discounted cash flow calculation
  • Effect(),FV(), Rate(), PV(), PMT()

Working with Logical functions

  • AND, FALSE, NOT, OR, TRUE, IF, SUMIF(), AVERAGEIF(), COUNTIF()
  • SUMIFS(),AVERAGEIFS(),COUNTIFS()

Working with lookup functions

  • Lookup(), Vlookup(), Hlookup()

SCHEDULES
 
EFF0015 - 廣東話 30 Jan enrol
 
EFF0023 - Eng 11 Feb enrol
 
EFF0025 - 廣東話 19 Feb enrol
 
EFF0024 - 廣東話 26 Feb enrol
 
EFF0035 - 廣東話 06 Mar enrol