Excel IV Large Data
Scheduled Dates
This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information. |
Topics Include:
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