Prague, Czech Republic
Sustainability and Circular Economy
When:
21 July - 01 August 2025
Credits:
5.0 EC
Read more
Business & Entrepreneurship
When:
24 June - 12 July 2024
School:
Institution:
BI Norwegian Business School
City:
Country:
Language:
English
Credits:
7.5 EC
Fee:
12500 NOK
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.
Adam Lee
Bachelor students
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
12500 NOK, Course fee for Fee-paying students from outside EU/EEA/Switzerland (Fee-paying students from inside the EU/EEA/Switzerland pay 9800 NOK)
When:
24 June - 12 July 2024
School:
Institution:
BI Norwegian Business School
Language:
English
Credits:
7.5 EC
Prague, Czech Republic
When:
21 July - 01 August 2025
Credits:
5.0 EC
Read more
Le Havre, France
When:
27 June - 10 July 2025
Credits:
6 EC
Read more
Copenhagen, Denmark
When:
23 June - 25 July 2025
Credits:
7.5 EC
Read more