Excel – Learning Chart

Excel – Learning Chart

Excel – Learning Chart

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

Prerequisites:

  • This course was recorded with Excel 2013 but it's also compatible also with Excel 2007 and 2010
  • It is also compatible with Microsoft Office for Mac
  • Only basic prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel course

Lessons

  1. Getting the Data right for Graphing

  2. Understanding Excel graphs and incorporating them into your model

  3. Adding another series to a graph

  4. Creating a secondary axis in a chart

  5. Changing default coloring to match corporate colors

  6. Create a chart template for consistent use

  7. Different Chart Types

  8. Trend-lines in models

  9. Goal-seeking straight off the graph

  10. Linking your Word documents directly to the Excel graph

  11. Conditional Formatting Graphs

  12. Reporting

No Comments

Post a Reply

Teachers