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
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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