|
|
Featured Tutorial
Featured Macro
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
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