Thursday, 17 July 2014

Slicers to Tables


Do you know that now slicers can be created even with tables.

What is a slicer, in a group of data if you want slice and see a filtered data, you use slicer.

How to use
a)      Create a data Sample
b)      Make that as a table
c)      You will find it in Insert Tab > Table



d)      After the table is done(ensure headers are there)


e)      Place the cursor on the Table and insert slicer(see at the last of the image), select the required fields


f)       You will now be able to slice and see the information.

No comments:

Post a Comment