Excel 2010: Templates in Back Stage -> Front Stage for a regular user

Back Stage offers amazing functionalities for a regular user. Here we will discuss the templates available in the back stage; which will be helpful for a regular user.


Templates
Back stage provides a variety of templates ranging from Normal timesheet to Budgets. Also it provides sample templates with pre-populated data, which will be helpful for those who are preparing trainings.




One of the common scenarios is that people want to prepare rent receipt or any other receipt. Instead of learning the excel features end to end, he can choose one of the receipts templates provided by the Excel back stage.








I chose the donation receipt










Our receipt is ready with professional formats and functionality.

Excel 2010 : Slicer - New Filtering Technology

Today we will look into one of the new feature of Excel 2010 - Slicer.
Slicer is helpful to drill-down and analyze the data. Let us see how it will work.

Open the sales report.


Pivot table gives the in-built filter option and grouping too. Slicer is adding more drill-down options.
Insert the slicer from Insert -> Slicer.





You will get the option to select the column in which the drill-down needs to be done. Select the required field or fields; this will add one slicer per field. I am selecting two fields Product and Customer.





We can do the drill down by using one slicer or using both slicers.