MS Excel - Filtering Data

About this video

• Video Title: MS Excel - Filtering Data
• Channel: TutorialsPoint
• Speakers: Not specified
• Duration: 00:07:10

Overview

This video demonstrates various methods for applying filters to data in Microsoft Excel. It covers shortcut keys, using the ribbon interface, and keyboard-based navigation to activate and deactivate filters. The tutorial also explains how to filter different data types, including dates, text, and numbers, and demonstrates how to copy and paste filtered data to another sheet.

Key takeaways

• Applying Filters: Filters can be applied using the shortcut Ctrl + Shift + L, the "Data" tab in the ribbon, or keyboard shortcuts (Alt + A + T).
• Filtering Data Types: The video shows how to filter dates (e.g., by specific year, tomorrow, next month), text (e.g., begins with, ends with, contains), and numbers (e.g., greater than, less than).
• Advanced Filtering Options: Beyond simple selection, advanced text and date filters offer criteria-based filtering. For numbers, options like "greater than" or "less than" are available.
• Copying Filtered Data: To copy only the visible (filtered) data, select it, press Ctrl + C, and then paste it to the desired location. Hidden rows are not included in the copy operation.