Excel IV Large Data
Scheduled Dates
| Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
|---|---|---|---|---|---|---|
| Excel IV Large Data | 5/8/2021 (Sat) | 9AM - 12PM | 5 | 2 | $80.00 | Register |
| Excel IV Large Data | 5/17/2021 (Mon) | 9AM - 12PM | 4 | 4 | $80.00 | Register |
| Excel IV Large Data | 6/1/2021 (Tue) | 9AM - 12PM | 4 | 4 | $80.00 | Register |
| Excel IV Large Data | 6/8/2021 (Tue) | 1PM - 4PM | 4 | 4 | $80.00 | Register |
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