// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel...
2. Excel Campus Elevate Program: go.launchexcel...
3. My Online Training Hub Dashboards: go.launchexcel...
4. Coursera Excel Specialisation: go.launchexcel...
5. Coursera Everyday Excel: go.launchexcel...
6. Coursera Excel Data Visualisation: go.launchexcel...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Download the Sample workbook to follow with the video - visit this page on my website - www.launchexcel...
This tutorial helps you learn 3 ways to write a VLookup formula to make it dynamic.
Simple method (type in numbers for column index number)
Using COLUMN function to specify column index number
Using MATCH function to specify column index number
You can find the full video transcript with more screenshots here: www.launchexcel...
Негізгі бет Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 2 of 2
Пікірлер: 4