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   EFF3108 - Eng 18 Oct   EFF3114 - 廣東話 02 Nov   EFF3115 - 廣東話 02 Nov   EFF3116 - 廣東話 11 Nov   EFF3117 - Eng 27 Nov

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