DATA ANALYTICS FOR BUSINESS PROFESSIONALS USING EXCEL/VBA
Année du cours : 3 année(s)
Etablissement : IÉSEG School of Management
Langue : English
Formation(s) dans laquelle/lesquelles le cours apparait :
Période : S2
This course has no prerequisites
– 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)
– 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)
