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

Upcoming Sessions

Date Time (AEDT) Location Available Spaces Cost
23 April 2024 02:30 pm - 04:00 pm Online 5 $195.00
17 May 2024 12:00 pm - 01:30 pm Online 5 $195.00