Key Consulting Excel Skills - How to use Index Match in Excel for Consultants

Do you still use the Excel formula VLOOKUP for your lookups? In consulting, this is considered unprofessional for many use cases. Index Match is a better alternative. How to use Index Match in Excel - is this a question that you ask yourself? In this video, I will explain in detail what Index Match is and how it works. It is a powerful Excel formula, providing a 2-dimensional lookup into any data table. In many MBB consulting firms like McKinsey, BCG or Bain, young consultants are asked to learn Index Match early on as Excel essentials. It is part of many management consulting training programs. Learn Index Match in Excel for consultants with this video. It is an Index Match tutorial for Excel and will help you improve your Excel skills. Get ready for your next consulting job with these advanced Excel skills. Do not use VLOOKUP, as it has significant downsides over INDEX MATCH. This is advanced Excel for Accounting and Finance professionals, as well as management consultants.

# MY ONLINE COURSES*
Learn to make PowerPoint presentations like Top Management Consultants:
"CEO-level Presentation Skills - Slide Writing for Consulting"
https://link.firmlearning.com/slides

Everything you need to know about Blockchain and Cryptocurrency:
"The Complete Course on Blockchain and Bitcoin"
https://link.firmlearning.com/blockchain

Udacity - Learn the latest tech skills, great to learn how to code without technical background (e.g., as business student) - with this link, 50 USD discount on all courses
https://link.firmlearning.com/udacity

# NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
https://link.firmlearning.com/e-mail

# BOOK RECOMMENDATIONS*
The Hard Thing About Hard Things - Ben Horrowitz
https://amzn.to/3aYseE8
Extreme Ownership: How US Navy Seals Lead and Win - Jocko Willink
https://amzn.to/3d32sAE
The McKinsey Way - Ethan Rasiel
https://amzn.to/38SQarl
Influence: The Psychology of Persuasion - Robert Cialdini
https://amzn.to/2wUI4Bd
How a Diet can be a Game Changer in Life - Marie Mirrlees
https://amzn.to/2MUyfIh

# MY EQUIPMENT*
Camera: https://amzn.to/32GZ3o7
Lense: https://amzn.to/3fMIkUo
Lights: https://amzn.to/32F6tZ3
Microphone: https://amzn.to/2E2mpud

# AUDIOBOOKS*
This is a link to the audiobook service Audible that I use every day. It helps me "read" 50+ books every year. The link gives you a free test month:
https://link.firmlearning.com/audible

# SOCIAL MEDIA
Instagram: https://link.firmlearning.com/instagram
Facebook: https://link.firmlearning.com/facebook

# NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter to continue learning about Business and Management:
https://link.firmlearning.com/e-mail

* Links are Affiliate links. This means that I receive a revenue share whenever a purchase is made via the link. The price for you stays the same. Thank you for supporting my work at Firm Learning!

All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.

Видео Key Consulting Excel Skills - How to use Index Match in Excel for Consultants канала Firm Learning