Excel Index and Match Functions by Chris Menard скачать в хорошем качестве

Excel Index and Match Functions by Chris Menard

Use the Index and Match function to find a number across rows and down columns. The VLookup function will not do this. You can replicate this video and follow up by just opening Excel and putting in the information shown. Bookmarks: 00:18 - first Match Function 00:59 - 2nd Match Function 01:40 - Index Function 03:08 - Functions displayed on the screen 03:26 - Data Validation I have two videos on Data Validation Video on VLookup if you need to know when to use True vs False condition.    • Excel Vlookup showing false and true argum...   Chris Menard provides on-site Microsoft Office training to companies in metro Atlanta and the United States. He also does public speaking And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!