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 | ||
| 27 September 2023 | 09:30 am - 11:00 am | Online | 5 | $195.00 | ||
| 4 October 2023 | 02:30 pm - 04:00 pm | Online | 5 | $195.00 | ||
| 16 October 2023 | 09:30 am - 11:00 am | Online | 5 | $195.00 | ||
| 8 November 2023 | 09:30 am - 11:00 am | Online | 5 | $195.00 | ||
| 21 November 2023 | 12:00 pm - 01:30 pm | Online | 5 | $195.00 | ||
| 4 December 2023 | 02:30 pm - 04:00 pm | Online | 5 | $195.00 | ||
| 12 December 2023 | 12:00 pm - 01:30 pm | Online | 5 | $195.00 |
Need a scalable, cost-effective solution to team training?
Try our Live Virtual Class Subscription. Access over 60 different training modules from just $10 per seat! Try it free for one month for you and one employee.