Design a printable Identity Card Excel template in 10 minutes | Image LOOKUP with INDEX and Match

The sample file can be downloaded from this link: https://drive.google.com/file/d/1F9LDkG2-MQRWt3ma4t1_iI8cK7fMPPd7/view?usp=sharing

This video tutorial shows you how to create an Excel template for an identity card. Using this template you can change the images automatically when the person ID is changed. Check how to do the image LOOKUP using MATCH and INDEX functions.

Chapters: 0:00 Introduction 0:32 Make employee database 1:09 Adding the images in database 2:59 Designing the ID card 8:29 Image Lookup

#identitycardtemplate #exceltemplate #indexfunction #matchfunction

------------------------

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

Share, like and post any questions on the videos ... https://www.youtube.com/watch?v=1TwU-tGXr2Y