Excel (intermediate/advanced)

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