Excel Data Tools
$150.00
Course Cost
Please choose
In stock
Product Details
Upcoming Classes
6/24/2025 - 9:00am to 12:00pm
WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!
Course Description
Lists of data are commonly kept in Excel. What few Excel users realize is the amount of data manipulation capability that is built into the program. This course will introduce the learner to the more in-depth methods of data sorting, filtering, subtotals, validation, and PivotTable analysis that can be carried out with a data list.
Prerequisite
Excel Basics and Intermediate or equivalent experience
Software Version
Microsoft (Office) 365, 2024, 2021, 2019
Course Highlights
- Data Sort
- Push Button Sorting
- Multiple Level Sorts
- Custom Sort Orders
- Filtering Data
- Exact Value Autofilter
- Custom Autofilter
- Top 10 Autofilter
- Clearing Autofilters
- Advanced Filtering
- Creating Data Validation
- Data Validation Types
- Extending Data Validation
- Automatic Subtotals
- Multiple Level Subtotals
- Removing Subtotals
- Creating a PivotTable
- Rearranging the PivotTable Layout
- Utilizing PivotTable Tools
- Refresh Data
- Format PivotTable Fields
- Add Calculated Fields
Display prices in:
USD
