Excel 2010 – Slicer

Microsoft Excel 2010 delivers a new feature called slicer; it allows you to slice-and-dice your pivot table.  In the older versions of Excel, if you want to use pivot table to do an income analysis for BC, Ontario and Quebec; and include disability insurance and long term care products; then you would use report filter to select corresponding items in province and product type.  But report filter does not give you a good visualization, where slicers show you what you have chosen.

alt

Create a slicer in an existing PivotTable – it cannot be easier.

  • Click anywhere in the PivotTable report for which you want to create a slicer.  This displays the PivotTable Tools, adding an Options and a Design tab on the Ribbon.
  • On the Options tab, in the Sort & Filter group, click Insert Slicer.

alt

  • In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.

alt

  • Click OK, then you can use the slicers to choose your provinces and product types.

alt

You know what have been included and what have not been in your pivot table.

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!


About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

2 Responses to Excel 2010 – Slicer

  1. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Slicer | Technologies and your business

  2. Pingback: Is Excel our only option? « Technologies and your business

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: