Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...

Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
How Data Must Be Setup To Use Excel Data Analysis Features: Table Format Structu
1. Field Names (Column Headers) in First Row
2. Records (Individual Transactional Records) must be in rows
3. No Blank Columns, Rows, Fields names. Try not to have blanks in data set.
4. Data set must be surrounded by blank columns and rows and/or Excel Worksheet column or row headers
5. Select whole table keyboard = Ctrl + *
6. Jump to bottom of column keyboard = Ctrl + Down Arrow
7. Jump to end of Current Region keyboard = Ctrl + Arrow
8. Jump To Cell A1 keyboard = Ctrl + Home

Got a Question? Ask it Here in the Forum.