Excel advanced course

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.