# Excel Formulas and Functions 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. # What you’ll learn

## Building formulas

• Understanding Operator Precedence
• Relative and Absolute Address notation

## Working with links in formulas

• Concepts of external references

## Formatting numbers, dates and times

• Numeric display formats
• Date and time display formats

• #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()