Excel Lookups: Power Bite
Short session on this useful Excel feature
Lookups are functions which allow a given value to be looked up from within a table and an alternative column to be returned from that table. It can also return the closest match to the value being looked up so that each row in the table can represent ranges of values. Benefits are enhanced presentation and tables of valued don't need to be repeated throughout the spreadsheet. This significantly reduces data maintenance issues.
- Tuesday, February 20, 2018
- 12:30 - 13:30
- Library Teaching Room, Edinburgh Campus Library
- Edinburgh Campus