Excel 2019 Charts

Graphical Representation of Figures

Commentaires:
( 0 )
63 pages
Langue:
 English
In this ebook you learn as an end user of Excel 2019 how to design clarifying and beautiful formatted charts, predictive trendlines, and insightful sparklines from your numerical data.
Ceci est un livre pro
Abonnement pro gratuit les 30 premiers jours, puis $5.99/mois
 
Lisez ce livre avec notre eReader, sans pubs
Dernières publications
A propos de l'auteur

Peter Scharpff is oorspronkelijk afkomstig uit de computer-linguïstische hoek. Zijn wetenschappelijke focus lag op de interactie tussen mens en machine, vooral op de spraak- en taaltechnische kant daarvan. Behalve het ontwikkelen van materiaal voor trainingsdoeleinden op het gebied van kantoorautomati...

Description
Contenu

‘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 2019, 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. Exercise
  7. Sparklines
    1. Introduction
    2. Dependency
    3. Data table
    4. Special formatting
    5. Other Sparks
    6. Exercise
  • Appendix