Master of Public Policy   Master of International Affairs   Master of Data Science for Public Policy  

Excel advanced

In this workshop, we’ll explore the advanced functions and possibilities of Excel table calculation. We will look into what is required for working with large amounts of data and its automatic processing. During the weekend the topics of the basic workshop will be partly repeated and looked into in more detail.

You will have the opportunity to bring examples/problems from your practical work with Excel to be solved with the tools we’ll develop during the class.

This class is for people who need to process larger amounts of data and who want to increase their skills in Excel above average.

The topics include:

  • Transforming data into database format
  • Fixing columns of data
  • Data consolidation  
  • Pivot tables
  • Advanced formulas
  • Preparing templates and limiting tables for other users
  • A short introduction to macros (not VBA programming)