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

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.