Categories Pricing Corporate
Professional eBook

Excel 365 Charts

Graphical Representation of Figures

0 Reviews
63
Language:  English
In this ebook you learn as an end user of Excel 365 how to design clarifying and beautiful formatted charts, predictive trendlines, and insightful sparklines from your numerical data.
Professional Plus subscription free for the first 30 days, then $8.99/mo
Access to this title on the bookboon platform
Description
Content

‘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.

  • About the author
  1. Introduction
    1. Structure
    2. Format
    3. Software
  2. Charts
    1. Introduction
    2. Creating a chart
    3. Updating
  3. Formatting charts
    1. Introduction
    2. Format
    3. Customizing
    4. Formatting risks
    5. Axes
    6. Tips
  4. Chart templates
    1. Introduction
    2. Creating a template
    3. Applying a template
    4. Exercise
  5. Combined charts
    1. Introduction
    2. Series
    3. Strange images
    4. Formatting
  6. Trendlines
    1. Introduction
    2. Discover trends
    3. Predictions
    4. Exercises
  7. Sparklines
    1. Introduction
    2. Dependency
    3. Data table
    4. Special formatting
    5. Other sparks
    6. Exercise
  • Appendix

About the Authors

Walter Jaburek

Janine du Plessis

Christian

Christian Julmi

Erik

Erik Bruun

Kari

Kari Lise Barstad

David

David Shindler

Yuri Yevdokimov

Matthias

Matthias Kohl

Christopher

Christopher J. Skousen

Hubert Jaoui