MS Excel - Spreadsheet calculation for advanced users

The Excel advanced course, which is aimed at students who have mastered the basic functions in MS Excel, provides you with the knowledge to further prepare and analyse large amounts of data and complex relationships. Practical examples are used to practise and consolidate what you have learned.

Contents:

- Advanced formulas and functions

- Logical evaluations and reference functions, conditional formatting

- Calculating with dates and times

- Special filters and sorting data

- Database functions

- Outlines and partial results

- Consolidating tables

- Analysis methods, e.g. target value search and solver search

- Analysing data

.e.g. target value search and solver

- Creating and using scenarios

- Creating and editing pivot tables and chart reports

Registration is required at:

https://blogs.hrz.tu-freiberg.de/careercenterclub/de/semesterprogramm/

The number of participants is limited. A protection and expense fee will be charged for the seminar.