Excel Programming and Automation

About

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

Course leader

Adam Lee

Target group

This course is mainly for students enrolled in a undergraduate programme

Course aim

Using available data to gain insights and make correct decisions is becoming essential for almost any business in today's world. Spreadsheets are one of the most used tools for processing tabular data and gaining insights. In this course, we will focus on advanced use of Excel, including programming and automation

Fee info