Easy Excel Dashboards, Models, Visualizations & Power Query

Easy Excel Dashboards, Models, Visualizations & Power Query

image description

What you will learn

Rapidly build interactive dashboards which are robust and easy to update


Section 1: Introduction

Section 2: Get & Transform

Section 3: Modelling

Section 4: New Visualisations

Section 5: Conclusion and Extra Resources

Course Description

Rapidly build robust dashboards in Excel by following a simple step by step process that requires no formulas. Beginners can get started easily due the lack of formulas. Advanced users will learn to structure their dashboards like software developers so that they become more automated with no additional work. Not many people are aware how much can be done with no or very few formulas in Excel. This not only makes the design simpler it also makes it more robust, reduces risk and improve performance. Jonathan trained as a Microsoft Certified Trainer and has used advanced Excel for over a decade. Who is the target audience? If you currently build or wish to build dashboards in Excel