Excel IV Large Data

Working with Data

• Importing Data from a Text File
• Exporting Data
• Converting Text to Columns
• Using Flash Fill
• Using Text Functions

Using Table Features

• Creating a Table
• Formatting a Table
• Sorting a Table
• Filtering a Table
• Use number match/comparison criteria
• Filter information using AutoFilter
• Creating a Slicer
• Working with the Total Row
• Creating a Calculated Column

Entering Data

• Using Convert Text to Columns Wizard
• Creating in cell Drop Down boxes with Data Validation
• Using the Pick List to enter data
• Flash Fill
  

Pivot Tables Basics

• Creating A Pivot Table
• Laying out a New Pivot table On the Worksheet
• Managing Pivot Tables
• Grouping Pivot Table Items
• Displaying Pivot Table Details
• Adding/Deleting Subtotals
• Adding Sub-Details to an Item
• Create, edit and delete a Custom Lists
• Remove Duplicates
• Userform