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 »

Working with pivot tables

In this post, I am going to show how easy it is to analyze the data using pivot tables as compare to applying functions and other excel operations. I was so excited to know more about pivots and the properties associated with it. Learning from the next lecture and then doing the lab and quiz after that was… Continue reading Working with pivot tables

Continue reading »