Video duration: 256 seconds
Global video hits: 12352
Excel! See how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
See how to do this lightening fast with keyboard short cuts!
Video duration: 311 seconds
Global video hits: 488
Vertical Lookup (vlookup) functions are a part of every day business life. It is hard to imagine an invoice system, for example, that does not use some variation of =vlookup()
Watch as I demonstrate how to build your invoice using =vlookup()
I invite you to visit my website - http://thecompanyroc ks.com/excels to view all of my Excel Video Lessons.
Video duration: 363 seconds
Global video hits: 4846
I have tried to explain the following things. VLookup, HLookup, Average, Sum, Min and Max. Also how to move numbers from one cell to another by just typing = and then clicking on the relevant cell.
Video duration: 318 seconds
Global video hits: 979
See how to use a currency web query, and then link it to a data validation cell drop down list and a VLOOKUP formula that transforms a Balance Sheet from One Currency To Another.
VLOOKUP and Web Query and Data Validation
Formula and functions