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
 
EFF4106 - 廣東話 26 Oct enrol
 
EFF4115 - 廣東話 19 Nov enrol
 
EFF4114 - Eng 21 Nov enrol
 
EFF4126 - 廣東話 14 Dec enrol
 
EFF4125 - 廣東話 16 Dec enrol
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