Master of Public Policy   Master of International Affairs  

Excel basic

In this workshop we deal with the basic functions and possibilities of table calculation. You will learn how to transfer your mathematical tasks into Excel and how to structure, calculate and change the appearance of tables.

This class is for people who want to structure their work, make it less time-consuming and learn more about the possibilities of Excel. It is suitable for those with no or intermediate experience in Excel.

The topics include:

  • Entering and editing data
  • Formatting data
  • Calculation with formulas and functions
  • Shortcuts
  • Application of named areas
  • Sorting and filtering
  • Logical functions (e.g. if)
  • Working in parallel on multiple sheets
  • Linking sheets and workbooks
  • Preparation for printout
  • Settings and security
  • Charts