Excel Basics - Excel Charts & Graphs to Visualize Quantitative Data

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn to create effective Excel charts and graphs for visualizing quantitative data in this comprehensive 35-minute tutorial. Explore essential chart terminology, understand the concept of chart junk, and master various chart types including column, bar, pie, line, and scatter charts. Discover how to format chart elements, work with cross-tabulated reports, and use the Select Data Source dialog box. Compare the effectiveness of different chart types for specific data visualization needs, and learn about Excel's recommended charts feature. Gain practical skills to enhance your data presentation abilities and make informed decisions about chart selection and design.

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.