Excel 4 Accounting & Bookkeeping - Master Lookup Functions

Lookup to the right, Lookup to the left, Index, Match and Choose - Master Lookups Now

4.80 (195 reviews)

Udemy

platform

English

language

Accounting & Bookkeeping

What you will 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

Why take this course?

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.

Reviews

Andre

March 13, 2021

It went a little bit quickly and I thought there was going to be a excel file for the H lookup function but I made my own and it was really helpful that I did because I was able to grasp it. Very great job overall I will be buying more excel courses no doubt

Blantina

February 4, 2021

The course was a good match for me but I feel some parts the lecturer hurried through them, especially the choose function.

Jueyu

July 31, 2019

overall good, compared with other courses that I have taken, would be better if filled with more cases.

Nuzhat

May 10, 2016

I like that I can see the tutor talking and this feels like being in the classroom and information is being communicated to me via a person as opposed to just a voice. The explanations are easy to understand.

Saeed

April 15, 2016

Its a very good informative course. I am looking for a course in which one entry effect all the related reports like one entry effect in Ledgers, Trial Balance, Income statement and Balance Sheet.

Kagiso

April 9, 2016

I'm loving this course. It's as if I never used Excel before i'm learning so many things. This course is great!!!!

Ricardo

April 4, 2016

The lecturer knows her excel. I have definitely learnt a lot of concepts i struggled with especially the Index & Match functions. Well done to the lecturer!

Charts

Price

Rating

Enrollment distribution

Excel 4 Accounting & Bookkeeping - Master Lookup Functions - Distribution chart