Excel: 3 Tips for Filtering
In this video, learn three quick and effective tips for filtering data in Excel. First, discover how to delete specific records after filtering by state, such as Georgia, ensuring only visible rows are removed. Next, learn how to copy filtered data to a new worksheet for better organization. Finally, see how to use Conditional Formatting to highlight and filter by cell color for multiple states like Georgia and California. Enhance your Excel skills with these practical tips!
00:00 Introduction to Excel Filtering Tips
00:09 Deleting Filtered Records
00:49 Copying Filtered Data to a New Worksheet
01:17 Using Conditional Formatting with Filters
02:11 Conclusion and Additional Resources
-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Видео Excel: 3 Tips for Filtering канала Chris Menard
00:00 Introduction to Excel Filtering Tips
00:09 Deleting Filtered Records
00:49 Copying Filtered Data to a New Worksheet
01:17 Using Conditional Formatting with Filters
02:11 Conclusion and Additional Resources
-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Видео Excel: 3 Tips for Filtering канала Chris Menard
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Remove Duplicate Rows with Power Query in ExcelExcel - Scenario Manager / What-if AnalysisExcel Essential Skills | Rows & Columns and the EVIL Merge and CenterQuick Analysis in Excel - Charts, Totals, Running Totals, Data Bars, and Sparklines by Chris MenardExcel Paste Special: Shortcuts and Tricks!SnagIt 2024 Share to Microsoft Teams: New FeatureWhat is VPN and Why Do You Need It?OneDrive - Teams and Outlook folders automatically created in OneDriveExcel for the web - Recommended Pivot Tables - New Feature 2021Microsoft - NEW Teams - New Share App Feature from the TaskbarExcel Business Functions - Functions everyone should know - Excel Essentials TrainingTeams improvement to screen sharingExcel Filtering Tips with Chris Menard - Microsoft Certified TrainerTeams Video Call or Meeting - Toggle View - Teams TipExcel - using the Scenario Manager to track house payments with skyrocketing mortgage rates.Getting started with ChatGPT - Three ExamplesNotify when Available is Back in NEW Teams!Excel - Getting started with Filtering DataExcel 3D Reference - easily reference data on another worksheetCopilot in Excel: Conditional Formatting with Complex Functions