In this workshop we will 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 or workbooks
- Preparation for print-out
- Settings and security
- Charts
Instructor
- Sven Froese , External lecturer
