Excel tutorial: Using INDEX/MATCH to look up without using left-most column | lynda.com



This tutorial offers a more flexbile way to look up data in Excel 2013 than using the VLOOKUP function–using a combination of the INDEX and MATCH functions. Watch more at http://www.lynda.com/Excel-tutorials/Excel-2013-Power-Shortcuts/115432-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-bus-IX2TZ3OlOlA.

This tutorial is a single movie from the Excel 2013 Power Shortcuts course presented by lynda.com author Curt Frye. The complete course duration is 3 hours and 17 minutes long and reveals over 65 tips and tricks and shortcuts in Excel

1. Top Ten Shortcuts
2. Controlling the Excel Program and Interface
3. Organizing Data
4. Entering and Formatting Data
5. Managing Data Series
6. Working with Dates and Times
7. Creating Useful Formulas
8. Managing Formulas
9. Summarizing Data Using Charts and PivotTables
Conclusion

source

4 thoughts on “Excel tutorial: Using INDEX/MATCH to look up without using left-most column | lynda.com”

Leave a Reply

Your email address will not be published. Required fields are marked *