Menu

DATA ANALYTICS FOR BUSINESS PROFESSIONALS USING EXCEL/VBA

Code Cours
2324-IÉSEG-BA3S2-OPS-OPSB3-EE08UE
  1. Home
  2. ECTS Courses
  3. DATA ANALYTICS FOR BUSINESS PROFESSIONALS USING EXCEL/VBA
Establishment
IESEG School of Management
Language of instruction
English
Teaching content
OPERATIONS MANAGEMENT
This course occurs in the following program(s)
IESEG Degree - Programme Grande École - Crédits ECTS: 2.00
Training officer(s)
M.Reihaneh
Stakeholder(s)
Mohammad Reihaneh
Level
Bachelor
Program year
3
Period
S2

Présentation

Prerequisite
This course has no prerequisites
Goal
- Understand the importance of computer programming in decision making (AOL 5.D, 6.C)
- Automate repetitive/complex tasks using Excel VBA (AOL 3.A, 6.C)
- Understand the basic programming structures in VBA (conditional statements, loops, arrays, … )
- Work in a group project and tackle a complex problem using Excel/VBA (AOL 3.A, 3.B, 5.B, 6.C)
Presentation
- Review of some advanced Excel functionalities
- Excel macro recorder (absolute and relative macro recording)
- Referencing ranges, workbooks and worksheets
- Basic VBA programming structures (variables, conditional statements, loops, arrays, … )
- Working with files and folders
- Working with user forms (if time permits)

Modalités

Organization
Type Amount of time Comment
Présentiel
Cours interactif 16,00
Travail personnel
Charge de travail personnel indicative 10,00
Group Project 14,00
Autoformation
E-Learning 10,00
Overall student workload 50,00
Evaluation
Control type Duration Amount Weighting
Contrôle continu
Participation 0,00 0 15,00
Contrôle continu 0,00 0 15,00
Autres
Projet Collectif 0,00 1 70,00
TOTAL 100,00

Ressources