Month: July 2019

Excel TutorialTutorial

Create a Searchable Drop-down in Excel

Create a Searchable Drop-down in Excel Using data validation you can create useful drop-down lists in Excel.  If your list contains lots of values, it might be worth making it searchable.  The video below explains how this can be done - no VBA required!  Download the featured file here.

 

VIDEO TRAINING - LEARN AT YOUR OWN PACE

DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECTClick here to enrol

THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol


FREE STUFF
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf 

 

 

https://www.youtube.com/watch?v=D6y8Rs0zUwo&t=65s Formulas used in…

Read More