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 pr-requisites.

Course leader

Adam Lee

Target group

Bachelor students

Course aim

Learning outcomes

Knowledge
Upon completion of the course the student shall be able to:

understand, explain and use advanced spreadsheet concepts, including:

- programmatic cell and sheet manipulation, macros, Excel objects, user interface,

understand and explain general programming concepts:

- syntax and semantics, variables, control flow, procedures/functions

with focus on data processing in Excel.

Learning outcomes - Skills
Upon completion of the course the student shall be able to:

- design, implement, run, test and debug code in Excel based on a given textual description of a problem,

- process, analyze, summarize and visualize datasets using programming in Excel,

- read and understand Excel code/macros,

- automate workflows in Excel using programming,

- design custom user interfaces in Excel.

Fee info