Excel 4 Accounting & Bookkeeping - Master Lookup Functions
4.4 (138 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,634 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 4 Accounting & Bookkeeping - Master Lookup Functions to your Wishlist.

Add to Wishlist

Excel 4 Accounting & Bookkeeping - Master Lookup Functions

Lookup to the right, Lookup to the left, Index, Match and Choose - Master Lookups Now
4.4 (138 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,634 students enrolled
Created by Paula Guilfoyle
Last updated 6/2016
Current price: $10 Original price: $35 Discount: 71% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • You should have Excel knowledge similar to that offered in the free Udemy Course - Basic Excel for Basic Bookkeeping

Excel for Accounting and Bookkeeping - Master Lookup Functions. A comprehensive course for those that wish to up skill in Excel and Learn advanced lookup formula.

In This Course You Will Learn How Lookup To The Right and the Left, Use Index and Match, Use Combinations of Index, Match and Vlookup, Carry out Lookups with Text And Use The Choose Function.

Do you need to understand and carry out basic or complex lookups in Excel? Then this course is for you!

Course Overview

This course begins with some basic lookup formula but quickly moves into more complex examples, providing solutions to common lookup problems.

This course contains:

Activities are used through out this course and the answer from one activity leads into a later activity.

Workbook to download

Certificate of Completion

******BONUS****** FREE Join a community of other learners where you can interact with each other and with the instructor.


REGISTER NOW and get started with Excel for Accounting and Bookkeeping - Master Lookup Functions


Your purchase is 100% RISK FREE with a 30 day money-back guarantee. If you don't learn anything new from this course, simply request a refund within your 30 day period for your money back, no questions asked.

Who is the target audience?
  • These functions work in all versions of Excel
  • You should take this course if you are interested in becoming more efficient in your daily Excel and Spreadsheets tasks.
  • This course is for you if you wish to improve your Excel skills and Master Lookup functions
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 12 Lectures Collapse All 12 Lectures 51:59
Bookkeepers and Accountant - Master Lookup functions
12 Lectures 52:08

In this introduction lecture you will find out what you will be able to achieve at the end of Excel 4 Accountants and Bookkeepers - Master Lookup Functions

We will begin this course with a look at the basic Vlookup and Hlookup formulas, we will then move on to the use of Index and match and how these can be combined together or with Vlookup to really power up your lookups. By the end of this course, not only will you be able to look up data to the right easly enough, but you will also be able to lookup to the left, preform lookups within text and apply the choose function.

Preview 01:39

In this lesson you will find the excel workbook to download so that you can practice along with the examples shown

Course Material

We will start this lesson by introduction the Vlookup function and then we will hop into Excel and look at these by way of example. First we will look at an example of a Vlookup with an Exact Match and then with an Approximate Match.

Preview 10:44

First you will be introduced to the Match function and then the Index function. We will look at examples of both of these function in isolation before we combine Index and Match to make a powerful 2 way lookup function

Index and Match in Excel

The V-lookup function has a number of limitations, and in this section we will have a look at a work around for one of these limitations. In this lesson we will combine V-lookup with Match

More Dynamic V-lookup

Another limitation of Excel V-lookup is that it can only lookup to the right, In this lesson you will learn how to lookup to the left....

Lookups to the Left

The Choose function

In this lesson you will learn how to use the MID function in Excel to extract text from a string and then combine this with Vlookup

Lookups with Text

In this lesson we will look at Hlookup


A quick wrap up and conclusion


In the lesson you will get the opportunity to practice what we have covered...Don't forget to download the workbook

Course Activities

About the Instructor
Paula Guilfoyle
4.3 Average rating
1,077 Reviews
18,380 Students
18 Courses
CPA Accountant, Online Educator & Life Long Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.