Excerpt from course description
- English
- ELE 3915
- 7.5 Credits
Introduction
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.
Course content
Introduction to Excel
- user defined functions in the workbook
- PivotTables & Charting
typescript:
- variables, data types and structures
- control flow (conditional execution, loops)
- functions
- object - oriented programming
- organising code
ExcelScript:
- recording and executing Excel scripts
- excel objects & the ExcelScript API
Disclaimer
This is an excerpt from the complete course description for the course. If you are an active student at BI, you can find the complete course descriptions with information on eg. learning goals, learning process, curriculum and exam at portal.bi.no. We reserve the right to make changes to this description.