yes for 4 regions . let’s say there are 30 nations . with filter you can type a few letters and pick the nation straight away . in your way it will take ages to find the nation by scrolling down the list
@Luqman.Khawaja
6 ай бұрын
I think this trick is useful by a maximum of 10 regions 😊
@filco8494
21 күн бұрын
try Filter() Function. It's awesome
@user-hr8wf1dx4d
Күн бұрын
Very helpful, especially for few filters
@apc4y
2 ай бұрын
Such an incredibly powerful tool
@CheatSheets
2 ай бұрын
It really is! Let us know if you ever have any Excel questions or video requests 😊
@JJ_TheGreat
4 ай бұрын
Thank you! Slicers are a lot more intuitive to use than filters, especially on dashboards which may be used by non-technical people.
@ElsaAndAnnie
5 ай бұрын
I need to buy you a lavish dinner for sharing best of best tactics. You make my life easy!
@ralfo1704
5 ай бұрын
I use them very often. It is very helpfull. Only some users dont know how to use them:)
@nkmoorthybe
6 ай бұрын
Good info, Useful for me !
@Whogirl42
6 ай бұрын
Omfg this is genius🙌
@body1880
5 ай бұрын
Wow great filter tips man!
@luciddty2867
14 күн бұрын
Love it 👍🏻
@blues_power
6 ай бұрын
Great help.. thank you
@SDeepa411
4 ай бұрын
Thanks thats great.. really helpful 👏👏👏
@ElsaAndAnnie
5 ай бұрын
Superb!!! Amazing video
@henrytse9300
5 ай бұрын
awesome !
@ashish803922
5 ай бұрын
Useful video
@Muhammadarif-Eagle2019
2 ай бұрын
excellant sir
@CheatSheets
2 ай бұрын
Happy to hear you enjoyed this tip! Let us know if you ever have any Excel related questions or video requests 💚
@AnbarasanSundaramothy
5 күн бұрын
Usefull info
@akberali2149
Ай бұрын
Love you, so beneficial trick, thanks
@CheatSheets
Ай бұрын
Happy to hear that! Thanks for watching 😊
@charlestoddsullivanforpres6628
8 күн бұрын
Or, send the spreadsheet into SAS and code it to things far more robust and useful.
@sancasteabro4285
6 ай бұрын
Great job congratulations
@septea7032
6 ай бұрын
You dont need to go way round Just go straight to filter
@chrisspire
6 ай бұрын
"You wanna be cool? don't do this in two clicks and 10 seconds. Do it with 20 clicks and 60 seconds."
@enrikekasijas705
4 ай бұрын
People who are making such files are most likely sharing them with others on daily basis. This alone is a great trick. You can always combine that with a macro for making this trick much much much better. Be open minded in Excel 😅
@viewsreviewsanalysis646
6 ай бұрын
Very nice
@mspshameem
4 ай бұрын
Good helpful
@wayesquruni1284
6 ай бұрын
Helpful
@maba5202
5 ай бұрын
Maybe pivot table ? Its even fast than your suggestion and you can add all sorts of filters. Or go to recommended pivot tables. Even easier
@tehsarr0w
3 ай бұрын
yo can u kinda detail that i filter like a noob and this is pretty lvl 10, are u saying pivot tables r lvl 50 or something
@cbmcbm2845
19 күн бұрын
Filtering with dashboard 👌
@UncoveredRoutes
5 ай бұрын
Awesome
@jagadeeshinduri
4 ай бұрын
Impressive
@CharlesSetati
16 күн бұрын
Great
@ronitpearl4872
5 ай бұрын
WOW! thanks
@Live-InSportsNewsandtruths
6 ай бұрын
Very useful
@HontuZindabad
5 ай бұрын
I think a pivot table with groupings is better, it might be less fancy but you don't need to click anything so saves a lot of time.
@seabass8154
5 ай бұрын
You can use slicer with pivot table too. Fancy and easy.
@BlackOut321123
5 ай бұрын
Or do either, the second option is way slower if you're just quickly inspecting the data
@jamescarmichael8969
5 ай бұрын
Or if this is long term data that you will keep checking, option 2 is clearly much quicker?
@drewwiththeflow
6 ай бұрын
Nice❤... thank you
@jkr9229
5 ай бұрын
Nyc shorts
@mohamedthamimulansari3939
Ай бұрын
This is really awesome. It would be great if I can get an answer for my query. Need to see the total consolidate sales amount across region wise. How to get it? Your prompt response is appreciated
@jaisimhadharmalingam3835
4 ай бұрын
Thank you
@JMGauthier
2 ай бұрын
You can also right click on the value you want, like South, and in the right click menu there is a Filter option, select Filter by this value (or something like that, I'm on my phone and can't verify the exact command). The point is using the filter drop down, using slicers, or using my suggestion are all OPTIONS. They all perform the same task in different ways. They all have pros and cons and each option will be better suited for different situations. Use what works bet for the situation.
@CheatSheets
2 ай бұрын
You’re correct - you can right-click any cell, hover over filter, and then filter by the selected cell’s value, color, font color, or icon 😊 We totally agree that you should use what works best for your situation! Awesome response 💚
@bijaytanty8434
5 ай бұрын
Thanks Sir
@hareendranathamuthu6711
5 ай бұрын
Thanks you
@ShivamSingh-dm3he
Ай бұрын
Good
@mryip06
4 ай бұрын
Nice
@likealady-lm7wy
5 ай бұрын
✨10/10✨
@jozefmicsinai7162
5 ай бұрын
It´great. Does it work just on Excel 365 or on older versions as well ?
@gamex-animex6289
6 ай бұрын
Filter dropdown is still valuable if you lotnof distinct values
@Umibaig
5 ай бұрын
This Filter How's widow version Apply?
@sureshdarla5540
6 ай бұрын
Cool
@luiscastillo7009
6 ай бұрын
Very intuitive, thanks!
@suryapriya9877
3 ай бұрын
Good information sir ☺️,But it's not suitable for all versions
@spk3489
6 күн бұрын
How do you screen record this? On pc or mobile?
@SureshKumar-pr9uq
5 күн бұрын
This Trick work on 2007 version
@merasolo7598
18 күн бұрын
Can we do this in mobile Google sheet
@Nadafsirji
5 ай бұрын
Which app you use for screen recording
@balagapallavi782
6 ай бұрын
then how to put for multiple columns in single workbook
@noufalshoukath2324
6 ай бұрын
In which version can I use this tool?
@santykashyap0
5 ай бұрын
👍👍
@Enki._
3 ай бұрын
Does Google Sheets do something similar?
@user-sf9fh8ib6g
4 ай бұрын
In which version it works
@aashishsoneji7507
5 ай бұрын
Are slicers available in excel 2010 or 2016
@CircleSports_ph
6 ай бұрын
What version of excel is this?
@sukanyaghosh2093
6 ай бұрын
❤❤❤❤
@sathishkashyap4151
5 ай бұрын
Which version of Windows OS and Microsoft Excel?
@polygonekoma
3 ай бұрын
I like the tips but this one seems overly complicated xD
@kennykynguyen3764
19 күн бұрын
Ctrl T😊
@JefersonSuruy
6 ай бұрын
Excellent, this trick is really useful
@cultureandtourism7559
3 ай бұрын
❤
@dominikjez7455
7 ай бұрын
I still don't use any of this, I just look for it... 💀
@nathanielaboagye2259
6 ай бұрын
😂😂😂😂
@GenericAnonymity
6 ай бұрын
I could see it being handy if you have a job making team jerseys - you have a list of the orderered jerseys, but you create a few filter options - by age group, by size, etc So you can get a visual of just one size, then go back to the full view easily
@lutaayawamala
3 ай бұрын
The 1st way was faster.
@whatjake7898
6 ай бұрын
I guess this works for your little high school project but for us that do this for a living with real spread sheets this is trash.
@bc4198
6 күн бұрын
Ooooooooo 👀
@mrredditstories9095
5 ай бұрын
what screen recorder did you use??
@Learn_with_Matt
5 ай бұрын
I record on PowerPoint
@djamshidashrapov1751
6 ай бұрын
Does it work with Google sheets?
@easonshih4818
6 ай бұрын
I was gonna ask the same question
@dtmdota6181
5 ай бұрын
Terry bull has 1 sales
@saifkhandaker3341
6 ай бұрын
If your building for an audience then yes. But for your own use no point of using slicers
@phandongexcel
5 ай бұрын
I from Vietnam. I have KZitem channel Phandongexcel. I like this video ❤❤❤❤
@user-zq1jg5ww4y
3 ай бұрын
This option is available in librecalc?
@CheatSheets
3 ай бұрын
I am unfamiliar with librecalc ☹️
@Cricstory0108
2 ай бұрын
Bro provide data
@gnaihccn
5 ай бұрын
Just filter data like this
@Aryues
6 ай бұрын
Dang
@leixiao169
3 ай бұрын
Thanks!
@CheatSheets
3 ай бұрын
Of course! Glad you enjoyed this one! 💚
@leixiao169
6 ай бұрын
Does this work for pivot tables generated by Excel?
@croskoal
5 ай бұрын
It always has, not sure if that changes recently
@leixiao169
5 ай бұрын
@@croskoal Indeed it works in my hand. Thank you very much!
@artofpeacewarrior
6 ай бұрын
You are joking???? You can filter with two clicks and then you invent a solution that takes more clicks just to make you more fancy..... Uselessssss
@amumuisalivedatcom8567
6 ай бұрын
Nope, very useful. I'm the guy that do the excel (vba and stuff) for my coworkers and a lot of them are stupid af, most need things like that to work. Btw, it's great also to make specific custom filter for somes, if i know someone only work with a bunch from the list, i let him choose his favorites directly in the excel to have shortcut.
@sriratna9211
6 ай бұрын
Probably you never worked with extende data sheets and having to filter many options. Stop criticizing a little bit and be thankful, dude expended his time to teach people something… and you are here hating
@ahsanulkabir8640
Ай бұрын
I am having short time
@madcap4444
5 ай бұрын
Still complicated can u make excel easier
@user-vt3uh2in7o
6 ай бұрын
Hugh Jass
@jedi.script
6 ай бұрын
Anyone read the names 😅😅
@silversamurai0267
6 ай бұрын
I did! 😂
@v13iwoczek64
2 ай бұрын
for 2000. :)))))))
@YBIsAThotNoCap
6 ай бұрын
All those extra steps? Absolutely not. Get real.
@nathanielaboagye2259
6 ай бұрын
Why??
@YBIsAThotNoCap
6 ай бұрын
@@nathanielaboagye2259 click twice to filter vs fifteen steps.
@GenericAnonymity
6 ай бұрын
So what's the short way???
@ExecutionOfAllThings
4 ай бұрын
Tell me why this isn’t a waste of time. Any language will do. I’m waiting.
@arjungrajasekar5145
Ай бұрын
😂 not much difference 😢😢
@ajm3047
12 күн бұрын
Don’t tell me what to do
@lyteabhishek
Ай бұрын
Its not useful. Are you gonna put table for all columns and what 30 filters instead of 4.
@candrayudha7575
6 ай бұрын
Lol
@joseayala491
7 ай бұрын
You sound too scary
@moramento22
6 ай бұрын
WHY DO YOU HAVE TO SHOUT!?!?
@BinaryMaestro1
6 ай бұрын
learn mysql
@nathanielaboagye2259
6 ай бұрын
Why??
@BinaryMaestro1
6 ай бұрын
@@nathanielaboagye2259 it's also used for tables like he did and allows u to make with it a lot more for example compile with a php file to create a login page
@BinaryMaestro1
6 ай бұрын
and no its not used for anything else but if u make tables in exel mysql is better sadly it requires xampp and special language
@jiraphan88111
6 ай бұрын
Table suck
@moela5251
4 ай бұрын
Useless
@subalakshmiramadass681
4 ай бұрын
How do create four files for for regions easily. Ie in case i need some 50 files for each value of a category
@OggVorbis69
3 ай бұрын
By the time you play with the slicer I’ll have the result for any arbitrary set.😂
Пікірлер: 134