Advanced VLookup Functions
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Price: $160
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

ABOUT THE COURSE

*The course will be delivered in Mandarin (中文授课).

UNITS

This course will cover the following topics:

  • Mechanism and Application of Exact Match
  • Mechanism and Application of Approximate Match
  • Find One Result that Meets Multiple-criteria
  • Find One Result that ‘partially’ Meets the Criteria
  • Find Multiple Results that Meet Required Criteria(s)
  • Use Vlookup to Execute Searching ‘Leftwards’
  • Learn and Apply Lookup
  • Summarise Why Vlookup Fails Sometimes
  • Create Synergy with IFERROR Statement

UPON COMPLETION

This course is eligible for CPD hours.

DURATION

*Please contact us for the timetable.

Trainer’s Profile

  • 17 Years of Dedicated Best-Practice Financial Modeller Extensive Experience in Building & Reviewing Complex Financial Model
  • Experienced Financial Controller of an ASX listed companies
  • Managing Director of AFMA (Australian Financial Modeller Association)
  • Committee Member of ACAA (Association of Chinese Accountants Australia)
  • Special Guest Trainer of ABC Television (Australian Broadcasting Corporation)
  • Guest BI (Business Intelligence) Lecturer of CPA Australia
  • Lecturer of Shanghai University of Finance and Economics MBA
  • Experienced Financial Analyst and Financial Modeller

     

TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Call Me Back