In this workshop we explore the advanced functions and possibilities of Excel table calculation. We 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 and problems from your practical work with Excel to work on during class. This class is for people who need to process larger amounts of data and who want to increase their skills in Excel to above average. The course covers:
- transforming data into database format
- fixing columns of data
- data consolidation
- pivot tables
- advanced formulas
- preparing and limiting tables for other users
- a short introduction into macros (not programming)
This course is for first year MIA and MPP students only.