Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn to create and customize professional charts in Microsoft Excel through this 11-minute video tutorial. Master the creation of various chart types including column charts, bar charts, stacked columns, and multiple columns using both the insert ribbon and the Alt + F1 shortcut key. Discover how to enhance charts with essential elements like titles, labels, legends, and gridlines, while exploring formatting options for colors, fonts, and styles. Practice with a downloadable workbook to follow along, and gain practical insights on when to use different chart types for effective data visualization. Progress through comprehensive lessons covering dynamic titles, bar thickness adjustments, gap sizing, and quick layout options that transform raw data into compelling visual presentations.
Syllabus
Introduction
Insert column chart
Change to bar chart
Bar chart vs. column chart
Shortcut to insert column chart
Add chart elements
Quick layouts
Change colors and styles
Add dynamic title
Multiple columns chart
Change colors
Adjust bar thickness and gap size
Stacked column chart
Wrap up
Taught by
Kevin Stratvert