Course contents and learning objectives
This is a hands-on Excel course that will help you acquire practical skills useful for your professional career. The course was designed with a limited amount of theoretical notions, and will have a focus on practical “real life” exercices.
The course will cover the following macro topics, and will be tailored in accordance with the level of participants:
- Review of basic Excel concepts, best practices for using formulas (coding convention), use of variables, table editing, Pivot table, Pivot Charts, best practice for presenting data
- Data modelling in Excel: introduction to Power Query Editor, connection to different data sources (e.g. databases and online sources), #M language for data modeling, process automation using Power Query (threats and opportunities), introduction to Entity-relationship model, usage of Data Model feature
- Advanced Pivot table: introduction to Power Pivot feature, creation of custom calculated fields in Pivot Table using Data Analysis Expression formulas (DAX) in a data model context
- Introduction to macros, macros recording and usage of VBA in Excel
- Excel Cloud, new features, scripting and integration with Power Automate for scheduled processes
- Depending on the level of participants, specific topics could be addressed at the end of the course.
Practical information
- Language: English
- Time: 18.30 – 20.15
- Dates: 26.2, 4.3, 11.3, 18.3, 25.3, 8.4, 15.4 – The course will take place on Mondays, starting on February 26th 2024 and ending on April 15th 2024.
In case of questions, please contact branislava.trifkovic@usi.ch