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

Date Time (AEDT) Location Available Spaces Cost
24 January 2025 02:30 pm - 04:00 pm ONLINE 5 $225.00
Group Bookings
Enrol
28 February 2025 02:30 pm - 04:00 pm ONLINE 5 $225.00
Group Bookings
Enrol
12 March 2025 12:00 pm - 01:30 pm ONLINE 5 $225.00
Group Bookings
Enrol
Enquire