Excel Pivot Tables in Köln - Seminar / Kurs von GFU Cyrus AG

Inhalte

This course is also forms day one of the course "Excel for Analysts".

  • Creating simple pivot tables
    • Row and column fields 
    • Calculated fields
  • Planning and creating pivot table layout
    • Rearranging fields
    • Adding or removing fields
    • Pivot reports
    • PivotTables
    • Short format
  • Show and hide results
    • Partial results
    • Summing rows and columns
  • Show and hide details
    • Hide elements
    • Grouping data 
    • Features of number and date fields
  • Excel functions for data analysis 
    • Value field properties
    • User-defined calculations
    • Calculating elements, fields and groups
  • Slicers
    • Creating data slices
  • Create and design PivotCharts
    • Create and edit charts based on
    • Print functions for PivotCharts
    • Save chart appearance as a separate template

This course is also forms day one of the course "Excel for Analysts".

  • Creating simple pivot tables
    • Row and column fields 
    • Calculated fields
  • Planning and creating pivot table layout
    • Rearranging fields ...
Mehr Informationen >>

Lernziele

To understand pivot tables, you need to work with them yourself. In this course we will create several pivot tables step by step from a set of sample data. With some experience, pivot tables can be created in minutes. After the seminar you will be able to analyse data in pivot tables.
To understand pivot tables, you need to work with them yourself. In this course we will create several pivot tables step by step from a set of sample data. With some experience, pivot tables can be cr ... Mehr Informationen >>

Zielgruppen

Participants: Individuals with a solid foundation and experience in Excel.

Termine und Orte

SG-Seminar-Nr.: 7118458

Anbieter-Seminar-Nr.: 3468

Termin

13.06.2025

Schulungszentrum der GFU Cyrus AG
Am Grauen Stein 27
51105 Köln

Günstige Preise

Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

€ 642,60

Alle Preise inkl. 19% MwSt.

Jetzt buchen ›
Seminar merken ›

Der Anbieter ist für den Inhalt verantwortlich.

Veranstaltungsinformation

  • Seminar / Kurs
  • Deutsch
    • Zertifikat
  • 7 h
  •  
  • Anbieterbewertung (125)

Ihre Vorteile mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service