Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 22 Minute(s)
Language
English
Taught by
Chase Raz, M.B.A.
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn to use some of the most popular Excel functions for tabular lookups. Learn VLOOKUP, HLOOKUP, and LOOKUP functions.
VLOOKUP is one of the most requested Excel function tutorials that I've received in over eight years of providing corporate training in Microsoft Excel. All too often, professional Excel users get caught up in inefficient and problematic workflows, and nested conditionals (nested IF statements) are certainly towards the top of the list. Learn to solve this, and other problems, by utilizing the VLOOKUP, HLOOKUP, and LOOKUP functions.
Some of the abilities you'll gain by understanding these functions are:
Eliminate nested conditional (IF) statements
Pull data from disjointed or broken tables
Allow for autofill even when a reference table is transposed
Create scalable drop-down validation lists
Course Content
- 7 section(s)
- 17 lecture(s)
- Section 1 Introduction
- Section 2 Excel Functions
- Section 3 VLOOKUP
- Section 4 HLOOKUP
- Section 5 LOOKUP
- Section 6 Data Validation
- Section 7 Conclusion
What You’ll Learn
- Replace lengthy nested IF functions in Excel spreadsheets
- Return information associated with a lookup value from a table
- Identify the location of a lookup value within a table
Skills covered in this course
Reviews
-
RRoberta Fraine
amazing program helped me understand the lookup funtions better
-
DDerrick Voss
Not yet finished
-
AAndrew Wood
Has given me a much better understanding of how all the different lookup functions work. Great stuff!!
-
VVeronica Gonzales
hey!!! what's going on with the technology...video keeps freezing AND I'm barely in the beginning of the intro course :(
