In this Excel index match tutorial I show you how to use Excel's INDEX function and MATCH function to look up data in one spreadsheet and match it with data in another. Very similar to how you join data in SQL.

In my previous video I showed you SQL joins. Check it out here:    • How To Join Data In SQL Inner Join, L...  

00:00 Intro
00:35 INDEX & MATCH
03:44 Multiple Criteria

START YOUR BI JOURNEY! - https://learnbi.online

🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - https://geni.us/learnbasicsql15-1
BI For Beginners Playlist - https://geni.us/biforbeginners-play

🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - https://geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - https://geni.us/vbi-edu
Google Data Analytics Course - https://geni.us/coursera_analytics
Learn SQL - https://geni.us/learnsql

SKILLSHARE - 30-day free trial! - https://geni.us/skillshare30day
UDEMY - https://geni.us/udemy_vb

📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook
Skills You Need To Succeed In BI - https://geni.us/biskills-ebook

🧰 BI TOOLS
Power BI - https://powerbi.microsoft.com/
Tableau - https://www.tableau.com/
Data Studio - https://datastudio.google.com/

📊 DATA HUBS & WEBSITES:
Power My Analytics: https://geni.us/YLc9Re
Supermetrics: https://geni.us/5SNn
Data Slayer: https://geni.us/dataslayer
Kaggle - https://www.kaggle.com/
Statista - https://www.statista.com/
Data World - https://data.world/

📕THE DATA VISUALISATION BIBLE - https://geni.us/iJTa8

🎥 MY YOUTUBE GEAR
My Camera - https://amzn.to/3J5lbeo
Most Used Lens - https://amzn.to/3hXoE2Q
Main Key Light - https://amzn.to/366KaPI
Softbox - https://amzn.to/35HrR46
LED Panel Kit - https://amzn.to/35K3Lpf
Teleprompter - https://amzn.to/3hWGT8p
Main Mic - https://amzn.to/3t1n1aK
Lavalier Mic - https://amzn.to/3vVUi8V

DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏


✅ LET'S CONNECT!
BUSINESS INQUIRIES - https://learnbi.online/contact
CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - https://geni.us/PSgRsF
FACEBOOK GROUP - https://geni.us/learnbi-fbg

nodemcu connecting to sql server

#exceltutorial #indexandmatch #businessintelligence