‘A picture is worth a thousand words’, or in this case: ‘…a thousand numbers’. It is not quite easy to draw conclusions from a large number of figures in a worksheet. Charts representing the numbers give a lot more insight and overview. In this user guide you learn how to design comprehensible charts in Excel 365, which (combined) types you can choose from, and how to add the required captions. Further, this ebook discusses how to discover trends in your figures by drawing trendlines or sparklines. By using charts your models and figures can get more predictive power.
páginaprincipal.livro.e-book_profissional
Excel 365 Charts
Graphical Representation of Figures
Descrição
Conteúdos
- About the author
- Introduction
- Structure
- Format
- Software
- Charts
- Introduction
- Creating a chart
- Updating
- Formatting charts
- Introduction
- Format
- Customizing
- Formatting risks
- Axes
- Tips
- Chart templates
- Introduction
- Creating a template
- Applying a template
- Exercise
- Combined charts
- Introduction
- Series
- Strange images
- Formatting
- Trendlines
- Introduction
- Discover trends
- Predictions
- Exercises
- Sparklines
- Introduction
- Dependency
- Data table
- Special formatting
- Other sparks
- Exercise
- Appendix
