Excel Charts for Data Visualization

Introduction to the course and course instructor.

Understand the 3 principles of data visualization to ensure you create charts that are relevant, clear, and well-designed. 

Explore some examples of good and bad chart design. 

Build your first chart and explore chart elements and chart formatting options. 

Explore the advanced formatting options available in the Format Pane. 

Use company colors in charts by creating a custom theme. 

Create a dynamic chart that automatically updates when new data is added using Excel tables. 

Learn how to change the chart type and add a secondary axis to represent two data series. 

Makes numbers more meaningful by using Custom Number formats in Charts. 

Save time by creating a reusable chart template. 

Visualize and analyze datasets using column and bar charts.

Visualize time-based data using line charts and trendlines. 

Create a Pie or a Doughnut Chart to effectively represent comparison data. 

Create an Area Chart to show the composition of data. 

Create a Histogram and a Pareto Chart in Excel to show a graphical representation of the distribution of numerical data.

Create a scatter plot chart in Excel to display a graphical representation of the relationship between two sets of data.

Create a bubble chart in Excel to display three dimensions of data. 

Create a Box and Whisker (Box plot) chart in Excel to display the distribution of data based on a five-number summary. 

Create a treemap and sunburst chart in Excel to visualize hierarchical data in different ways. 

Create a Waterfall Chart to visualize how an initial value is affected by a series of intermediate positive or negative values, leading to a final value.

Create a Stock Chart in Excel, also known as a financial chart, to visualize the price movements of a stock over a certain period.

Create a Radar Chart in Excel, also known as a spider chart or web chart, to display multivariate data in the form of a two-dimensional chart.

Create a funnel chart in Excel to represent stages in a process, showing the flow and drop-off of data at each stage.

Create a Dumbbell Chart to show the difference between two data points. 

Create a Map Chart in Excel to represent geographic data overlaid on a map. 

Create a chart that uses images, icons, or shapes to represent the columns. 

Use the Quick Analysis tool in Excel to quickly analyze and visualize data without extensive manual formatting or calculations.

Use Conditional Formatting along with Charts and formulas to highlight key values. 

Create chart titles that dynamically update when the chart changes. 

Apply Color scales to a dataset to visually represent the relative values in a range of cells using colors.

Apply Data Bars to values in Excel to visually represent the relative values in a range of cells using horizontal bars within the cells.

Use the REPT function to create in-cell charts using symbols that dynamically update when the data changes. 

Use Sparklines - small, condensed charts that fit into a single cell - to provide a visual representation of data trends or variations.

Create a Pivot Table and Pivot Chart from a dataset. 

Use Slicers to filter Pivot Table data. 

Connect slicers to multiple charts. 

Course Close and instructor goodbye.