Slicer and Timeline are just more interactive filters. We can show the pivot of filtered data by clicking on them. Clicking on PivotTable shows the PivotTable TOOLS tab. There you have to click on the Insert Slicer. It will show a …
Lesson#65: Inserting Slicer and Timeline in PIvottable Read more →
PivotTable has very powerful features to analyze data. One of them is PivotChart. PivotChart is a different feature of Pivot Tools to represent the PivotTable data with the chart. Here I am having a practice with the employee database and …
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more →