Vlookup Explained- 1 Hr

Or log in to access your purchased courses

Vlookup Explained in simple terms

One of the most important formula in Excel is the VLOOKUP formula. It has a variety of practical uses and is the stepping stone into truly understanding how Excel thinks. The  ‘VLOOKUP explained in simple terms’ is a series of VLOOKUP lessons that will start you at the basics and turn you into a VLOOKUP Pro. It includes VLOOKUP practice exercises and quizzes.

Some of the practical uses for VLOOKUP are:

  • Joining databases and tables e.g. attach employee names to there salaries, address details etc
  • Find missing items (useful for reconciliation)
  • Compare 2 columns (useful for reconciliation
  • Make areas static, anchor data to work with
  • Let Excel guestimate an answer
  • Create categories for employee performance, grouping of sales, grouping employees into age brackets
  • Age invoices, stock and debtors into bands- aging anything
  • Sales commission bands
  • Tax bands
  • Different interest rates at different bank balance levels
  • Create costs that affect certain months depending on business activity
  • Calculate step up costs and fixed costs in a financial model

If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

Modules

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons