Microsoft Excel 2013 (Advanced)

Microsoft Excel 2013 (Advanced)

The aim of this course is to introduce and implement the extended MS Excel functions and add-on modules relating to MS Excel 2013.

  • Database construction and data recording
  • Database maintenance
  • Search and sort functions​​​​​​​
  • Filtering, selecting and extracting​​​​​​​
  • MS Query introduction​​​​​​​
  • Database functions/filter functions​​​​​​​
  • Partial results and consolidation functions​​​​​​​
  • Creating pivot tables​​​​​​​
  • Editing pivot tables​​​​​​​
  • Creating diagrams from a pivot table
  • Linking worksheets and workbooks​​​​​​​
  • Working with complex functions​​​​​​​
  • Creation of sample templates​​​​​​​
  • Methods of data analysis
  • Data exchange with other applications, data import and export​​​​​​​
  • Structuring tables
  • Excel workbooks on the Web​​​​​​​
  • Advanced charting​​​​​​​
  • Scenario Manager​​​​​​​
  • Target value search
  • ​​​​​​​Multiple operations, matrix formulas
  • Easy macro creation with the macro recorder
Target audience

This seminar is aimed at people who want to expand their basic knowledge of MS Excel in order to use the product more effectively.

Price auf Anfrage
Save and share
Dates
By agreement
Benefits
  • Strong practical relevance
  • The seminar is guaranteed
  • Seminar provider since 1975
  • Hygiene concept
Course ref.
IT7791-13
Schedule
  • 1. Day: 09:00 - 17:00
  • 2. Day: 09:00 - 17:00
Seminar language
German
Number of participants
not more than 9 participants
Further seminars

Inhouse
We would be happy to conduct all of our open seminars for you in an adapted form as an in-house seminar.