Microsoft Excel 2013 (Advanced)

Request now

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.