• hd-ph
    • Beratung

      Sie haben Fragen zu den
      Seminaren oder benötigen
      Hilfe bei der Buchung?

      Rufen Sie uns an unter:

      +43 1 97000 100

  • newa
  • catalog
    • Inhouse-Akademie

      Gerne erstellen wir maßgeschneiderte Inhouse-Seminare für Sie – ganz nach Ihren Wünschen!

      >> Mehr erfahren & anfragen

Excel basics course

Excel basics course

Bilanz und Jahresabschluss

Bilanz und Jahresabschluss

Excel advanced course

| In-house seminar

Save time & work more efficiently

Auf Lager
SKU
146546ie

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.

Weitere Informationen
Duration

Seminar concept developed individually for you, based on your needs.

Farbe der KategorieORANGE - Finance-Controlling
ReferentenAndreas Reinisch
KontaktpersonKontaktperson 1+2
Schreiben Sie eine Bewertung
Sie bewerten:Excel advanced course
Ihre Bewertung

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

Andreas Reinisch
 Andreas Reinisch
 

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.

 

Ihre Ansprechpartnerin

Bitte füllen Sie für alle Teilnehmer die nötigen Daten aus, um zur Kasse fortfahren zu können.