Advanced Formulae and Functions using Excel – Lecture
Are you needing to use more complex formulae and inbuilt functions in Excel as part of your research?
Excel has many standard functions which can greatly enhance data analysis. These include commonly used financial, statistical and text functions. Formulae can operate across worksheets and can use named ranges to make it easy for users to understand the spreadsheet logic.
This lecture style demonstration is aimed primarily at HDR candidates who wish to use more complex formulae and inbuilt functions in Excel as part of their research. This session is not a hands-on workshop, and rather aims to provide a demonstration of key features in a lecture style format.
|Target Audience||All Postgraduate Research Students|
|CaRST Credit||1 hour|
|Domain||A: Knowledge and Intellectual Abilities|
|Mode of Delivery||Face to Face|
|Pre-requisites||An understanding of basic navigation and simple formulae in Excel is assumed.|
|Resources||Previous webinars available online|
|Evidence of Completion||Attendance will be recorded online in the University Course Bookings system. A sign-in sheet will be available at the lecture.|
or 8313 1000
|Dates||29 May 2017|
|Booking||Through the University Course Bookings system.|