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
25 August 2022 09:30 am - 11:00 am Online 5 $195.00
6 September 2022 09:30 am - 11:00 am Online 5 $195.00
28 September 2022 12:00 pm - 01:30 pm Online 5 $195.00
5 October 2022 09:30 am - 11:00 am Online 5 $195.00
11 October 2022 12:00 pm - 01:30 pm Online 5 $195.00
25 October 2022 02:30 pm - 04:00 pm Online 5 $195.00
21 November 2022 09:30 am - 11:00 am Online 5 $195.00
23 November 2022 12:00 pm - 01:30 pm Online 5 $195.00
1 December 2022 09:30 am - 11:00 am Online 5 $195.00
7 December 2022 12:00 pm - 01:30 pm Online 5 $195.00
31 January 2023 09:30 am - 11:00 am Online 15 $195.00
22 February 2023 12:00 pm - 01:30 pm Online 15 $195.00
28 February 2023 02:30 pm - 04:00 pm Online 15 $195.00
16 March 2023 12:00 pm - 01:30 pm Online 15 $195.00
22 March 2023 02:30 pm - 04:00 pm Online 15 $195.00