If you want to get good with Excel, Lookup and Reference formulas are something you must learn about. You don’t need to know each and every formula, but a basic understanding of these will help you a lot.
In this video, you will learn about the following LOOKUP and REFERENCE formulas:
— VLOOKUP function
— HLOOKUP function
— INDEX function
— MATCH function
— OFFSET function
— INDIRECT function
— ROW function
— ROWS function
— COLUMN function
— COLUMNS function
This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX
-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:
TrumpExcel.com | Online Excel Tips & Tutorials (with videos)
-~-~~-~~~-~~-~-
Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel