Excel Filtering Tips with Chris Menard - Microsoft Certified Trainer

One of Excel's most popular features is filtering data. Filtering is used to hide data so you can only view specific criteria. This live stream will teach you how to use AutoFilter to filter text, numbers, and dates. You will learn how to do Advanced Filter to show different criteria.
Agenda / Topics
• Turning on Filters in Excel
• Simple Criteria for Text
• Use search criteria in filters
• Filtering dates
• Filtering numbers
• Deleting rows with a filter
• Copying and pasting filtered data
• Using the Filter function
• Advanced Filters
• Using Tables
• Using Slicers to Filter
Date and Time: February 1, 2023, at noon ET.
Speaker / Presenter
Chris Menard is a Microsoft Certified Trainer and works full-time as a trainer at BakerHostetler, one of the nation's largest law firms. Menard's KZbin channel has over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated.
Recent Excel videos from Chris Menard
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips • Excel PivotTable - Per...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Condition...
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Perc...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting • Excel - Turn on Multip...
Excel - Filter a PivotTable with a Timeline • Excel - Filter a Pivot...
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines o...
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used ...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text...
Excel - Insert a blank row after every row or every Nth row • Excel - Insert a blank...
CTRL + SHIFT + V to Paste Plain Text in Excel - New feature coming soon • CTRL + SHIFT + V to Pa...
Excel Images: Two New Features | IMAGE function and Data from Image • Excel Images: Two New ...
Excel - Separate Positive and Negative numbers in the same column • Excel - Separate Posit...
Excel Freeze Panes - Freeze panes to lock rows and columns • Excel Freeze Panes - F...
Excel PivotTables - Six Tips for working with PivotTable Field List • Excel PivotTables - Si...
Excel New Image Function - Insert Images into cells with a Formula! • Excel New Image Functi...
Excel Sparklines - 5 Tips for Sparklines • Excel Sparklines - 5 T...
Excel - Vertical Analysis - Financial Statement Analysis - Income Statement and Balance Sheet • Excel - Vertical Analy...
Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row. • Excel Highlight Every ...
Excel Keep Leading Zeros - Text vs. Numbers - Advanced Options • Excel Keep Leading Zer...
Excel - Share a PivotTable without the Source Data or Underlying Data. • Excel - Share a PivotT...
Solvency Ratios in Excel - Debt to Equity, Debt Ratio, and Equity Ratio • Solvency Ratios in Exc...

[@seahabs8685]

Chris, this was extremely helpful. I learned a few tricks. I was wondering if you know how to access the new checkbox function in Excel. I don't seem to have the option under the insert tab on the ribbon. There are some amazing functions but I cannot seem to access. Any help would be appreciated. Thanks for what you do.

[@tamersalem7542]

Thank you

[@ChrisMenardTraining]

You're welcome!

[@therealjeffg]

Thanks Chris…always learn something …. CTRL” and ALT down arrow….didn’t know these shortcuts….also haven’t used the aggregate function so looking forward to that video