Master Lookup Functions in Excel for Accounting and Bookkeeping

Productivity - Paula Guilfoyle

Ready to take this Premium course?

Sign up today and continue this course plus 1000 more courses anytime, anywhere.

Start Your Free Trial Now

Lookup functions on an excel sheet make's it extremely easy for people who work on multiple excel sheets to match data in various places. This course helps you understand and learn 6 plus lookup functions and become an expert in using them.

MS Excel & 6 lookup functions

MS Excel

 

Learning Objectives:

  • Carry out Basic V-lookups and H-lookups in Excel
  • Use the Index and Match functions in isolation and combined
  • Combine V-lookup with Match for a more dynamic formula
  • Carry out a lookup to the left
  • Use the V-lookup function with Text
  • Use the Choose function to lookup values
  • Workbooks to download
  • Activities to complete

Instructor

Paula Guilfoyle

Operations and Business Management Expert

Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business

What will you cover?

  •   Introduction 0:01:39
  •   Vlookup basics 0:10:44
  •   Index match 0:10:27
  •   Left lookup 0:03:19
  •   Vlookup match 0:03:46
  •   Lookup text 0:04:29
  •   Choose function 0:08:11
  •   H lookup 0:07:08
  •   Conclusion 0:00:53

Instructor

Paula Guilfoyle

Operations and Business Management Expert

Paula carries around 15 years of experience in the field of Accountancy, Auditing, Business and Operations…

Training 5 or more people?

Get your team access to WIISE top 2,000 courses anytime, anywhere.

Try WIISE for Business

Project Description

 

Complete the activity in the supporting materials. Your assignment is to download the workbook and complete the activity as detailed.

Share a screenshot of your workbook with the VLOOKUP formula complete and correct, or copy and paste the formula that you have created......

We look forward to seeing how you get on!

 

Attachments

Lookup Functions-Zip File - 11 KB

Related Courses

David Ringstrom
Introduction to Excel 2016
  59m           9,730 Views
David Ringstrom
Tricks for Efficiency in Excel
  48m           11,749 Views
David Ringstrom
Macros in Excel: Part I
  52m           9,276 Views