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

Excel - Advanced reporting (EN)

Kurzem Vás provede 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…

Základní info

Popis kurzu

PivotTables are basically a very effective tool, and yet they contain many secret features. We will introduce you to these functions during the training.

PivotTables are basically a very effective tool, and yet they contain many secret features. 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


  • Power Query - transformation of source data

  • Advanced reporting features

Určeno pro

To all Excel users.

Obsah kurzu

Power Query - transformation of source data

  • consolidation of multiple tables into one

  • remove blank lines

  • remove duplicates

  • flip rows to columns


Advanced reporting features


  • calculated field

  • percentage expression - values as

  • function GETCONTDATA - GETPIVOTDATA

  • grouping of calendar data, numbers and texts

  • conditional formatting

Předpoklady

Knowledge of Excel. We recommend that you first complete the Excel course - Introduction to Reporting or PivotTable. It is not a condition.

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

Excel - Advanced reporting (EN)

Vybraný termín:

14.9.2021  Online

Cena
900 Kč + 21 % DPH

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je čtyři a sedm ? Součet zapište číslicemi.