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 | ||
4 April 2023 | 09:30 am - 11:00 am | Online | 15 | $195.00 | ||
20 April 2023 | 02:30 pm - 04:00 pm | Online | 15 | $195.00 | ||
4 May 2023 | 12:00 pm - 01:30 pm | Online | 15 | $195.00 | ||
26 May 2023 | 09:30 am - 11:00 am | Online | 15 | $195.00 | ||
7 June 2023 | 09:30 am - 11:00 am | Online | 15 | $195.00 | ||
23 June 2023 | 12:00 pm - 01:30 pm | Online | 15 | $195.00 |