Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.
Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...
Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.