Particularly when different Office programs interact, difficulties often arise because certain options for linking Office documents from the different programs are hardly known and are therefore not or only insufficiently used. This course aims to close this gap.

This is where the Office Practice course comes in:

Course content in detail:

WORD:

• Designing letters and emails
• Sending mail merge documents in print or by e-mail to many recipients,
  Using EXCEL or ACCESS as a data source for recipient addresses
• EXCEL charts in WORD
• Designing forms

EXCEL:

• Insert tables (sections) and diagrams into WORD documents - with dynamic linking (changes to EXCEL content are shown immediately in WORD)
• Display and process ACCESS databases or data extracts (with MS QUERY) in EXCEL (consolidation, pivot table)
• Data source for WORD documents (see above),
  Use of filter and sorting functions for data preparation
• Display ACCESS data using EXCEL charts

POWERPOINT:

• Display WORD, EXCEL or ACCESS content in presentations - with dynamic linking (changes to content in the original file are shown immediately in PPT)
• Export presentations to WORD for further design, e.g. for handouts
• EXCEL diagrams in POWERPOINT

ACCESS:

• Create queries and reports from ACCESS data and export them to WORD, e.g. to design catalogs or overviews

• Data source for WORD documents (see above),
  Use of filters and queries for data selection

  The list of topics can be adapted or supplemented according to the wishes of the participants with regard to practical use cases

  You can take this course as training time in accordance with the Baden-Württemberg Training Time Act.