Lookup Functions in Excel
Learn to Master the inner workings and correct for the limitations of the core lookup functions: VLOOKUP, INDEX, MATCH, OFFSET, CHOOSE and more
This course will teach participants the essential features of these tools that will drastically improve your turnaround time when accomplishing various tasks. You will learn how to utilize MS office tools to enhance your productivity
A business analytics tools that deliver insights throughout your organization.
Build simple yet dynamic templates for “on the job use
Employ formulas, functions and data tools to perform simple data analysi
Produce a complete reporting solution from scratch in a full Day Case Study Session
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“Very well versed on the topic, Was able to gain, sustain the attention and interest of participants. He carried everybody along despite different excel verion used. He was able to Communicate effectively. ”
“The instructor was able to impart Knowledge on how to navigate through excel, effectively Nice way of carrying the class using good example and logics ”
“An articulate lecturer with good mastery of the subject matter and efficient delivery. Without gainsaying the quality of the course content is superb ”
Here's what you'll learn...
Overview
FREE PREVIEWHow to use this Platform
FREE PREVIEWDownload the Exercise Files
Introduction
FREE PREVIEWOverview of lookup Functions
The VLOOKUP Function
The MATCH Function
MATCH Function to the rescue of the VLOOKUP function
The HLOOKUP Function
MATCH Function to the rescue of the HLOOKUP Function
Ask the Trainer
The INDEX Function
MATCH Function double duty to help The INDEX Function
The OFFSET Function
The OFFSET Function with help from the MATCH Function
Ask the Trainer
The CHOOSE Function for typical Lookups
Ask the Trainer
Practice Assignment
Practice Assignment Solution 1 of 2
Practice Assignment Solution 2 of 2
Ask the Trainer
The VLOOKUP Function, a cool Feature 1 of 2
The VLOOKUP Function, a cool Feature 2 of 2
Master the OFFSET Function - Part 1 of 2
Master the OFFSET Function - Part 2 of 2
Ask the Trainer
How to Attach your Certificates to your LinkedIn Profile
You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.
Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.
You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.
Deferral requests are treated on a case by case basis. Please email training@dbrownconsulting.net with your request.
Our videos are only available for streaming online. But you can download all exercise files and materials.
10,000+ people are learning on our platform
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”
“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”
“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”
“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”
“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”
“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”