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

Online Course

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

What is the course about?

Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
The course Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Master the use of lookup functions like VLOOKUP, INDEX MATCH, OFFSET, and INDIRECT to automate your work!

Course description
  • Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
  • 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
  • Microsoft Excel 2007 or later — Windows or Mac!
  • 1 hour on-demand video
  • 1 article
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • Sam McIntire

Prerequisites & Facts

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

Course Topic

Excel, Microsoft, Office Productivity

University, College, Institution

Udemy

Course Skill Level

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Degree & Cost

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

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.
Udemy
Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
provided by Udemy

Reviews

Share your experience

Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
Udemy Udemy
Rate the course

Do you recommend the course? *
Here you can find information, reviews and user experiences for the course “Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups“. The provider of the course – “Udemy” – will be glad to answer any questions you may have about the class, click here to use the offical support channels. It would be great if you could share your experience of participating in the course – Your honest review will surely help others to choose the right class!
School: Udemy
Topic: Excel, Microsoft, Office Productivity