Excel Forum
Similar Content
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...



Highline Excel Class 14: How To Setup Data in Excel


See how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

The Rules for this Format or Setup a
1. First row has field names with formatting that is different from the rest of the data
2. No blank field names
3. Columns are called Fields
4. Rows are called records
5. No blank columns (fields)
6. No blank rows (records)
7. Blank rows and columns and/or Excels column headers (A, B) and/or row headers (1; 2) must separate the Excel List from other data
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.