In this workshop, we will 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 will 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
short introduction into macros (not VBA programming)
Instructor
- Sven Froese , External lecturer