love watching your excel tutorials. I am currently having a test as data analyst and I need to get exposed with excel and dashboard and everything so your videos really helped me alot building my dashboard from scratch and the connection of slicer is really a gold mine lol more power to you sir
I love people that love Excel and learn something new everyday from them. Amazing how something so simple is the most awesome solution to a problem I have encountered many times. Thank you Jon.
+Wyatt McNabb Awesome! Thanks Wyatt! Maybe someday they will add a real search box to the slicers. I appreciate the nice feedback. Have a good one! :-)
Thanks Jon! I wanted an easy date select drop down and this inspired me to use the pivot version\search for the user. I created a data dashboard already with multiple criteria based on the date selection and this helped. Excel is so underrated :) . Like being able to to sum multiple values based on multiple criteria with a simple sumifs ... Thanks for your videos!
wow what would we do without this channel THANK YOU your "tricks" are so helpful for any business
4 роки тому+1
Hi, was sceptical at first (reading on your blog), but then the video looked okish, so i tried it and actually good tip. In my dashboard i had to put away the slicer as it was causing some distractions, but the idea of filter and not using the rest of pivot table, is great :) cheers
Thanks Jon! I am an accounting student and need to do projects with reports and I am going all out to adding a dashboard on the main page! I have always wanted to know how this is done and now I can do it also! Thank you again! Terrie Marie
Thank you, Jon. I've been using your videos and tutorials for a while now and always find them helpful and easy to follow. Thank you very much for the work you do!
Thanks John! I really appreciate your videos. Very helpful.. I've also purchased your Paste Buddy tool 2 years ago. Fasciltated my job big time. Much appreciated.
Wow... This is genius! I've spent a whole day to create a meticulous userform for 'smart' filtering... But this neat little trick is way better! Thank you a lot!
This is a good idea. Since slicers don't automatically jump to the selected person, I would add to a linked cell, probably as a title, showing the name of the person selected.
hi thanks alot really helpfull can you help me with something, i need to lock the filter on the slicer so that specific employees can see only their own filters or there own area of expertise. is there any way to do so?
I enjoyed watching this video and recommend others. Thanks for educating the community and appreciate your volunteer ship in teaching. My question is You have the filter ()Red X mark in Slicer and why can't we use that? Thanks a bunch
This is fantastic. Thank you for making an easy to follow video. The only issue that I'm having is that I can't move the filter cells as you show at the 3:27 mark. The filters automatically show at the top of the worksheet and can't be moved. Please let me know how to change it, so I can move the filter to where we need it in the worksheet. Thank you.
Very nice Jon. Though the size of the second pivot table selection field resizes based on the text length. Maybe maintain table formatting is needed? Question - is there a way to select a filtered set of data and copy it to the clipboard and then paste it into a predefined "table" and have the table automatically expand to the lines being copied?
Hi Larry, Yes, there is an option in the Pivot Table Options menu to Autofit Column Widths on Update. You can uncheck the box to turn it off. In regards to your question, you can use an Excel table for this. Here is a video on Excel Tables. ua-cam.com/video/fJnJTff4Na8/v-deo.html
Nice method for filtering multiple items in a slicer. Is there a similar method for filtering a group of numbers with a slicer? Like all records in a pivot table where the ID number is greater than 10000?
Hello, Thanks for putting up these great video! How would I get a pivot table row to be hyperlinked to another pivot table that has more detailed info about the row selected. So for example if I have a pivot table four projects, and if I click on project 1, I want to be taken another page that would have detailed info regarding that project 1. The detailed page would also be a pivot table, or developed from a macro that reads from the same date source. Hopefully I am making sense. Thanks in advance.
Outstanding tutorial! Loved the extra detail around making this "slicer filter" look super elegant. Kudos!
Glad you liked it @sriramvaradarajan1846 😀
I hope you are still making tutorials for Excel. The ones I have watched so far about pivot tables have been very helpful and easy to understand!
Thanks for your simple steps in creating a pivot table and dashboard. It was worth watching and learning from you.
Thanks, @KelvinKortuKollie 😀
love watching your excel tutorials. I am currently having a test as data analyst and I need to get exposed with excel and dashboard and everything so your videos really helped me alot building my dashboard from scratch and the connection of slicer is really a gold mine lol more power to you sir
I love people that love Excel and learn something new everyday from them. Amazing how something so simple is the most awesome solution to a problem I have encountered many times. Thank you Jon.
+Wyatt McNabb Awesome! Thanks Wyatt! Maybe someday they will add a real search box to the slicers. I appreciate the nice feedback. Have a good one! :-)
Thanks Jon! I wanted an easy date select drop down and this inspired me to use the pivot version\search for the user. I created a data dashboard already with multiple criteria based on the date selection and this helped.
Excel is so underrated :) . Like being able to to sum multiple values based on multiple criteria with a simple sumifs ...
Thanks for your videos!
wow what would we do without this channel THANK YOU your "tricks" are so helpful for any business
Hi,
was sceptical at first (reading on your blog), but then the video looked okish, so i tried it and actually good tip. In my dashboard i had to put away the slicer as it was causing some distractions, but the idea of filter and not using the rest of pivot table, is great :)
cheers
I love this new fresh approach. Thanks,
Big thanx to you Sir...I was badly searching for solution...this video solved my problem
Jon, this is so helpful!! I really appreciate how you teach.
Very lovely technique, this will save me a lot of time for large reports. Thank You.
Thanks Jon! I am an accounting student and need to do projects with reports and I am going all out to adding a dashboard on the main page! I have always wanted to know how this is done and now I can do it also!
Thank you again!
Terrie Marie
Thank you, Jon. I've been using your videos and tutorials for a while now and always find them helpful and easy to follow. Thank you very much for the work you do!
Was very helpful .Thank you for sharing Jon.
Exactly what I was looking for. Thanks for the post and the easy explanation of the process
thank you Jon its very simple and easy way to learn and understand it
Thanks John! I really appreciate your videos. Very helpful.. I've also purchased your Paste Buddy tool 2 years ago. Fasciltated my job big time. Much appreciated.
Thank you for lectures, now I can work with pivot Tables for the first time as an entry level finance assistant
This put a smile on my face and I subscribed immediately.
Always love your videos jon! Gets me excited everyday to get things done! ❤️❤️👌
Wow... This is genius! I've spent a whole day to create a meticulous userform for 'smart' filtering... But this neat little trick is way better! Thank you a lot!
Glad it helped! 😀
Jon, what a great trick, I love it. Thank you!
Thanks, Andreas! 😀
Clever. Exactly what I was looking for. Thanks!
AMAZING WAY OF TEACHING THANK YOU
Very useful! Thanks Jon!
Thanks very much Jon...very helpful!
Great solution, mate!
This was exactly what I needed, thank you!
You're so welcome, @kalib4530! 😀
I appreciate this tutorial very much!
Big help for my processes at work!
Awesome🌟 This is exactly what I was looking for.
That's good to hear, Bhaskar! :)
Always simple and straight to the point! Great!!
Exactly what I've been looking for. Thank you
You're welcome! 😀
Thanks dear brother, Honestly very helpful!!!!
It is so great Jon. Thank you so much, exactly what I am looking for.
Cool technique
Can't wait to apply it 🔥🔥
Mind blown! Thanks Jon
Very easy to understand. Thx
Loving your channel :)
Very slick trick! Uses pivot table features I am already using, but did not "put together" for something like this!
+Sharon Henderson Thanks Sharon!
Wow thank you so much your videos are more explanatory
You are welcome! 😀
Brilliant! An elegant workaround!
very helpful video....thanks for sharing
Clever and very resourceful. Thanks for sharing!
Thanks for the tip Jon. Keep it up
Cool trick Jon! Thanks!
i love your tutorial which is so helpful. how do I apply on the dashboard page
Very clever trick. Thanks for sharing your knowledge and expertise Jon
really nice tip Jpn - thanks a lot - user experience enhanced for sure.
Thank you! Excellent
super trick...hat's off to you Jon.
I enjoy, and find it very easy to follow your instructions. Thank you for your time and work.
Going out of the box with slicers - I love it!
+Jackie O'Neil Haha! Thanks Jackie! :-)
Brilliant. Many thanks, this will make an impact at work
Thanks Sarah! ;-)
Excellent video! Thank you
This cleaver way sir, thanks for sharing
It is really great and helpful thanks
Nazir Ahmad lone
From Kashmir
thats just one thing: Brilliant! Chapeau!!!
This is a good idea. Since slicers don't automatically jump to the selected person, I would add to a linked cell, probably as a title, showing the name of the person selected.
Thank you Jon!!!!
Your !dea was excellent !!.. hope this is one of the corrections or value additions in the upcoming versions of excel. Thanks!..
This was sooooooooo good!
Thank you very much!
That is so easy....but obviously we never thought of it...thank you
I'm forget the searching system in excel pivot table, your this tutorial help to remind me for setup again this function. Thanks a lot dear.❤❤❤
You are welcome! 😀
outstanding trick - I'm new to slicers and this is great
Thank you! It works :)
You're welcome, @liubovlatyntseva384! 😀
very easy and useful trick
Excellent!
Wonderful !!!
Very cool trick, thanks
Awesome. This helps a ton on my dashboard!
Awesome!!! Thank you very much for such outstanding and useful trick.
Brilliant!
That was ingenious.
hi thanks alot really helpfull
can you help me with something,
i need to lock the filter on the slicer so that specific employees can see only their own filters or there own area of expertise.
is there any way to do so?
I enjoyed watching this video and recommend others.
Thanks for educating the community and appreciate your volunteer ship in teaching.
My question is
You have the filter ()Red X mark in Slicer and why can't we use that?
Thanks a bunch
Can we make a dashboard by collecting data from different sheets?
Do you have any video on this?
Thanks
Great tip, thank you very much.
This is fantastic. Thank you for making an easy to follow video. The only issue that I'm having is that I can't move the filter cells as you show at the 3:27 mark. The filters automatically show at the top of the worksheet and can't be moved. Please let me know how to change it, so I can move the filter to where we need it in the worksheet. Thank you.
Very nice Jon. Though the size of the second pivot table selection field resizes based on the text length. Maybe maintain table formatting is needed?
Question - is there a way to select a filtered set of data and copy it to the clipboard and then paste it into a predefined "table" and have the table automatically expand to the lines being copied?
Hi Larry,
Yes, there is an option in the Pivot Table Options menu to Autofit Column Widths on Update. You can uncheck the box to turn it off.
In regards to your question, you can use an Excel table for this. Here is a video on Excel Tables. ua-cam.com/video/fJnJTff4Na8/v-deo.html
Very interesting as always. Thank you for sharing Jon.
Amazing video, easy to understand! :)
Great Brother
simple and easy to achieve, but first had to think about that !
Hi. thanks for the useful tip. Do you have any video on how to count entries from a particular slicer list?
Brilliant trick, thanks!
very nice hack. thank you.
Thanks a lots, great video
You are welcome! 😀
very good vedio thank you!
Clever and easy, thanks!
Nice method for filtering multiple items in a slicer. Is there a similar method for filtering a group of numbers with a slicer? Like all records in a pivot table where the ID number is greater than 10000?
Thanks 🙏
Hello,
Thanks for putting up these great video! How would I get a pivot table row to be hyperlinked to another pivot table that has more detailed info about the row selected. So for example if I have a pivot table four projects, and if I click on project 1, I want to be taken another page that would have detailed info regarding that project 1. The detailed page would also be a pivot table, or developed from a macro that reads from the same date source. Hopefully I am making sense. Thanks in advance.
Thanks. Its very helpful.
Thanks, it worked perfectly
Dude! Brilliant!
I love it! Thanks!
Great job.. thanks for your help
But my question.. can i add same field in row and filter same pivot table?