Excel Five Great Tips for Filtering Data

preview_player
Показать описание
Five great filtering tips for Excel. Filter by selected cells value, copy and paste filtered data, delete filtered data, auto-calculate works with filtered data, and search for filtered data.

Blog post on Filtering data

Chapters:
00:00 Introduction
00:11 Tip 1 selection filter
01:01 Tip 2 copy / paste
01:37 Tip 3 delete
02:30 Tip 4 - autocalculate
03:15 Tip 5 - search
04:33 Closing remarks

#msexcel #chrismenard #chrismenardexcel #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

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!
Рекомендации по теме
Комментарии
Автор

Thanks Chris. Let's take your example when you filter on Marietta. Let's say I want to change this value and put Chicago, if I change the first Marietta to Chicago and then drag till the bottom, sometimes (not always) Excel changes the values of the hidden rows, so usually when I want to change value on filtered cells, I select my cells, ALT + ; to select only visible cells and then change the value with CTRL + ENTER

einoconsult
Автор

How can i get connected you in personal message ?

dhruvsingh