Excel Slicers, Inside Out - includes workbook with step by step instructions - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Stuart
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.
reply
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.
reply
Ross
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!
reply
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!
reply
Alfa
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.
reply
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.
reply
Avenew
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?
reply
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?
reply
Danesi
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.
reply
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.
reply
Emilia
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? :)))
reply
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? :)))
reply
Juan
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
reply
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
reply
Dave
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?
reply
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?
reply
becar67
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.
reply
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.
reply
coco
How do I get my pivot table in a fiscal year format April 2019 thru March 2020 and have my dashboard data and pivot tables pullling fiscal year data ..
reply
How do I get my pivot table in a fiscal year format April 2019 thru March 2020 and have my dashboard data and pivot tables pullling fiscal year data ..
reply
Add a review, comment
Other channel videos
