Charts, Visuals, And Graphs In Microsoft Excel

Charts, Visuals, And Graphs In Microsoft Excel

What you'll learn

Description

Presenting data visually can make it easier to understand and absorb. It is one thing to read a row of figures on the page, but quite another to see those figures presented in a user-friendly chart.
The data visualization process aims to make sense of the raw data, presenting it in a manner that is easy to understand even for non experts.
Pie charts and bar charts are among the most commonly used data visualization techniques; they can be created easily using common spreadsheet programs like Microsoft Excel.
Numerical data can be represented in histograms, while categorical data can be visualized using frequency tables and charts.
Cumulative frequencies count the number of data points up to a given value and are used to find the median, quartile, and percentiles in a group of data.
Relative frequency, on the other hand, is used to represent how often something happens relative to some total. For example, the relative frequency may be used to show that a given sales team won 10 of its last 13 contracts, while the cumulative frequency will show the median number of contracts won across the entire year.
Visualizing data is an important skill, and that ability is important whether you are running a business or teaching a class.
You can get a sense of the importance of the data by looking at numbers on a spreadsheet, but a well-chosen visual representation of that data can be much more useful.
At the conclusion of this class, you should be able to:
Organize data
Construct tables and charts for numerical data
Construct tables and charts for categorical data
Describe the principles of properly presenting graphs
Use Microsoft Excel to present data in basic graphs and charts
Demonstrate how to create a pivot table and histogram


Overview

Lesson 1:Introduction from Dr. Justin
Lesson 2:Tutorial on Charts, Graphs, and Visuals in Excel