MS Office Excel Training - Creation of Dashboards in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
350.-/d
ID : 1191
Goal : Learn to create dynamic, interactive and user-friendly reports and dashboards within the limits of the possibilities of the tools made available in Microsoft Excel in order to manage and track activities.
Audience : This training is aimed at heads of departments or companies who already have an excellent level of training (minimum university Master's degree).
Prerequisites : The attendee must have at least a basic knowledge of statistics (bachelor level) and have followed the trainings on pivot tables, macros and conditional formatting, the use of the analysis toolpack, charts, PowerPivot and Power Query or have equivalent knowledge.
Goals :
- Introduction
- Explanation of the limitations of Microsoft Excel compared to specialized software (Tableau, QlickSense, Power BI, R Shiny, Dash, etc.)
- Reminders on the 550 statistical indicators
- Reminders on the 180 chart types
- Data preparation (ie Data Munging/Data Mashup)
- Preparing and using color themes
- Visual preparation and sheet protection
- Add emoticons to sheet names
- Creation of navigation buttons with hyperlinks
- Creation of elaborate interactive graphics
- Interactions of charts with form controls
- Creation of elaborated KPIs with formulas
- Creation of elaborated KPI with conditional formatting
- Using slicers with tables and pivot tables
- Using Sparklines with pivot tables
- Using the GETPIVOTDATA function of Pivot Tables or the Cube functions of Power Pivot
- Removing the ribbon with a macro
- Conclusion
Pedagogical method : This training is based on examples imposed by the trainer and consists of 90% practice and 10% theory.
Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4
Daily price in face-to-face : 350 CHF
Daily price in remote : 168 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 1750 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Book
- Title : Excel Dashboards and Reports
- Author(s) : John Walkenbach,Michael Alexander
- Pages : 432
- ISBN : 9781118490426
Tags : dashboard, dashboards, excel dashboard training, excel dashboard training, excel report creation, dashboard.