This tab has commands for editing, fonts, alignment, number formats, styles and some more sophisticated editing features for a spreadsheet, such as sorting and filtering.
Tag Archives: Filter
Filter a database
Turning on the filter for a database allows sorting and filtering that is helpful in investigating the details of a data set.
The Data menu
This tab has commands to connect an Excel spreadsheet to external data sources for reporting and graphing that data. There are also commands for sorting, filtering, outlining and data cleaning. Some of the more powerful and useful features for analysis are also located in this menu tab.