Excel table and the pivot table are great Excel features, which will make your data analysis easy and quick.

Data Table: In this chapter, we will introduce how to convert a data range to a table, change table style, resize, sort and filter a table, more…

Pivot Table Basics: In this chapter, we will introduce how to make a pivot table, add a filter, and how to display totals including refreshing a pivot table and changing data sources, more…

Advanced Pivot Table: In this chapter, we will introduce how to group items or dates, how to move or clone a pivot table, show labels in different forms, and how to add calculated items or fields, more…

Pivot Table Slicers: Slicer is a great way to display and manipulate the pivot tables. In this chapter, we will introduce how to insert and use a slicer, how to connect a slicer to multiple pivot tables, and also how to insert a timeline etc, more…