Publisher's Synopsis
This book is a guide for anyone who wants to use Excel 2016 to make various diagrams. These are the diagrams that can be used to represent data in a visually appealing way and to make it easy for users to analyze and draw meaningful insights from the data. There are different ways through which this can be done in Excel, as there are different types it provides for this purpose. The kind of diagram or chart to use depends on the kind of data that you have, whether discrete or continuous. In this book, all diagrams provided by Excel 2016 have been discussed and you will know how to practically use them. You will also know the different situations in which you should use the different Excel charts. Formulas and functions are a good way of manipulating your data in an Excel spreadsheet. These have also been discussed in this book. The book also helps you know the various tips and tricks you should use when working on an Excel spreadsheet.
Here is a preview of what you'll learn:
- Creating a Bar Chart
- Creating a Column Chart
- Creating a Pie Chart
- Creating a Line Chart
- Creating a Treemap Chart
- Creating a Candlestick Stock Chart
- Creating a Waterfall Chart
- Creating a Pareto Chart
- Creating a Sunburst Chart
- Creating a Box and Whisker Chart
- Creating a Combination Chart
- Creating a Radar Chart
- Excel Formulas and Functions
- Excel Tips and Tricks
