20 Minute Dashboard - No Formula Required

How to build a Dynamic Excel Dashboard for data analytics in Excel 2016 using Power Query (aka Get and Transform) and Pivot Tables. No VBA Required. Although there are many advanced Excel formulas and techniques that can be used to create interactive dashboards, complex dashboards can be much more difficult to setup and maintain. The structure of these dashboards are designed to be easily accessible and allows you to focus on rapidly conducting Excel analytics rather than spending a lot of time using formulas to connect all the pieces of a dashboard together. In this tutorial we will focus on the power of pivot table charts which are more dynamic than regular Excel Charts and Excel graphs.