Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Slicers (RSS)

Browse by Tags

  • Dressing up your Slicers

    In the last part of this 3 part series on slicers I’ll show you how slicers can be customized many different ways to create stellar looking reports. Previously in this series: Part 1 : Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers Part 2 : Interacting with Slicers Slicers use styles the same way tables and PivotTables do, in light and dark options: The default light style is shown below on the left. In order to use custom font, colors, and borders I can either start from scratch...
    Filed under: ,

  • Interacting with Slicers

    In part 2 of this 3 part series introducing slicers, I’ll show you some of the ways you can interact with slicers. Part 1 can be found here . Slicers reveal where the data is Let’s say I want to slice on my customer data for yesterday, and I only want to see a list of customers with Partial College and Bachelors education levels. As I click on these two tiles to select them, they turn blue. As it turns out, yesterday all my customers were either Partial College or Partial High School. I had no customers...
    Filed under: , ,

  • Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

    Thanks to Karen Cheng for putting together this series on Slicers. New to Excel 2010 are slicers, which are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes. Here’s an example of the same slicer in three different states. You can select one, all, or some countries. A slicer acts like a report filter, so you can hook it up to a PivotTable, PivotChart, or CUBE function to create an interactive report. Shows...
    Filed under: , ,
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.