Microsoft Excel 2013 (Structure)


Booking


Seminar Objective

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

Seminar Content

  • 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

Participants

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


Booking


Customer rating of this seminar

4,6 (11 Bewertungen)

Information on seminar ratings

Information on seminar ratings

Origin of the seminar ratings

The evaluations of our seminars, trainings and workshops are given by the training participants of the Management Institute Dr. A. Kitzmann. After each training event, participants provide written feedback by means of a questionnaire. The testimonials given on our website are also taken from these questionnaires.

Calculation of seminar assessments

The total of eight evaluation criteria, which are collected by means of a questionnaire, result in the overall evaluation calculated on a pro rata basis.

Video zum Seminarthema Microsoft Excel 2013 (Structure) auf YouTube

Video about the seminar topic

Further videos on current topics can be found on our YouTube-Channel.


Participants

not more than 9 participants

Schedule

1. Day: 09:00 - 17:00
2. Day: 09:00 - 17:00

Location and Dates

by agreement

Fee

on request

Included in the price: Working documents, certificate of participation, lunch and coffee breaks.

Course Ref.

IT7791-13

Language of Training

German


Further Seminars

Microsoft PowerPoint 2013 (Structure)

Presentation training

Microsoft Excel 2013 (Structure)

Seminar Objective

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

Seminar Content

  • 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

Participants

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

Participants

not more than 9 participants

Schedule

1. Day: 09:00 - 17:00
2. Day: 09:00 - 17:00

Location and Dates

by agreement

Fee

on request

Included in the price: Working documents, certificate of participation, lunch and coffee breaks.

Course Ref.

IT7791-13

Language of Training

German


Further Seminars

Microsoft PowerPoint 2013 (Structure)

Presentation training

Let us advise you - we are always there for you! +49 251 202050