How to get current date and time in your excel sheet?

To get current date

Step: Use function =TODAY()

To get current date and time

Step: Use function =NOW()

How to use Slicer for effective filtering of Pivot Data in MS Excel?

About Slicers in MS Excel

Slicers provide buttons that you can click to filter PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report.

Step 1: To get the Slicer option you have to go the "Insert" Ribbon's "Filter" tool. There you will have two options 1) Slicer and 2) Timelines.

Step 2: Create you pivot table and then click Slicer. You will get the Slicer selection list.



Step 3: Select the Year and Margin or all three. You will get the slicer of your pivot table. 

 

How to remove unnecessary spaces between two words in MS Excel?

How to change text from Proper Case to Upper Case and Vice Versa. Also from Upper Case to Lower Case in MS Excel?

How to pull the First Name from a List of Name and Surname in MS Excel