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
 
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