Excel 365 in 30 Minutes – Charts & Graphics (Intermediate 5 of 8)

In this Bigger Brains course, you’ll learn how to build and customize charts that highlight key insights in your spreadsheets. You’ll learn to work with the Ribbon and chart buttons to add or modify chart elements, filter your data, edit labels, apply different styles, and adjust colors, text, and backgrounds for a polished look. From there, you’ll expand your skills into compact, trend-focused visuals. You’ll learn how to create, modify, and clear Sparklines to show data trends directly within cells. 

You’ll also explore additional visual tools that bring more clarity and impact to your workbooks, including inserting and formatting pictures and using SmartArt to present concepts visually. You’ll see how to add text to shapes, adjust SmartArt colors, update layouts, and apply styles that match your message. By the end, you’ll be able to confidently create, customize, and enhance Excel visualizations that communicate your data effectively. 

Topics covered include: 

• Using the Ribbon to add or modify chart elements 

• Using the chart buttons on the chart to add or modify chart elements 

• Filtering the chart data 

• Changing the data labels on a pie chart 

• Selecting a Chart Style 

• Changing chart background and marker colors 

• Formatting text on charts 

• Formatting data labels 

• Printing a chart 

• Creating and modifying Sparklines to show data trends 

• Clearing Sparklines 

• Inserting pictures onto a spreadsheet 

• Formatting graphics 

• Creating a SmartArt graphic 

• Adding text to shapes 

• Modifying SmartArt colors, layout and style 

Enjoy award-winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.