This workshop is aimed at departmental/centre managers and other professional services staff who manage externally funded research grants.  

Members of the Research Division’s Research Awards team will demonstrate Excel tips and tricks they use, including pivot tables and VLOOKUP functions, to manipulate data exported from Statements4 and 5.  

Find out what examples of spreadsheets are used by centre managers to manage their budgets, expenditure, and HR commitments.  Come to learn how other professional services staff use Excel to meet their needs and share tips and tricks you have learned as well.

Presenters: Benjamin Nevius and Francis Manu