Thanks Mynda I appreciate your clear instructions and patient manner. You remove the mystery of learning to use unfamiliar tools.
@MyOnlineTrainingHub
2 жыл бұрын
Glad I can help 😊
@danesikasim1591
2 жыл бұрын
I have gone through many of the tutorial videos, they are wonderful, interesting and educative. I am very inspired to know you have put more energy and time to create and share knowledge generously. Thank you and remain bless as you continues to upgrade many.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your kind words, Danesi!
@steveterry9736
7 жыл бұрын
How interesting that your email came in this morning. I was pondering (with my limited excel skillsets) how to view a mass of construction project management data to better filter and isolate, and here comes your video showing tools sitting there in my 2016 Excel. But without your clear and crisp presentation, I would have struggled to work with this new tool. Now I have easily deployed it, and we are working on a dashboard cover for strategic planning that will blow the other departments out the back door! Thanks Mynda for generously sharing your knowledge!!!
@MyOnlineTrainingHub
7 жыл бұрын
My pleasure, Steve. I love hearing success stories like yours. Congratulations, I hope you blow them away with your Excel mastery :-)
@sizwemchunu6110
Жыл бұрын
for the longest of time, I've been applying the same filters to different Pivots. This has helped me a lot.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@beabeeeee
Жыл бұрын
so Complete and easy to understand explanations, I almost tear up 😭 I've been struggling with pivot table all days for the past 2 days, literally struggling from the moment when I wake up to like 2-3 AM... I don't know, it's so hard to understand it. But your video shed some lights. and your voice is calming, and your words makes it easy to understand, you also always added useful information when explaining which I appreciate a lot. The information adds up useful knowledge that I can implement on the future chance. I'm currently interning in a consultant firm, and we have been making this dashboard for 3 weeks. I can't tell you enough how happy and relief I am to come across this very video. thankyou!
@MyOnlineTrainingHub
Жыл бұрын
Aw, that's so lovely to hear, Bea. I'm glad I could help. If you get stuck in the future, you can also post your question and sample Excel file on our forum where we can help you: www.myonlinetraininghub.com/excel-forum
@uzenoff
Жыл бұрын
Thank you Mynda! OMG, I've been shoe horning information into Access and struggling to get out reports in Access and for my purposes. Slicers are the perfect alternative. I wish I had known about them before, but, thanks to your video, will be using them more and more going forward.
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful! Better late than never 😉
@sureshbnegi
6 жыл бұрын
What a skill!... the way you present the elements in your videos or sessions is tremendous.. Thanks a lot for the learning which you are sharing with everyone.. God bless you..
@MyOnlineTrainingHub
6 жыл бұрын
Thanks for your kind words, Suresh. I'm so pleased you find the videos helpful.
@mtstans
2 жыл бұрын
Thanks for this! Always been afraid to mess with these. I don't know why. Having fun playing with these today
@MyOnlineTrainingHub
2 жыл бұрын
Great to hear 😊
@jorgeflores1045
3 жыл бұрын
This quick training was on the spot. Thank you for the learnings
@MyOnlineTrainingHub
3 жыл бұрын
Very welcome, Jorge :-)
@StopWhining491
Жыл бұрын
Thanks for letting us know what version of Excel this applies to.
@MyOnlineTrainingHub
Жыл бұрын
Glad to help!
@terrellnash4648
11 ай бұрын
Amazing videos! Your experience with Excel is very broad and deep.
@MyOnlineTrainingHub
11 ай бұрын
Glad you like them! 🙏😊
@kokalody1982
2 жыл бұрын
Thank you for this amazing video. Instructions are crystal clear. I will start my dashboard this week and will follow up with your other tutorials.. Such generosity of you to share all of this knowledge. Thank you so much 🌷🌷
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your kind words 🙏
@anilk9315
3 жыл бұрын
You just amaze me ...you make it look so simple and easy to understand. God bless you
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much 😊
@aquayum72
Жыл бұрын
Fantastic Video with very useful tips and tricks for us Excel Enthusiasts! Keep it up!
@MyOnlineTrainingHub
Жыл бұрын
Thanks, will do!
@LordBransty
7 ай бұрын
I've watched a few of your videos. This is my favourite. Thank you!
@MyOnlineTrainingHub
7 ай бұрын
Wow, thank you!
@kagundateddy2023
Ай бұрын
Thank you...from Kenya
@MyOnlineTrainingHub
Ай бұрын
You are so welcome 😊
@rajkuma2008
3 жыл бұрын
thank u very much..i wish i could keep on liking u r videos...they r that good and i thank u from the bottom of my heart....
@MyOnlineTrainingHub
3 жыл бұрын
So nice of you, Raj!
@ijustretired
3 жыл бұрын
Thank you for showing this to everyone, it was easy to understand, and clear
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Johann!
@MySpreadsheetLab
7 жыл бұрын
Thanks for the slicer video Mynda! They are amazing!
@MyOnlineTrainingHub
7 жыл бұрын
Glad you liked it, Kevin. Slicers are indeed, amazing :-)
@matthewstock9946
6 жыл бұрын
You were right, how did I not have slicers before now! Thank you
@MyOnlineTrainingHub
6 жыл бұрын
:-) glad you'll find them useful, Matthew.
@mdp7608
4 жыл бұрын
One of my favourite channels.
@mohammedtaharhadjoudj8860
Жыл бұрын
extremely useful course, I learned a lot of new techniques, really looking forward to putting into practice, thank you for the excellent training session.
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@AR-rs2dy
4 жыл бұрын
Great videos Mynda. Sliders are fairly basic but good to know how to link to more than one PT and also didn't know they could be used for tables.
@MyOnlineTrainingHub
4 жыл бұрын
Glad it was helpful!
@DrK99999
2 жыл бұрын
Nailed all basics of slicer succinctly👌✌👍
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it :-)
@chaddlesmcmaddles
5 жыл бұрын
I subscribed last week after watching one of your dash board tutorials 👍👍👍
@Jahspecs1
2 жыл бұрын
Excellent video, you forgot to mention how to reader from the slicer any slicer selections
@ajaykaushik7561
Жыл бұрын
hi mam ! great fan of your work . Thank you for your guidence .
@MyOnlineTrainingHub
Жыл бұрын
It's my pleasure 🙏
@Henrik.Vestergaard
Жыл бұрын
Wonderfull video. I use slicers with a datamodel a lot. Sometimes it causes issues when connecting multiple slicers to multiple pivot table. Eg an issue, where slicers stop filtering each other, allthough the slicer column fields belong to the same table in the model. Remove one of the pivot connections, and they - supprisingly - filter each other again. Would be great if you had a similar video on slicers in a data model contex 😊
@MyOnlineTrainingHub
Жыл бұрын
Thank you and thanks for sharing that workaround. I've not experience that problem before, so good to know.
@adityaghose4908
6 жыл бұрын
Excellent Presentation, taught me a lot in a very short time. Thanks a ton!
@MyOnlineTrainingHub
6 жыл бұрын
Thanks, Aditya :-) Have fun with Slicers.
@lawrencempiima7999
Жыл бұрын
I like ur trainings
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@sultzjazz5769
4 жыл бұрын
Thank you। so much for your helpful tips. It really helped me to fix an issue I was struggling with for hours
@MyOnlineTrainingHub
4 жыл бұрын
Wonderful to hear I could help.
@iankr
3 жыл бұрын
This is brilliant! Many thanks, Mynda.
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure, Ian!
@linhtranvan7356
7 ай бұрын
thank you
@MyOnlineTrainingHub
7 ай бұрын
You're welcome 😊
@howard2899
4 жыл бұрын
You are awesome! Thanks for sharing your excel file. It’s such a great help!
@OSGCourtWatch
3 жыл бұрын
Outstanding
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much!
@slightlyarrogant
3 жыл бұрын
Very clear and concise!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you think so!
@naseemzain1523
Жыл бұрын
Awesome Tutorials.. Thank you
@MyOnlineTrainingHub
Жыл бұрын
Glad you like them!
@windsorlewis3344
Жыл бұрын
Oh wow!
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked it 😊
@johnatanramos7736
7 жыл бұрын
Just in love with your tips and teachings!
@MyOnlineTrainingHub
7 жыл бұрын
Thank you, Johnatan! :-)
@reng7777
4 жыл бұрын
You are a Pro my friend!!!
@MyOnlineTrainingHub
4 жыл бұрын
Cheers, Rene :-)
@EduardKorkia
4 жыл бұрын
Brilliant ! I love you! Thank you very much!
@MyOnlineTrainingHub
4 жыл бұрын
Happy to help, Eduard :-)
@RossMaynardProcessExcellence
3 жыл бұрын
Excellent video. Clear and straightforward. Also "contiguous" is my word of the day now - it feels so good in the mouth! Question: can you get slicers to work with the new functions in Office365, for example to select the column to sort in SORT. It probably requires other functions in the background. It might be fun although I am not sure why you would need it!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Ross! Yes, I'm sure with a clever hack you can get the Slicer to control the sort order. This might give you some ideas: www.myonlinetraininghub.com/use-excel-slicer-selection-in-formulas
@RossMaynardProcessExcellence
3 жыл бұрын
@@MyOnlineTrainingHub Clever! Thank you.
@mghayadar
3 жыл бұрын
Thank you. It is really helpful.
@MyOnlineTrainingHub
3 жыл бұрын
Glad to hear that!
@Kursatural
Жыл бұрын
Thank you so much!
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@bw5187
Жыл бұрын
I love you.
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked my video!
@CarlosSanchezLemus
7 жыл бұрын
Great help, thank you Mynda. Regards.
@MyOnlineTrainingHub
7 жыл бұрын
You're welcome, Carlos :-)
@seamushand8439
2 жыл бұрын
Thank you Mynda - i could not figure out why pvtTables i had were not appearing on the Report Connection
@MyOnlineTrainingHub
2 жыл бұрын
Glad I could help, Seamus 😊
@travelwithwings9674
3 жыл бұрын
Very nice.. thank you so much for this
@MyOnlineTrainingHub
3 жыл бұрын
Most welcome 😊
@cozykitchen9728
Жыл бұрын
Great help!
@MyOnlineTrainingHub
Жыл бұрын
Glad to hear it.
@sowmyakrishnappa
4 ай бұрын
You are awesome. Thank you :-)
@MyOnlineTrainingHub
4 ай бұрын
Glad you found my video helpful 😊🙏
@TiagrajI
3 жыл бұрын
Thank you so much for your videos
@MyOnlineTrainingHub
3 жыл бұрын
Glad you like them!
@TiagrajI
3 жыл бұрын
@@MyOnlineTrainingHub They are highly useful and to the point. Love your channel. 👌🏾
@1877Pegasus
5 жыл бұрын
Awesone explanation!
@cristinamorera1070
6 жыл бұрын
Thanks for sharing. It’s great as al your videos.
@MyOnlineTrainingHub
6 жыл бұрын
Thanks for your kind words, Cristina :-)
@divergenshok7797
2 жыл бұрын
Great
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it 😊
@Seftehandle
3 жыл бұрын
Timeless video
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much 😊
@sohaybemad623
16 күн бұрын
Thank you, I got this problem of pivot tables that doesn't show in the report connection, but i did not understand when you said copy the pivot table and modify it, Can you explain please!?
@MyOnlineTrainingHub
16 күн бұрын
Slicers can only link to PivotTables that share the same source data and pivot cache. To be certain they are using the same source data and pivot cache, copy the first PivotTable and then modify it as required. You will then see it in the report connections list.
@kiridhruv
6 жыл бұрын
Very informative :) Thank you! 🙏
@MyOnlineTrainingHub
6 жыл бұрын
You're welcome :-)
@stuartrisebrow5536
2 жыл бұрын
I just love your tutorials. Question. When slicing is there a way to keep row categories with no data that are filtered out? For example if the are sales for 5 products for 3 shops and one shop only sold 3 product types, the other two would still show but as nil sales. I have one unfiltered chart with 8 columns but it filters to one column at times and looks rubbish.
@MyOnlineTrainingHub
2 жыл бұрын
Hi Stuart, Try right-clicking on the field > Field Settings > Show Items with No Values.
@stuartrisebrow5536
2 жыл бұрын
@@MyOnlineTrainingHub brilliant. Thank you!
@Luciano_mp
6 жыл бұрын
Muito boa a sua aula, parabéns e obrigado.
@MyOnlineTrainingHub
6 жыл бұрын
Obrigado, Luciano :-)
@jibontabedona4772
3 жыл бұрын
Good
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it 😊
@shoppersdream
6 ай бұрын
Very Nice, thanks! You didn't create any videos on TimeLine. How do you make Timeline Immovable? Thanks
@MyOnlineTrainingHub
6 ай бұрын
You can't make the timeline immovable!
@shoppersdream
6 ай бұрын
@@MyOnlineTrainingHub Thanks! You're so smart. Please find a way to make them immovable. I need to send my file to another Group and I don't want them to move my Timeline wherever they want.
@MyOnlineTrainingHub
5 ай бұрын
It's not possible, unfortunately. It's just the way it was designed. You would have to use Slicers instead.
@lawrencempiima7999
Жыл бұрын
Do you have teams or what's up Am enjoying ur training I have a change
@MyOnlineTrainingHub
Жыл бұрын
If you have Excel help questions, you can post them in our forum: www.myonlinetraininghub.com/excel-forum
@ahmedsaad7870
4 жыл бұрын
thanks and keep going
@MyOnlineTrainingHub
4 жыл бұрын
Will do, Ahmed :-)
@jessicaperez5946
Жыл бұрын
Thank you for the video, however my issue is my raw data changes weekly. Therefore, how can I update all my pivot tables while using slicers because I always get the following error message. The PivotTable filed name is not valid.
@MyOnlineTrainingHub
Жыл бұрын
If your column names remain the same then you just replace the rows of data below them in your source data table. If the column names change then I’d say your data is in the wrong layout. It should be in a tabular format: www.myonlinetraininghub.com/excel-tabular-data-format
@jamiereife5581
16 күн бұрын
Hi Tracy, I make my dashboards for my colleagues and sometimes they accidentally move the slicers (and the charts). Is it possible to clock these items in place so that they do not disturb the arrangement and look of the dashboard?
@MyOnlineTrainingHub
15 күн бұрын
Please see this tutorial: www.myonlinetraininghub.com/excel-workbook-protection
@michaelsiggers4109
Жыл бұрын
Hi Great Videos and very informative. I'm struggling with creating a Slicer to Filter two pivot tables. I've been trying everything this morning. I can create a slicer to work on one Pivot Table, but I can not make it work with one Slicer. I have checked relationships, the froantbif the date in the two tables but am absolutely stuck. I've followed numerous videos but am stuck with a Slicer that does nothing. Please please help. Mike
@MyOnlineTrainingHub
Жыл бұрын
Thanks, Mike! It's hard to diagnose the problem without seeing your file or at least screenshots. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@michaelsiggers4109
Жыл бұрын
@@MyOnlineTrainingHub Hi. Many thanks for the quick reply, and apologies for my late reply. Unfortunately I can not share the file as it is confidential, but the good news is I managed to get it to work. I had to enter a Field into the 'Values' area of the Pivot Table, even though I did not want to. The Tables and the subsequent Pivot Tables are being used to track a series of requirements/tasks for a Construction Project. The Pivot Tables are being used to collate all the information from the various Tables to highlight which tasks have not been completed. As such, there are no 'Values' in the sense of figures/currency/numbers, so I did not place a Field in this area. I have got around it by placing a Measure I created in the 'Values' area to indicate whether it is complete or not. Again, I didn't really want to do that, as the idea is using the Single Slicer to be able to Filter and show all Tasks which are not complete on the Dashboard Sheet. The annoying thing is, that if I use a Single Slicer on a single Pivot Table, it works as planned without the additional measure. Hope that makes sense. Mike
@shakiraasfoor7599
4 жыл бұрын
Well Done
@rafhuss6347
5 жыл бұрын
excellent content
@MyOnlineTrainingHub
5 жыл бұрын
Thanks, Ruphy :-)
@geeteshshangari740
3 жыл бұрын
Can you share some specific videos for data modelling and power pivot ?
@MyOnlineTrainingHub
3 жыл бұрын
Will keep it in mind.
@iankr
3 жыл бұрын
Thanks!
@MyOnlineTrainingHub
3 жыл бұрын
My pleasure, Ian!
@iankr
3 жыл бұрын
@@MyOnlineTrainingHub I commented recently on one of your other videos that I didn't like pivot tables. But I've started using them since then, on your recommendation, and I'm getting into them. Now that I've seen slicers in action, I will investigate these, too.
@MyOnlineTrainingHub
3 жыл бұрын
Great to hear, Ian!
@avenewconsulting1118
3 жыл бұрын
thank you for your work, i appreciate your videos :)for me the connexion button is not selected?you should also make a video only for the cash pivot table because it s complicate concept.Can you please show how you create sub categories? why should we use the slicer if there is already a filter in the table please?
@MyOnlineTrainingHub
3 жыл бұрын
Glad it was helpful. The slicer is just easier and more intuitive to use than the filter drop down.
@avenewconsulting1118
3 жыл бұрын
@@MyOnlineTrainingHub Can you te'll me why the connexion button is not highlighted?
@salmanayub795
2 жыл бұрын
Thanks for sharing all this, can we add search bar in slicer in order to find specific item in bulk data.
@MyOnlineTrainingHub
2 жыл бұрын
Hi Salman, there's no search functionality in a Slicer. If you have a long list of items then I recommend this technique instead, which is searchable: www.myonlinetraininghub.com/searchable-drop-down-list-in-excel Link this searchable list PivotTable to a Slicer that is linked to all the other PivotTables you want to filter. When you make a selection in the filter they will flow through to the Slicer and your other PivotTables and Pivot Charts that are linked to the Slicer. Hope that makes sense. If you get stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@salmanayub795
2 жыл бұрын
@@MyOnlineTrainingHub THANKS ALOT
@tommyk4623
Жыл бұрын
Possible to add table (not pivot table) slicer in Excel online? I haven't been able to find a way to do it, so I create them in the desktop app but this is an issue since our company uses a document storage tool which makes downloading and uploading an Excel file a hassle (people only use Excel for the web).
@MyOnlineTrainingHub
Жыл бұрын
Not yet.
@becar67
3 жыл бұрын
Amazing tutorial. Many thanks. Can you please tell me how did you get Year filed in as the Slicer. I can't see any columns with that Name. Many thanks.
@MyOnlineTrainingHub
3 жыл бұрын
The Year field is automatically created when you group dates in the PivotTable.
@hazemali382
4 жыл бұрын
more than great
@alfasementeiralimitadaango1673
3 жыл бұрын
Dear Mynda please advise what is the correct way to create an activity planning tool in excel. Have a list of Strategies with multiple projects each with multiple activities and each activity with list of indicators that a planner could pick from. Tried to use slicers but with no sucess. Would like to automate the anual planning process. Thank you.
@MyOnlineTrainingHub
3 жыл бұрын
Sounds like you need some Excel consulting. Please get in touch via email: website at MyOnlineTrainingHub.com and we'll put you in touch with someone who can help.
@dumaoctavian5564
Жыл бұрын
Wandeering if i can get support with a situattion. So i have 2 data tables, made 2 separate pivot tables for these. When i create a slicer, it only affects one of these pivot tables or the other, when i open the report connectuions tab (8:20) it only dispalays the current pivot table, cannot check the other as it does not appear...
@MyOnlineTrainingHub
Жыл бұрын
This happens when you have created the PivotTables from different data sources, or when you have inadvertently created a separate Pivot Cache for the second PivotTable. More on the Pivot cache here: kzitem.info/news/bejne/1n-mtKifcomKmII
@mokhot
2 жыл бұрын
Thats great. Thank you. How do you incorporate a pie chart and graphs with slicer
@MyOnlineTrainingHub
2 жыл бұрын
My pleasure! Create a pie chart from a PivotTable and then connect the Slicer to the PivotTable.
@arturoguzman5230
3 жыл бұрын
Super! 😍
@MyOnlineTrainingHub
3 жыл бұрын
Thank you!
@nzanezensei2328
Жыл бұрын
Can you connect a slicer to both table and pivot table??
@MyOnlineTrainingHub
Жыл бұрын
No. Only one Table, or to multiple PivotTables.
@JuanPerez-hb5kb
3 жыл бұрын
Awesome video, I can't seem slice my data correctly. When I copy a slicer to another tab to try to manipulate the data on the second tab, it doesn't work, please advise
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Juan! Sounds like you haven't connected the Slicer to the PivotTable on the second tab as shown in the video. If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@JhunCanlas-vx8pb
Жыл бұрын
having problem connecting slicer, other pivot did not appear selection whenever i right click the slicer only 1 pivot appear.
@MyOnlineTrainingHub
Жыл бұрын
I explain the cause of that problem and how to fix it at the 9:11 mark in the video.
@KNLP23
6 жыл бұрын
This is brill!
@MyOnlineTrainingHub
6 жыл бұрын
Glad you liked, it, Kana. Slicers are one of my favourite tools :-)
@gauravmittal8153
2 жыл бұрын
😀
@MyOnlineTrainingHub
2 жыл бұрын
😊
@arwhyncarlcruz7874
Жыл бұрын
Hi guyz! can you assign different colors on ear year on slicer? example, the color button for 2020 is red, while 2021 is blue. is this possible?
@MyOnlineTrainingHub
Жыл бұрын
Nope, sorry.
@weed62289
4 жыл бұрын
Very informative channel and videos! Thank you for sharing. One quick question - I have a dual axis chart but when I use the linked slicer to filter, the dual axis disappears. Any idea what the cause is or what the fix might be?
@MyOnlineTrainingHub
4 жыл бұрын
Hi Tyler, I've not see a dual axis disappear before. Typically a Pivot Chart will lose formatting if the items selected in the Slicer result in series dropping out of the chart, so I wonder if this is the issue. If you can post your question and share your file on our Excel forum (www.myonlinetraininghub.com/excel-forum) I can try to help further. Mynda
@jvamesquita2011
Жыл бұрын
Hello! Is it possible to connect a table and a pivot table to the same slicer?
@MyOnlineTrainingHub
Жыл бұрын
No.
@jvamesquita2011
Жыл бұрын
@@MyOnlineTrainingHub thx for the reply! Sad tho 😞
@patriks.7815
2 жыл бұрын
I have the problem that the other slicers do not refresh if I filter from another slicer. Eg I have 2 Slicers. Continent and States. If I Filter only America, the States slicer still shows Countrys from Europe, Asia, Africa and so on. I tried all the different settings but it still does not work. Any Idea why this might happen?
@MyOnlineTrainingHub
2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@emiliaalejandrakuschnir5199
2 жыл бұрын
I'm looking for an option to hide/unhide slicer according to currency cell values. I also want to disable the slicer when the sheet is locked. Does this option exist or did I exaggerate this time? :)))
@MyOnlineTrainingHub
2 жыл бұрын
There's no option to hide or unhide a Slicer, but you can lock it when the sheet is protected.
@emiliaalejandrakuschnir5199
2 жыл бұрын
@@MyOnlineTrainingHub sorry, I meant I want a slider that hide/unhide cells values in certain columns. and the slider to be disabled when sheet is locked
@MyOnlineTrainingHub
2 жыл бұрын
That's not the functionality of Slicers. You'd need to use a form control and VBA to program the button.
@tanyasimmons70
5 жыл бұрын
I have just discovered slicers via your youtube videos and I am loving them...However, I am finding that some of the options you show are not currently showing in my menu (the one you get when you right click) I am not able to group my data or check the report connections. I do not know if this is because I am using an excel template that was premade or if I simply need to go in and add something...any ideas? I plan on watching all you videos but I think this is pretty basic and doesn't have a video. I am eager to learn more about using slicers to sort my data, which is more related to staff training and not cost/revenue.
@MyOnlineTrainingHub
5 жыл бұрын
Hi Tanya, Slicers can only group numeric data. Likewise, Excel dates should be entered in their date serial number format. If they are entered as text then they cannot be grouped in the PivotTable and you'll get the error 'cannot group that data'. If your data is in Power Pivot then you may also get that error in earlier versions of Excel (pre Excel 2013 from memory). Please post further questions in our Excel forum where we can troubleshoot and share images and files: www.myonlinetraininghub.com/excel-forum
@JohnnyjayV
Жыл бұрын
I have a multi sheet pivot table/chart and am having issues with renaming the slicer buttons, even using the custom lists under the advanced options. I want the buttons to be labeled the same as the sheet name. Is there a way to do this?
@MyOnlineTrainingHub
Жыл бұрын
The slicer buttons are populated from the items in the source data. If you want different button names, you need to change the names in the source data.
@JohnnyjayV
Жыл бұрын
@@MyOnlineTrainingHub I’ll check it out. Thank you so much.
@edwardchau5818
3 жыл бұрын
What's the difference, if any, between slicer and filter in the pivot table?
@MyOnlineTrainingHub
3 жыл бұрын
Both filter the PivotTable, the filter has more options for filtering, but the Slicer is more user friendly.
@tanyasimmons70
5 жыл бұрын
Thank you...i think the problem was that my data was in a table but not a pivot table...i noticed you can make a sliver from a table but was not able to group by year or month...do you know if it’s possible to sort that way? I was hoping to be able to filter for year without losing the ability to sort the main table...
@MyOnlineTrainingHub
5 жыл бұрын
Oh ok, yes you can't group data in Tables, only PivotTables. Just put the data in a PivotTable and put every field in the row/column labels to create a PivotTable that contains all of the data from your table. You can also sort PivotTables etc.
@zandramiles
Ай бұрын
what if I want to see by year only view and sometimes I want to see Days per year.. how?
@MyOnlineTrainingHub
Ай бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@DaveSlavens
4 жыл бұрын
Thanks for the Slicer lesson! One question, can I clear all the selected slicers (and reset my table or Pivot table) back to the default view with one click?
@MyOnlineTrainingHub
4 жыл бұрын
If you only have one PivotTable/Table then you can use the Clear Filters button on the Data tab in the 'Sort & Filter' group which is active when the PivotTable or Table is selected.
@DaveSlavens
4 жыл бұрын
@@MyOnlineTrainingHub oh duh, I wasn't even thinking about that button. Thanks!
@kzawtun6875
Жыл бұрын
How do you increase the font size of the slicers?
@MyOnlineTrainingHub
Жыл бұрын
You have to create a custom style and in the formatting options you can set the font size.
@user-ic9be1gp3l
Жыл бұрын
Hi Mynda I have just created my first dashboard using Pivot tables, charts and Slicers (thanks for the great instruction videos). I am using a dark theme for my dashboard and everthing looks good except from the Slicers. I managed to change most parts of the Slicers into grey shades, but the Slider itself remains white. You don't mention the Sliders in your tutorial, is that because it's not possible to change the properties of Sliders? I hope you can help as this would be the final touch on my dashboard ;-)
@MyOnlineTrainingHub
Жыл бұрын
Congratulations! Have you seen my Slicer formatting tutorial: kzitem.info/news/bejne/rHuQ4Huran96jGk
@user-ic9be1gp3l
Жыл бұрын
@@MyOnlineTrainingHub Hi Mynda Thanks for your prompt reply👍 Yes, I've watched both the "Excel Slider, Everything You Need to Know" as well as "Excel Slicer Formatting incl. Hidden Trick.." but I haven't seen anything in those, that could help me formatting the sliders in the Slicers. BR Flemming
@MyOnlineTrainingHub
Жыл бұрын
When you say 'the sliders' I presume you mean the buttons. In which case, you have to format the elements called 'selected item with data', 'selected item with no data' etc.
@user-ic9be1gp3l
Жыл бұрын
@@MyOnlineTrainingHub Hi again No, I mean the slider you can use to scroll the buttons up and down if there are to many to be shown in the same Slicer window (I hope my explanation makes sense? ;-) I don't how to add a screenshot in this reply, which would be much more explanatory. BR Flemming
@MyOnlineTrainingHub
Жыл бұрын
Ah, the scroll bar. Correct, you cannot change the colour of it AFAIK.
@gustavogomez7235
5 жыл бұрын
Hi There, created two slicers beside a pivot table. I went to size and properties then select the box that says disable resizing and moving. For some reason the moving part only works with one with the slicers the other one moves when i hide some of the columns or when i delete some of the blank columns on the left side of the P table. Note i put the slicers on top but i cannot get both to be fixed at the same time. If you have any trick to fix this will be greatly appreciated. thanks
@MyOnlineTrainingHub
5 жыл бұрын
Hi Gustavo, I'm not familiar with this problem, but if you want to post your question on our Excel forum (www.myonlinetraininghub.com/excel-forum) where you can upload your Excel file with the problematic Slicers, we'll take a look.
@lucalenzi9922
3 жыл бұрын
How could I change the header font of the slicer, for example the font size?
@MyOnlineTrainingHub
3 жыл бұрын
You can create your own custom Slicer format as explained here: kzitem.info/news/bejne/rHuQ4Huran96jGk
@wildwolf8172
3 жыл бұрын
I am on a project wherein I want the number shown in a cell if multiple selection in the slicer, can you please help?
@MyOnlineTrainingHub
3 жыл бұрын
You can use the technique described in this video: kzitem.info/news/bejne/tW2Lu5uPh19of6Q
Пікірлер: 238