Excel advanced course
| In-house seminar
Save time & work more efficiently
On average, employees spend around 7 hours per week working with Excel. That's about 360 hours per year. If you worked just 20 % more efficiently with Excel, you would have almost two whole working weeks a year available for other tasks!
Find out which functions, formulas, and data analyses will make your working life much easier. With our course, you can become an Excel Pro and gain valuable working time for other tasks.
| Duration | Seminar concept developed individually for you, based on your needs. |
|---|---|
| Farbe der Kategorie | ORANGE - Finance-Controlling |
| Referenten | Andreas Reinisch |
| Kontaktperson | Kontaktperson 1+2 |
On average, employees spend around 7 hours per week working with Excel. That's about 360 hours per year. If you worked just 20 % more efficiently with Excel, you would have almost two whole working weeks a year available for other tasks!
Find out which functions, formulas, and data analyses will make your working life much easier. With our course, you can become an Excel Pro and gain valuable working time for other tasks.
Ihr Nutzen
- You will learn how to use Excel more efficiently, and how to make better use of the program's automation potential. With your advanced Excel skills, you can speed up numerous work steps!
- You will have the opportunity to ask questions and get answers directly from a professional.
- Numerous practical exercises will enable you to make significant progress with Excel in a short period of time!
Zielgruppe
All employees who want to take their Excel skills to the next level and increase their overall productivity at work.
Please note: This training is aimed at anyone who already works with Excel and understands the basics. For a refresher on the basics, we recommend our "Excel basics course" training.
Seminarinhalte
Advanced formatting
- User-defined number formats
- Conditional formatting
- Database functions
- Practical exercises
REFERENCE functions
- S-REFERENCE
- Define lookup value
- Range specification
- Approximate and exact match
- Practical exercises
Analyzing and evaluating data
- Target value search
- Scenario Manager
- Consolidate data
- Auto filters and special filters
- Recording macros
- Practical exercises
Pivot tables
- The basics
- Consolidation
- Practical exercises
Tip: With in-house seminars, you have the opportunity to choose the content and duration yourself and adapt them to the needs of your company.
Referenten
Tätigkeit
Andreas Reinisch ist Programmierer und IT-Trainer bei datensatz.at. Er führt zahlreiche Schulungen vor allem im Businessbereich durch und ist spezialisiert auf Datenbank- und Webprogrammierung. Als selbstständiger Trainer und Softwareentwickler ist er seit 1990 in der Erwachsenenbildung tätig und seit 2001 Entwickler von Datenbanken und maßgeschneiderten Office Tools.
