Main Profile

At A Glance

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 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
Length: 05:22

Contact

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

Want more info about Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question