[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel

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 Online Excel Training 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: https://trumpexcel.com/learn-excel/ You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6 Free Excel Course - https://trumpexcel.com/learn-excel/ Paid Online Training - https://trumpexcel.com/excel-training/ Best Excel Books: https://trumpexcel.com/best-excel-books/ ⚙️ Gear I Recommend: Camera - https://amzn.to/3bmHko7 Screen Recorder - techsmith.z6rjha.net/26D9Q USB Mic - https://amzn.to/2uzhVHd Wireless Mic: https://amzn.to/3blQ8uk Lighting - https://amzn.to/2uxOxRv Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 Note: Some of these links here are affiliate links! #Excel #ExcelTips #ExcelTutorial