Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Filtering Data for Beginners

via LinkedIn Learning

Overview

Coursera Plus Flash Sale: All Certificates & Courses 40% Off. 72 Hours Only!
Make the most of the filtering capabilities in Microsoft Excel. Learn how to use filters to zero in on exactly the data you need.

Syllabus

Introduction
  • Zero in on the right data with filters in Excel
  • What you should know
1. Basic Filter Concepts
  • What is a filter?
  • Types of filters
2. Refining Filters
  • Custom filters
  • Advanced filters
  • Filter for unique values
  • Filter with a formula
3. Filtering Tips
  • Use slicers to filter
  • Use Power Query to filter
  • Shortcut keys for filtering
Conclusion
  • Next steps

Taught by

Dave Ludwig

Reviews

4.7 rating at LinkedIn Learning based on 1449 ratings

Start your review of Excel: Filtering Data for Beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.