Excel Programming and Automation

Introduksjon

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.

Kursets innhold

• 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