Excel 365 in 30 Minutes – Tables & PivotTables (Intermediate 6 of 8)

In this Bigger Brains course, you’ll learn how to turn ordinary datasets into powerful Excel tables that make sorting, filtering, formatting, and analyzing information faster. You’ll see how to create and rename tables, customize their styles, and add or remove rows and columns. You’ll also see how to remove duplicates, and use calculated columns, and you’ll learn to summarize data with the Total Row and convert tables back to ranges when needed. 

Next, you’ll learn how to build PivotTables to quickly summarize and analyze large datasets. You’ll see how to expand and collapse levels, show or hide subtotals and grand totals, and apply styles that make your results easier to understand. You’ll also learn how to bring online data directly into Excel with web queries, adjust query properties, and refresh your data manually when updates are available. This course is designed for users who already understand Excel basics and want to strengthen their skills with time-saving tools that turn raw data into meaningful insights.   

Topics covered include: 

• Describe the difference between a table and a dataset 

• Create a new table from a dataset 

• List components of a table 

• Rename a table  

• Add and delete rows and columns  

• Remove duplicates from a table 

• Change table formatting using a Table Style 

• Customize Table Style Options from the Design tab 

• Create and modify a new Table Style 

• Summarize columns in a table using functions on the Total Row 

• Change the functions on the Total Row 

• Add a calculated column to a table 

• Convert a table back to a data range 

• Create and modify a PivotTable 

• Navigate a PivotTable by expanding and collapsing levels 

• Show and remove subtotals and grand totals 

• Apply a style 

• Create a Web Query that pulls data from the internet into your workbook. 

• Modify the query properties to adjust how query refreshes. 

• Manually refresh the query data. 

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.