Microsoft Office From novice to tech pro - start learning today. Start learning today for free Move Your Career Forward with certification training in the latest technologies. Get started today Stand Out as the employee with proven skills. Try it for free Edge Out The Competition for your dream job with proven skills and certifications. 8 tips and tricks you should know for Excel 2016 for Mac Get answers and train to solve all your tech problems - anytime, anywhere. Hi Your data is not ideal for a a Pivot table, but i have created the best I can and inserted a Slicer using Windows Excel.Įxperts Exchange Solution brought to you by Your issues matter to us. Thanks, I looked at that video, but my pivot table breaks Also, column B should be driving the slicer. I just did a quick web search, and the the following link shows a video of creating the Slicer via a Pivot Table on the MAC. Is for for Excel on a MAC? Hi I'm sorry, I am not a MAC user at all, but just assumed that the same functionality would exist as the Windows version. With your cursor within the table, you will see a new tab called Design.