Excel Fundamentals: Bar and Column Charts
Transform your data into clear, compelling visuals with Excel. In this focused 1-hour course, you’ll master the fundamentals of data visualization using bar and column charts. No prior experience is required.
Learn how to choose the right chart for your message, customize it for maximum impact, and use built-in tools to bring your insights to life. Perfect for professionals who want to communicate data more effectively, faster.
Welcome to the Course
Welcome to the Course
Get an overview of what you’ll learn in the course.
Download the Practice Files
Download the Practice Files
Learn by Doing. Download a copy of the practice files and follow along with the demos in real-time.
Download the Bonus Guides
Download the Bonus Guides
To help you get even more from the course, I’ve included two downloadable Excel chart guides (PDF's)...
Choosing the Right Chart
Choosing the Right Chart
Learn how to select the most effective chart type to clearly communicate your data story.
Creating Your First Chart
Creating Your First Chart
Follow a step-by-step guide to build your first bar or column chart quickly and confidently.
Changing the Chart Type and Data Source
Changing the Chart Type and Data Source
How to switch between chart types and update your data source without starting over.
The Anatomy of a Chart
The Anatomy of a Chart
Understand the key components that make up a chart.
Add, Remove and Customise Chart Elements
Add, Remove and Customise Chart Elements
Fine-tune your chart by adding, removing & adjusting titles, labels, and more.
Are You Colour Challenged?
Are You Colour Challenged?
Get practical advice for choosing chart colours that are accessible and visually effective.
Working with Colour
Working with Colour
Apply and modify colour schemes to enhance readability and highlight key insights.
Pictures, Shapes and Icons
Pictures, Shapes and Icons
Enhance your charts with visuals like images, icons, and shapes.
The Power of The Pivot
The Power of The Pivot
PivotTables can streamline your data and power dynamic, summary-based charts.
Creating a Chart from a Pivot Table
Creating a Chart from a Pivot Table
Create Pivot Charts that update automatically as your data changes.
Copying a Chart to Another Application
Copying a Chart to Another Application
Best practice for copying charts into Word, PowerPoint and other apps.
The Camera Tool
The Camera Tool
Use Excel’s hidden Camera Tool to capture dynamic, updatable snapshots of your charts.
Wrap Up
Wrap Up
Recap the key skills you’ve learned, explore ideas for putting them into practice.