Datasets+and+Tables

=Datasets and Tables =

=
Make a list of graduation or shower gifts received and organize the list using a name of the gift, from whom it was received (name), and their address. Develop a text filter and identify all gifts of a certain type. Highlight those cells.=====

media type="youtube" key="Sf-4dKqgjTo" height="315" width="420" align="center"

=[|Using Formulas with Tables] = = = =[|Table Improvements in Excel 2010] =



**__Large DataSets Issues __**

 * ===== Scrolling—headings disappear =====
 * ===== Printing—unplanned page breaks =====
 * ===== Navigation—extensive scrolling =====

Navigate large spreadsheet–Two ways to go to a specific cell

 * ===== Go To command (Home tab, Editing group, Find & Select button) =====
 * ===== Name box =====

Printing large datasets

 * ===== Preview (Page Layout view) and adjust settings before printing (Page Layout tab) =====
 * ===== Set and clear a print area =====
 * ===== Print titles =====
 * ===== Control print page order =====

__**Excel Tables **__

 * ===== Understand table benefits =====
 * ===== Understanding table design =====
 * ===== Create a table =====
 * ===== Customize a table =====

__**Table Benefits **__

 * ===== Column headings remain onscreen without using freeze panes =====
 * ===== Filter lists for efficient sorting and filtering =====
 * ===== Formatting using predefined table styles =====
 * ===== Create and edit calculated columns where formulas copy down the columns automatically =====
 * ===== Calculated total row with variety of functions =====
 * ===== Use of structured references instead of cell references in formulas =====
 * ===== Ability to export the table data to a SharePoint list =====

Guidelines

 * ===== Field names on top row =====

** TIP – Keep field names relatively short, descriptive, and unique **

 * ===== Format field names so that they stand out from the data =====
 * ===== Enter data for each record on a row below the field names =====
 * ===== No blank rows between records or between the field names and the first record =====
 * ===== Delete any blank columns between fields in the dataset =====
 * ===== Ensure unique field in each record, such as a transaction number or ID =====
 * ===== Separate table from worksheet data—at least one blank row and one blank column between table and other data, such as the main titles, input area, or other tables =====


 * ===== Convert existing data to a table =====
 * ===== Create table and add data later =====

__**Using Structured References and a Total Row **__

 * ===== Excel aids in quantitative analysis =====
 * ===== Formulas for tables—can use self-documenting built-in functionality that require less explanation =====

__**Sorting and Filtering Using Conditional Formatting **__

 * ===== Sort a column based on its conditional formats =====
 * ===== Filter a column based on its conditional formats =====