Pivot tables is one way of performing data aggregation in Excel. With a few clicks of the mouse many different insights can be extracted from some data. The video below explains how to make pivot tables in Excel. Knowledge of this is an expectation in many analyst jobs. Please like and comment on this video and let us know how we can continue to improve.