Excel Basics - Excel Charts & Graphs to Visualize Quantitative Data

This course teaches how to visualize quantitative data in Excel using column, bar, line, pie, and XY scatter charts. It emphasizes selecting effective chart types, formatting chart elements, and avoiding chart junk.

Syllabus

) Introduction to Excel Charts & Graphs.
) Excel Chart Terminology.
) What is Chart Junk?.
) Column and Bar Charts for comparing numbers across categories.
) Formatting Chart Elements with Buttons or Task Pane.
) Cross Tabulated Reports and Clustered & Stacked Column Charts.
) Pie Charts less effective than Column or Bar Charts.
) Line Charts to show trends or patterns over time.
) Select Data Source dialog box.
) X Y Scatter Charts for X Y Data to show a Relationship between Two Numbers.
) Recommended Charts.
) Summary.