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

Category:

Science & Technology

Tags:

• Excel
• Data
• Setup
• in
• So
• Analysis
• is
• possible
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[elwhiskey]

Hey Mike: rule #8: no merged cells, right?

[ExcelIsFun]

Yes, that is a great rule to add to the list!!! Merged cells cause all sorts of trouble.

[lexingtonlp]

Also loved it! Always straight to the point and provides explanations in an easily understood manner. Great Job!

[ExcelIsFun]

I am glad that the videos are helpful!

[thirthyest]

quick and clear, loved it :)

[ExcelIsFun]

EXCELlent!!!

[ExcelIsFun]

Dear slaves2sin,

Great to see you watching this series. There ia a LOT of information in this series!

--excelisfun

[slaves2sin]

awesomeness this si perfection