Disappointingly, neither Slicers, a more interactive form of filter, nor PivotCharts, which let you switch around data in charts, have made it from Excel 2010 for Windows into the Mac version.Ĭonditional Formatting, another useful way to represent data visually, is now much more flexible: you can have any number of criteria instead of just the three possible under previous Excel versions.