Excel Forum
Similar Content
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...
How to Create and Manage a Chart in Excel
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.