Excel: Working with Excel DataBases - Sort, Filter, Subtotals & More

Return to Search page:
Name: Excel: Working with Excel DataBases - Sort, Filter, Subtotals & More
Overall Rating:
Category: All Learners
Duration: 1.50 hour(s)
Individual Fee: $20.00

Learning how to efficiently use Excel is so critical in many of today’s office jobs. Many people know the Excel basics. This webinar will show you how to use the Sort and Filter tools in Excel. Subtotals will help you begin to analyze data. 


Excel Data with Sorting, Filtering, Using Subtotals and More!

This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Contact: Eric Pfligler
847-543-2990
CorporateTraining@clcillinois.edu
https://calendly.com/tadmeeting/tad-employer-demo
Importance: Why this competency is important to our organization, mission, strategy, or goals.

Excel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions for effectively working with large worksheets of data.

Topics
  • Sort data in a worksheet
  • Filter data with AutoFilter
  • Use custom filter techniques
  • Apply conditional formatting for quick analysis
  • Sort and filter using colors and icons from conditional formatting
  • Create, view, and remove Subtotals
  • Split complex data into separate columns for ideal filtering and sorting

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel Advanced1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified

Cathy Horwitz

Years of Experience: 44+ years

Area of Experience: Microsoft Office 

Class Costs
Class ValueNo Charge
Individual Fee$20.00
Private Class Fee$0.00
No reviews have been provided for this development activity.
To enter a review for this development activity, select Add above
Return to Search page:
Copyright ©1998-2024, Business Talent Solutions, LLC. All Rights Reserved.