After many months of work, and a lot of patience demonstrated by my beautiful wife, publishing company, and technical reviewer, the Excel 2013 Dashboard Design Video Course is finally published!
Excel 2013 Dashboard Design will show you how to turn your organization’s data into a powerful and interactive dashboard. By learning these easy-to-implement, advanced techniques, you can impress and empower the decision-makers in your organization, making you an irreplaceable asset.
Excel 2013 Dashboard Design begins by creating a vision for the dashboard with the help of stakeholders, and then moves on to gathering the data and building each element of the dashboard. The course ends with comparing distribution strategies appropriate for every size and type of organization.
By completing the course you will:
- Master the dashboard planning and design process by incorporating feedback from your audience, setting yourself up for success
- Import data from your SQL or Access Database, or another spreadsheet, so that you can utilize all the relevant data in your dashboard
- Implement PowerPivot as a flexible aggregation point for all your data, creating a bridge between Excel and your data sources
- Utilize PivotTables to aggregate, slice, and present data exactly how your audience needs to see it
- Deploy PivotCharts to effectively illustrate trends and metrics to your audience
- Stylize and enhance your dashboard with conditional formatting and SparkLines to quickly communicate KPIs to your stakeholders
- Add interactive features that put your audience in control of the data that they see, allowing them to drill down and focus on what is important to them
- Quickly create a sleek and powerful dashboard using the new Power View feature
- Explore the publishing options for your dashboard and deploy it using the most effective medium for your audience
Developing and recording the course has been a great experience for me, and, I hope, extremely valuable for anyone who takes it.
I certainly couldn’t have done this alone in a vacuum. I’d like to thank my parents, Marv and Joyce, for humoring and indulging my interest in computers from a young age, finance guru Trent Nevills for inspiring me with the possibilities and capabilities of Excel, and my beautiful wife, Sarah, for supporting my efforts and tolerating the long nights and weekends I spent locked in my office to record the series.
I’d love to hear your questions, comments, or feedback, so please feel free to get in touch.