Excel 2010 Managing Data

Table of Contents

• Excel 2010 Managing Data
• Managing Data in Excel 2010    Concept
• Importing Text Files    Concept
• Importing Text Files
• Creating a Table    Concept
• Creating a Table
• Table Manipulation    Concept
• Table Manipulation
• Auto Fill    Concept
• Auto Fill Numbers
• Auto Fill Dates
• Custom Lists
• Sorting and Filtering    Concept
• Sorting
• Filtering
• Data Validation    Concept
• Adding Data Validation to a Cell / Settings Tab
• Data Validation from an Existing List
• Input Message Tab
• Error Alert Tab
• Data Manipulation Functions    Concept
• Concatenate Function
• Left and Right Function
• Row Function
• RANDBETWEEN Function