Microsoft Excel Advanced Seminar (Level III)

One-day training in Microsoft Excel for advanced users. Advanced basic knowledge is consolidated and expanded. The aim is to use Microsoft Excel to implement complex mathematical calculations and their visualization. Data analysis with pivot tables is also covered in detail. After this Microsoft Excel Advanced training, you will have deepened your knowledge to the point where you can confidently carry out complex mathematical calculations and visualize them using Microsoft Excel. Data analysis using pivot tables will also no longer be a challenge for you. The Microsoft Excel advanced training is just right for you if you already have advanced knowledge of Microsoft Excel. You can also create complicated and nested functions. If you have already attended our Microsoft Excel training Level II for deep basic knowledge, you are ideally prepared for this next step.

You can also book this seminar as a company seminar

Excel Aufbau Seminar Content

1. „Never trust a view in Excel“

  • Deeper, custom number formatting
  • Working with placeholders
2. Structuring and evaluating tables
  • Rules for structured lists
  • INDEX() and MATCH() as an alternative to VLOOKUP()
3. Work faster with dynamic tables
  • Automatic extensibility, formatting
  • Structured references
  • Automatic result row
4. New Excel 365 features
  • Array functions: UNIQUE(), FILTER(), #, SORT()
5. Pivot tables: evaluating tables without functions
  • Principle and functionality of pivot tables
  • Creating simple pivot tables
  • Report layouts, partial and total results
  • Drilldowns
  • Practical tips

6. Visualization with pivot charts

  • Tips for organizing evaluations
  • Create simple but sustainable evaluation models

There will be tips and tricks for all topics to make working with Excel even faster and more fun.


Advanced basic knowledge of Excel


1 day (9:00 – 16:00)

Seminar location



390 € plus VAT

Start dates of the next seminars in Hamburg

Do you have any questions or would you like a detailed, personal consultation?

We are happy to help you. Call us on +49 40 80 79 36 111 or send us an e-mail.

I would like to be contacted


Datum Ticket Preis Menge
Excel Level III English 390,00€ Ausverkauft