I ask not for a lighter burden, but for broader shoulders . ~ Jewish Proverb. Day 10 : Excel chapter 5. CS 101 [email protected] February 10 th , 2014. Large datasets. So far we have covered relatively small data sets
A table is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
Insert -> Table
Sometimes you may need to add a field,to insert a field:
Filtering is the process of displaying only records that meet specific conditions.
A Total Row appears below the last row of records and enables you to display summary statistics.
Subtotal calculates an aggregate for values in a range or database
***The benefit of subtotal is that it will only display records that have been filtered.
Helps you and your audience understand a dataset better by adding a visual element to the cells.
(A failing grade, highlighted in red for instance)
Example use: Finding the ten lowest grossing car lots, so you can close them.
Home Tab -> Conditional Formatting
-> Manage Rules