-
Tuesday, 21 November 2017
2:00 pm - 2:30 pm - LX.lab CB06.04.020
Save time with VLOOKUP in Excel
VLOOKUP is widely used in Microsoft Excel to help join data from separate sources – to find things in a table or a range by row. It is a time-saving function that Academics will find useful whenever they need to manage and extract data from spreadsheets, and it is not actually that hard to master once you understand how it works. For example, it can simplify the process of transferring grades to the SLS.
“VLOOKUP is one of the most popular lookup reference functions in Excel. And basically, it just allows you to join data from separate sources using a common lookup value….” Building a Dynamic Heat Map in Excel – Lynda.com*
Sunil Manandhar from the Teaching Technologies, Innovation and Support Unit (TTISU) in the Faculty of Arts and Social Sciences (FASS) will demonstrate how VLOOKUP it works. Attendees should bring their own laptop with Microsoft Excel on it.
*UTS Staff can freely access Excel training online through Lynda.com where a variety of topics on Excel are covered including VLOOKUP.
[button link=”#booking” color=”silver”]Book this event[/button]
Run a Tooltime session
Tooltime is a bite-sized event open to all UTS staff. Demo a gadget, tool, app, workflow or approach. Snack on nifty techniques for crafty stuff in learning and teaching. Spread the word!
[button link=”https://docs.google.com/forms/d/e/1FAIpQLSdBXm7OIu5hLH5FizA-RAsKBa0Oqoe1_SCOt_DLMvMG9bzBJQ/viewform?c=0&w=1″ type=”icon” icon=”mail”]Submit your proposal[/button]
Register for this event
Your video, audio and the meeting chat transcript may be recorded or photographed. Please advise the facilitator if you do not wish to be recorded or photographed.
To register your attendance, please log in to LX.