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

Excel - Interactive dashboards (EN)

e-kurz

Základní info

Popis kurzu

It is possible to create a very fashionable and interactive dashboard from contingency tables and graphs. You will welcome the dashboard if you process regular reports on a weekly or monthly level. Once you prepare the dashboard in the form of graphs and interactive graphical filters and then only update the source data.

Cíle kurzu

Creating and working with an interactive dashboard.

Určeno pro

To all Excel users.

Obsah kurzu

Creating a dashboard

data source preparation

contingency tables and graphs

insertion of interactive filters - cross sections and timeline

linking filters to selected PivotCharts

Předpoklady

Knowledge of Excel. We recommend that you first complete the course Introduction to Reporting or PivotTable and Advanced Reporting. However, this is not a condition.

Návaznosti

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