Home · Course Details

Learn how to create and edit VLOOKUP and other Lookup formulas to extract data from Excel lists and tables based on variable conditions and criteria.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • Pre-requisites: Basic familiarity with Excel formulas
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understand when to use lookup formulas
  • Understand cell references with Excel formulas
  • Create named ranges
  • Use LOOKUP and VLOOKUP

Topics covered include:
  • Absolute Cell References
  • Using Relative instead of Absolute Cell References
  • Using Absolute Cell References in Formulas
  • Range Names
  • User Friendly Workbooks
  • Managing Range Names
  • The Name Manager
  • Defining a Name Range
  • Rules for Naming Ranges
  • Naming Ranges With the Name Box
  • Naming Multiple Ranges
  • Selecting Named Cells
  • Formulas with Range Names
  • Deleting Range Names
  • The LOOKUP Function
  • The VLOOKUP Function

No pre/post work required

Name Date Time Location Cost
Virtual Class - Excel: Mastering VLOOKUP formulas 19 March 2019 09:30 am - 11:00 am Online $99
Virtual Class - Excel: Mastering VLOOKUP formulas 4 June 2019 09:30 am - 11:00 am Online $99

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.