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 YouTube 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 https://www.youtube.com/watch?v=6v2aj1GE3fg
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY https://www.youtube.com/watch?v=uCmmuScmxQk
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total https://www.youtube.com/watch?v=KSaM8JAVnSo
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting https://www.youtube.com/watch?v=qFnHYfn6yNs
Excel - Filter a PivotTable with a Timeline https://www.youtube.com/watch?v=FIKqdUC92f4
Excel Add Sparklines on a Separate Worksheet https://www.youtube.com/watch?v=163KG9gImPI
Excel Chart Maps used with the Geography Data Type https://www.youtube.com/watch?v=iQvapFfAoEE
Excel Concatenate Text and Dates with the TEXT function https://www.youtube.com/watch?v=hljBSRnKZp4
Excel - Insert a blank row after every row or every Nth row https://www.youtube.com/watch?v=FPu3nJBwgEc
CTRL + SHIFT + V to Paste Plain Text in Excel - New feature coming soon https://www.youtube.com/watch?v=VA4C4-3sWu0
Excel Images: Two New Features | IMAGE function and Data from Image https://www.youtube.com/watch?v=57L6jkT0PaM
Excel - Separate Positive and Negative numbers in the same column https://www.youtube.com/watch?v=ssxjvgXvveg
Excel Freeze Panes - Freeze panes to lock rows and columns https://www.youtube.com/watch?v=KkZTsDIh3D8
Excel PivotTables - Six Tips for working with PivotTable Field List https://www.youtube.com/watch?v=CEZDCNfCpEE
Excel New Image Function - Insert Images into cells with a Formula! https://www.youtube.com/watch?v=MerHkhCJh7c
Excel Sparklines - 5 Tips for Sparklines https://www.youtube.com/watch?v=4FCSkeWtyM4
Excel - Vertical Analysis - Financial Statement Analysis - Income Statement and Balance Sheet https://www.youtube.com/watch?v=aZuFOJrVQL0
Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row. https://www.youtube.com/watch?v=nPTl1RjJs0Q
Excel Keep Leading Zeros - Text vs. Numbers - Advanced Options https://www.youtube.com/watch?v=cccFPbh8ALY
Excel - Share a PivotTable without the Source Data or Underlying Data. https://www.youtube.com/watch?v=yLAOJ10vVQ4
Solvency Ratios in Excel - Debt to Equity, Debt Ratio, and Equity Ratio https://www.youtube.com/watch?v=qcNJ-t-4p3M

Видео Excel Filtering Tips with Chris Menard - Microsoft Certified Trainer канала Chris Menard