Excel – Mastering VLOOKUP formulas

Learn to record, run and edit Macros to automate routine Excel tasks using the Macro Recorder and Visual Basic for Applications (VBA) programming code.

Snapshot

Duration: 90 minute

Level: Intermediate

Pre-requisites: Basic familiarity with Excel formulas

Version: Suitable for 2010, 2013, 2016 and Office 365

Learning outcomes

  • Understand when to use lookup formulas
  • Understand cell references with Excel formulas
  • Create named ranges
  • Use LOOKUP and VLOOKUP
Download course outline

Upcoming Sessions

There are currently no openings available for this course.
Please enquire using the button below.

Enquire