Excel Formulas and Functions Course

Excel Formulas and Functions Training Course

Excel Formulas and functions 在 Excel 的應用上是一重要環節。 Excel Functions的運用有助建設較複雜的試算表 (Spreadsheet) 及提升 Excel 試算程序的自動化。

除此之外, Formulas and functions 更是使用 Excel VBA / Macro (Visual Basic for Applications) 程式語言的人士所必須掌握的技巧。此課程是從事數據處理、大量應用 Excel 進階技巧及致力提升 Excel應用技能的人士必修之選。

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
 
EFF7091 - 廣東話 05 Sep enrol
 
EFF7092 - 廣東話 06 Sep enrol
 
EFF7101 - Eng 11 Oct enrol
 
EFF7102 - 廣東話 12 Oct enrol
 
EFF7111 - Eng 07 Nov enrol
RELATING COURSES
  Excel VBA
  Excel Dashboards and Reports
  Excel Formula & Function + Advanced Excel
  Excel Formula & Function + Advanced Powerpoint
  Excel-Advanced
  Mastering Excel PivotTables and PivotCharts