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



Online Courses for microsoft excel :

Course updated 2011-02-05 20:23:36

Instructor : ExcelIsFun

Course Duration : 5:22

Rating : 5.00 / 5

Step by step & Descreption :
Download files at:
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 Structure:
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