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 Mat...
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...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...

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.