Slicers are NOT available in 2011 for Mac. The workaround is to use the Excel WebApp, which is available to all users for free on OneDrive (formerly SkyDrive). Excel 2011 is the latest version for Mac at this point.

As I mention in my post on creating pivot charts, you can’t create pivot charts in Excel for the Mac. It’s, hands down, my greatest aggravation with Excel. Bar none. However, Excel for the Mac has an additional bug that renders any pivot chart created on a PC that includes a report filter utterly useless. You can see the options in the drop-down filter and even select them. In fact, the pivot table (that’s created with every pivot chart) updates. However, your pivot chart will not update. I demonstrate this disappointing failure in this short demo.

Test For Yourself

Don’t believe me, Excel for Mac users? Go ahead and test it for yourself with the pivot chart in this Excel file.

Learn More

If you want to learn more about data visualizations that don’t suck, check out my Annielytics Dashboard Course offerings.

Sign in expired in onenote for mac. Image from troll.me.