Excel Forum

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.