full screen background image

Online courses

CLICK ON IMAGE GREATE TENNIS INSTRUCTION!!!!

FOR RUNNERS CLICK ON IMAGE GREAT COURSES

Excel Tip #2 Workout Log Database with =VLOOKUP and Tables

Excel Tip #2 Workout Log Database with =VLOOKUP and Tables

(0:05) The Question
(0:20) Tables and Unique identifiers
(1:11) Making raw data into table with hotkeys
(1:22) Naming the table with hotkeys
(1:34) Table New Entry Absorption
(1:52) Filtering Table Data
(2:44) Search Tab in workbook
(3:10) =VLOOKUP for data pulling
(4:20) Filling out reference cells for data pulling
(4:45) Goal accomplished
(6:04) Sheet navigation tip
(6:43) NAME YOUR TABLES
(7:03) Outro

►TUMBLR: http://excelismagic.tumblr.com/
►ETSY: https://www.etsy.com/shop/norsemancrafts
►INSTAGRAM: https://www.instagram.com/excel.is.magic/
►FACEBOOK: https://www.facebook.com/groups/ExcelIsMagic
Video Rating: / 5




Leave a Reply

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