This course focuses on how to take advantage of Excel’s programming and automation functionalities, with no prior knowledge or experience necessary. It will give you a competitive edge when using Excel in both your further studies and career. The course focuses on advanced usage of Excel, with a particular emphasis on writing user – defined functions and (typescript) code to program and automate workbooks (Microsoft has recently announced the ability to use Python in Excel – this is not currently generally available, but will be incorporated into the course if and when it becomes so). In addition to learning how to leverage these powerful tools to increase your proficiency & productivity with Excel, you will also benefit from an introduction to basic programming concepts – illustrated by their application to data processing in Excel.
Students are required to have access to their own computers with access to Excel on the web (i.e. via an Office 365 subscription). The course is open for students from all disciplines and has no prerequisites.