Excel - Introduction to reporting with contingency table (EN)

  • E-KURZ
Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde

  • Lektor

  • Popis
    Microsoft Office Specialist - The lecturers have over 10 years of experience in leading training and belong to the core team of MS Office. In addition to Office, HTML and Adobe training, they also create websites, templates, graphic designs and more. They always adapt each training to the customer's needs. Customers are often sought after for their distinctive style and professional approach.

    Certification holders:
    • Microsoft Certified Trainer
    • Microsoft Office Specialist
    • Microsoft Office Expert

  • Místo konání

  • Region:
    ONLINE
  • Adresa:

  • Termín

Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde

Popis e-kurzu Excel - Introduction to reporting with contingency table (EN)

Popis kurzu

Are you tired of constantly filtering data in tables? At the training, you will learn to work with a PivotTable.

You can create your own calculations in the PivotTable using calculation fields. Do you calculate the percentage expression? There is nothing easier than calculating percentages directly in the report using the built-in tool. For better telling ability, visualization can be delivered using conditional formatting.



Before creating a PivotTable, many users spend time editing the source data — joining multiple files together with the FIND function, removing duplicates and blank rows, or rewinding rows to columns to get the database form of the table. With Power Query, you can prepare the perfect data source for your PivotTable in almost one click.

Cíle kurzu


  • Know and edit data sources for PivotTables.

  • Create, set up, and modify a PivotTable.

  • Creating and editing a PivotChart.

Určeno pro

To all Excel users.

Obsah kurzu

Data source for PivotTables

  • basic rules for a data source


PivotTable


  • explanation of building a PivotTable model

  • setting aggregation functions

  • report filtering

  • graphic filters - cross sections & timelines


Pivot chart


  • creating a chart

  • chart adjustment

Předpoklady

Knowledge of Excel at a basic level.

Návaznosti

Excel - Advanced reporting, Excel - Interactive dashboards, Excel macros - Easy uploading, Excel: macros - Don't be afraid of code or an introduction to understanding VBA
Bližší popis na stránkách dodavatele
Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde
Spustit e-kurz