Pivot tables
"Pivot tables are the quickest and most powerful way for the average person to analyze large datasets. No coding skills or mathematical brilliance are necessary—just the ability to point and click your mouse."
Source: https://qz.com/1903322/why-pivot-tables-are-the-spreadsheets-most-powerful-tool/
The following data coming from various research sources shows that Pivot Tables are are the key tool in everyday practice (http://www.statlit.org/pdf/2013-schield-mbaa.pdf):
Some links on pivot tables:
Edited by Dariusz Laska