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   EFF5047 - 廣東話 08 Apr   EFF50410 - 廣東話 16 Apr   EFF50412 - 廣東話 16 Apr   EFF50411 - Eng 28 Apr   EFF5053 - 廣東話 02 May

RELATING COURSES   Excel VBA X ChatGPT/GPT   Excel Dashboards and Reports   Excel Formula & Function + Advanced Excel   Excel Formula & Function + Advanced Powerpoint   Excel-Advanced   Mastering Excel PivotTables and PivotCharts