Excel 365 in 30 Minutes – Charts & Tables (Basics 9 of 10)

In this Bigger Brains course, you’ll learn how to turn raw data into meaningful insights with Excel’s charts, tables, and PivotTables. You’ll see how to insert both chart sheets and embedded charts, use Recommended Charts, and choose the best chart type for your data. You’ll explore how to resize, move, and modify charts, switch row and column orientation, remove or add data series, and adjust source data using Select Data Source. You’ll also see how to insert graphics and images, position them effectively, and understand the differences between datasets and tables. 

You’ll learn how to convert a dataset into a table, manage table data more efficiently, and work with default chart settings to speed up your workflow. You’ll also learn how PivotTables help you summarize and analyze transactional data and how to create PivotTables using both the dialog box and Recommended PivotTables. Whether you’re inserting visuals, modifying chart types, or building your first PivotTable, you’ll gain practical skills to make your Excel data clearer, more organized, and easier to understand. 

Topics covered include: 

• Inserting chart sheets and embedded charts 

• Using Recommended Charts and Recommended PivotTables 

• Selecting the best chart to represent a dataset  

• Inserting images and graphic objects  

• Changing the chart type of an existing chart  

• Removing a data series from a chart  

• Modifying the data source using Select Data Source  

• Describing the difference between a table and a dataset  

• Creating and managing a new table from a dataset  

• Describing the purpose of a PivotTable  

• Creating PivotTables using both the Create PivotTable dialog box  

• Configuring a PivotTable  

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.