Work with dataCreate & use pivot tables Customize a pivot table Reference data from other sheets Using arrays in Google Sheets Automatically create a series or list Name a range of cells Filter charts and tables with Slicers Display KPIs with scorecard charts