From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Use text, numeric, and date filters

Use text, numeric, and date filters - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Use text, numeric, and date filters

“

- [Instructor] There is so much that we can do with filtering in Excel, and I invite you to play with this. Go into the menus and explore. See what's there. See what's possible. So we have this data that's 2020 donations. This data set is sorted by the date. We've got first name, last name of the donors, the donation amount, states. Some of the states are highlighted blue. I'll get into that later. Then the payment method, check, debit card, credit card, cash, and then whether or not a tax receipt has been sent out to the donors or not. So for this situation, the organization is in Ohio. The sales that have the blue highlight in the state column are considered home region. Those would be Ohio and the surrounding states. So we've got Ohio, Indiana, Pennsylvania, Michigan, West Virginia, and Kentucky. So let's do some filtering. My cursor is in the dataset, and there are no empty rows or columns. Those would create problems, and let's look all the way down the data. There are some empty…

Contents