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 are: 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
Questions about Highline Excel Class 14: How To Setup Data in Excel
Want more info about Highline Excel Class 14: How To Setup Data in Excel?
Get free advice from education experts and Noodle community members.