Information of news
2-07-2021, 23:00

Microsoft Excel - VLOOKUP & HLOOKUP Crash Course

Category: Tutorials

Microsoft Excel - VLOOKUP & HLOOKUP Crash Course
Created by Kerron Duncan | Published 6/2021
Duration: 1h 4m | 3 sections | 12 lectures | Video: 1280x720, 44 KHz | 600 MB
Genre: eLearning | Language: English + Sub


Quickly Master Using VLOOKUP, HLOOKUP , Other Functions & Features to Maximize Your Productivity & Efficiency in Excel

What you'll learn
Master using VLOOKUP both at a basic and advance level. Learn to combine VLOOKUP with IFERROR, MATCH and other powerful features in Excel. Also learn how to perform HLOOKUPS.

Basic Excel Experience
I not only benefited greatly from this course but I truly enjoyed every minute of it! Kerron did a stellar job in teaching with clarity and simplicity. It's super easy to follow along and he is very motivating! Hands down one of the best instructors I have come across in Microsoft Excel, can't wait for the next course! - D. Samaroo
I really enjoyed the course! I wasn't that interested in Microsoft Excel so I was surprised to see how useful it can be. The teacher was well organized, the lessons were structured in a logical, easy to follow method. His explanations were clear and understandable and the exercises he gave really helped to cement the things I was learning. 10/10 definitely would recommend. JB
Enroll in this course to master using VLOOKUP and HLOOKUP. You will be able to get that job or that pay raise that requires that you master VLOOKUP. The course walks you through the basics of using VLOOKUP so that you don't get overwhelmed, then step by step you will learn more advance ways of using VLOOKUP which will surpass the average use of this powerful function in Excel. You will learn how to significantly boost your productivity and impress your Boss because of the time that you will save once you become a master in using VLOOKUP. HLOOKUP and other functions are also covered. The topics the course will take you through are the learning outcomes are as follows following:
Learn the Fundamentals of Using VLOOKUP
Learn the Fundamentals of Using HLOOKUP
Master Absolute, Relative and Mixed Referencing to Prevent VLOOKUP Errors
Make VLOOKUP More Readable Using Named Arrays
Deal With VLOOKUP Errors Using IFERROR
Learn How and When to Search for Approximate Matches
Use Dropdowns to Return Dynamic Statistics from VLOOKUP and HLOOKUP
Nest VLOOKUP and MATCH to Perform More Dynamic and Automatic Lookups

Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news