Unser Kursangebot - auch online

Office-Grundlagen und Workshops

Microsoft Word Icon

Word

Microsoft Excel Icon

Excel

Microsoft PowerPoint Icon

PowerPoint

Klicken Sie auf ein Icon für weitere Informationen.

Unser Kursangebot - auch online

Gemeinsames Arbeiten

Microsoft Outlook Icon

Outlook

OneNote

Teams Logo

Teams

Klicken Sie auf ein Icon für weitere Informationen.

Unser Kursangebot - auch online

Datenbanken und Visualisierung

Microsoft Access Icon

Access

Microsoft Project Icon

Project

Microsoft Visio Icon

Visio

Klicken Sie auf ein Icon für weitere Informationen.

Loading Events

« All Events

Event Series: Excel Pivot Basics

Excel Pivot Basics

Thu. 5. March 2026, 13:15 - 16:30

- 290 EUR plus VAT
Duration: 3 hours
Target group: Excel users
Objective: Create data lists and analyze, prepare and summarize them with pivot tables
Previous knowledge: Good basic knowledge of Excel
Content: To get started

  • Cell references (relative and absolute)
  • Format as table
  • Document management (for Office 365 users)

Data lists

  • Filtering and sorting lists
  • Partial results

Pivot tables

  • Structure of a pivot table
  • Create Pivot Tables
  • Update data
  • Marking in a pivot table
  • Add fields
  • Add calculated fields
  • Change the arrangement of the fields
  • Group data
  • Show and hide detailed data

Our experienced trainers will explain Microsoft Excel data lists and pivot tables to you in an understandable way. Expand your knowledge of Microsoft Excel and use advanced techniques to prepare your data for complex tasks. You will learn to process, analyze, prepare and summarize large amounts of data in Excel.

to the course registration

Details

Venue

Organizer

Details

Venue

Organizer

© Copyright - Ontaris GmbH & Co. KG