Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups

Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups, available at $22.99, has an average rating of 4.4, with 10 lectures, based on 65 reviews, and has 583 subscribers.

You will learn about Use VLOOKUP, INDEX MATCH, and other advanced formulas to automate work in Excel Perform advanced lookups based on both rows and columns at the same time Employ array functions to create complex formulas that pull data based on multiple criteria from a table Use INDIRECT and OFFSET with advanced string concatenation for the most automated lookups possible in Excel Save hours of work every day by automating spreadsheets This course is ideal for individuals who are This course is for folks who have a baseline familiarity with Excel, but haven't yet had the chance to explore more powerful and advanced formulas and functions. or Intermediate Excel users should be able to dive into these lessons with no problem, but some familiarity with the program is a pre-requisite — including general knowledge of what a formula is and how it works; how to enter formulas into cells; absolute and relative cell references; and working with strings. or Towards the end of this course, we'll build on what we've learned to dive into some advanced lessons that will help even experienced Excel pros get the most out of their spreadsheets. or This course is recorded on a Windows computer, but the formulas and functions we use are also applicable to Excel for Mac It is particularly useful for This course is for folks who have a baseline familiarity with Excel, but haven't yet had the chance to explore more powerful and advanced formulas and functions. or Intermediate Excel users should be able to dive into these lessons with no problem, but some familiarity with the program is a pre-requisite — including general knowledge of what a formula is and how it works; how to enter formulas into cells; absolute and relative cell references; and working with strings. or Towards the end of this course, we'll build on what we've learned to dive into some advanced lessons that will help even experienced Excel pros get the most out of their spreadsheets. or This course is recorded on a Windows computer, but the formulas and functions we use are also applicable to Excel for Mac.

Enroll now: Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups

Summary

Title: Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups

Price: $22.99

Average Rating: 4.4

Number of Lectures: 10

Number of Published Lectures: 10

Number of Curriculum Items: 10

Number of Published Curriculum Objects: 10

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Use VLOOKUP, INDEX MATCH, and other advanced formulas to automate work in Excel
Perform advanced lookups based on both rows and columns at the same time
Employ array functions to create complex formulas that pull data based on multiple criteria from a table
Use INDIRECT and OFFSET with advanced string concatenation for the most automated lookups possible in Excel
Save hours of work every day by automating spreadsheets

Who Should Attend

This course is for folks who have a baseline familiarity with Excel, but haven't yet had the chance to explore more powerful and advanced formulas and functions.
Intermediate Excel users should be able to dive into these lessons with no problem, but some familiarity with the program is a pre-requisite — including general knowledge of what a formula is and how it works; how to enter formulas into cells; absolute and relative cell references; and working with strings.
Towards the end of this course, we'll build on what we've learned to dive into some advanced lessons that will help even experienced Excel pros get the most out of their spreadsheets.
This course is recorded on a Windows computer, but the formulas and functions we use are also applicable to Excel for Mac

Target Audiences

This course is for folks who have a baseline familiarity with Excel, but haven't yet had the chance to explore more powerful and advanced formulas and functions.
Intermediate Excel users should be able to dive into these lessons with no problem, but some familiarity with the program is a pre-requisite — including general knowledge of what a formula is and how it works; how to enter formulas into cells; absolute and relative cell references; and working with strings.
Towards the end of this course, we'll build on what we've learned to dive into some advanced lessons that will help even experienced Excel pros get the most out of their spreadsheets.
This course is recorded on a Windows computer, but the formulas and functions we use are also applicable to Excel for Mac

JOIN DESKBRIGHT’S COMMUNITY OF THOUSANDS OF STUDENTS TO LEARN INCREDIBLE FORMULAS AND FUNCTIONS THAT WILL HELP AUTOMATE YOUR WORK IN EXCEL.

++++++++++++++++++++++++++++++++++

Created:�June 2016

++++++++++++++++++++++++++++++++++

About This Course

So, you use Excel at work. And, you’ve got a handle on the basics. But you’ve got a feeling that if you just knew a little bit more about the program, you could be way more productive at work.

Unfortunately, it’s hard to figure out how to begin. Online forums and websites are crammed with confusing information, and there’s so much content out there that it’s tough to decide where to start.

Well, don’t worry — Deskbright is here to help! We’ve identified Excel’s most important features and bundled them into a series of engaging videos that make learning spreadsheets easy.

In this advanced course, we’ll cover lookups — some of Excel’s most powerful features. From common functions like VLOOKUP and HLOOKUP through more advanced formulas, we’ll cover everything you need to know to become a pro.

In this course, we’ll follow a fictional company called SnackWorld as it uses Excel to extract valuable insights from its business data. All of our lessons are based on real-world uses of these functions, so you’ll get to see live applications of everything you learn. You’ll get over an hour of easy-to-understand video, taught by master Excel instructor Sam McIntire. Plus, comprehensive exercises and answer keys to go along with every function you’ll learn — and a comprehensive culminating exercise to test your skills.

It’s time to stop wondering, and take your potential into your own hands. With a little bit of practice, you can make your work work look easy!

About The Instructor

This course is taught by master Excel instructor Sam McIntire of Deskbright. Through his website, Sam has helped thousands of students just like you learn the skills they need to thrive at work. Sam:

Has helped thousands of students�learn the Excel formulas and functions they need to succeed at work;
Is an experienced management consultant�who learned Excel on-the-job at a top tier firm;
Has received hundreds of positive reviews and ‘thank you’ e-mails from students whose work was transformed by his lessons.

Course Benefits

Succinct, to-the-point, and easy-to-follow videos that will help you learn Excel quickly and easily;
Advanced formulas used by professionals in top-tier consulting firms — now available to you!
Comprehensive exercises and answer keys to accompany every video, so that you can practice your skills as you learn;
A culminating, real-world exercise so that you can test your skills in a live business scenario.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Basic lookups

Lecture 1: The famous VLOOKUP

Lecture 2: The lesser-known HLOOKUP

Chapter 3: Improving our lookups with INDEX MATCH

Lecture 1: Using INDEX MATCH

Lecture 2: Different MATCH types

Chapter 4: Advanced lookups

Lecture 1: Two-dimensional lookups

Lecture 2: Multi-criteria lookups

Chapter 5: Helper functions

Lecture 1: The INDIRECT function

Lecture 2: Using OFFSET

Chapter 6: Tying it all together

Lecture 1: Exercise: SnackWorld Customer List

Instructors

Sam McIntire
Master Excel Instructor and Founder of Deskbright

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 12 votes
4 stars: 18 votes
5 stars: 32 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu