Overview
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
- | Author: Dan N.
- | Publisher: CreateSpace Independent Publishing Platform
- | Publication Date: May 22, 2018
- | Number of Pages: 86 pages
- | Language: English
- | Binding: Paperback
- | ISBN-10: 1719181179
- | ISBN-13: 9781719181174
