Microsoft Excel Tutorial 29 – How to use Index, Match, Lookup and HLookup in Excel



In this MS Excel tutorials video, we are going to learn about the 4 functions which are used to search for values from a given data structure in MS Excel. We have already learnt about VLOOKUP functions, so in this video we are going to learn about:
INDEX
MATCH
HLOOKUP, and
LOOKUP functions in MS Excel Welcome to the The Beginner's Guide course to Excel. This course enables you to Learn MS Excel in simple and easy steps. In this Microsoft Excel Basics Tutorial series we will start from the basics and gradually move towards the Expert level in Microsoft Excel. This MS Excel course provides the Beginners to Intermediate Excel Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, Make simple pivot tables and charts, Create simple Excel formulas, How to Use Excel Functions IF and VLOOKUP. Learn common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff. In this video we will see the Overview of formulas in Excel. We will see Basic Excel formulas & functions with examples . #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse #ExcelFormulas #ExcelFunctions

Microsoft Excel Tutorial 29 – How to use Index, Match, Lookup and HLookup in Excel

Microsoft Excel Tutorial 29 – How to use Index, Match, Lookup and HLookup in Excel

 

 

 

 

 

 

 

 

 

Contact us

More Microsoft Excel Tutorial 29 – How to use Index, Match, Lookup and HLookup in Excel Videos