MS Excel 2016 Charts & Basics of Dashboards: The Essentials of Excel 2016 Charts and Simple Steps to Create a Dashboard

Developed for Microsoft® Excel 2016

Are you looking to learn the new charts in MS Excel 2016 and want to know how to create a dashboard in simple steps? What if you could finally learn all the different types of Excel charts and select the right type of charts to convey the right information? What if you could share the information that matters periodically through a dashboard with your team and management and keep them up to date?

It’s annoying to have all the data in hand but not to know how to convert it into information. That’s why I created this book MS Excel 2016 Charts & Basics of Dashboards.

Learn the most useful Excel 2016 charts and how each can be used to interpret the data. Visualize the impact of financial transactions effectively using Waterfall Charts. Look at various categories of data in a single shot using Treemap Charts. Analyze the hierarchical data using Sunburst Charts. See the distribution of data using Histograms. Bring out what matters most using Pareto Charts. Briefly, refresh on the fundamental yet powerful charts like Pie, Bar, Column, and Line. Take help from Combination charts to see how your project/organization is doing by plotting target vs. actuals and take control of your project.

Finally, learn how to bring all the necessary information that matters into a single place using Dashboards.