image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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 this course is for:
If you currently build or wish to build dashboards in Excel

What you'll learn

Rapidly build interactive dashboards which are robust and easy to update

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
5
1.1-Introduction
1.2-20 Minute Dashboard - No Formula Required
1.3-Structure Like a Software Developer
1.4-Tidy Data
1.5-Tables - Essential Step
2-Get & Transform
4
2.1-Automate Refresh with Power Query
2.2-Merging Data an Alternative to VLookups or DB Joins
2.3-Merge a Folder of Files
2.4-Transforming Pivot Data
3-Modelling
5
3.1-Input Driver Sheet with Named Ranges
3.2-Compensation Cost Modelling Intro
3.3-Power Query vs Worksheet Calculations
3.4-Driver Based Model
3.5-What If Analysis - Goal Seek, Solver, Scenario Manager
4-New Visualisations
2
4.1-Excel Treemaps and Sunbursts vs Power BI
4.2-3D Maps
5-Conclusion and Extra Resources
3
5.1-How to Reach the Next Level
5.2-Bonus: Move to the Next Level with a 95% OFF Discount
5.3-Vlookup vs Power Query vs DB Joins vs OLAP vs R