Microsoft Office Tutorials and References
In Depth Information
● You can use charts to summarize large sets of data in an easy-to-follow visual format.
● You’re not stuck with the chart you create; if you want to change it, you can.
● If you format many of your charts the same way, creating a chart template can save
you a lot of work in the future.
● Adding chart labels and a legend makes your chart much easier to follow.
● If your chart data represents a series of events over time (such as monthly or
yearly sales), you can use trendline analysis to extrapolate future events based
on the past data.
● With sparklines, which are new in Excel 2010, you can summarize your data in a
compact space, providing valuable context for values in your worksheets.
● With a PivotChart, you can rearrange your chart on the fly, emphasizing different
aspects of the same data without having to create a new chart for each view.
● With Excel, you can quickly create and modify common business and organizational
diagrams, such as organization charts and process diagrams.
● You can create and modify shapes to enhance your workbook’s visual impact.
● The improved equation editing capabilities help Excel 2010 users communicate
their thinking to their colleagues.