Slicers in Excel

Before listening to the next lecture, I wanted to learn more about ‘Slicers’. It was a new term and concept for me. I did some online research as to what are slicers and why to use them in excel report and I came across this great article ‘Use slicers to filter PivotTable data‘. Through the online… Continue reading Slicers in Excel

Continue reading

Charting in Pivot Tables

In this post, I am going to show how to insert charts using pivot tables. Chart types are the same as I discussed in my earlier posts but the nature and functionality of pivot charts are different and more useful in data analysis context. Pivot tables, charts, and slices altogether help in creating dashboards in excel. In earlier… Continue reading Charting in Pivot Tables

Continue reading