Do you want to filter out PivotTables and PivotCharts faster and easier by simply selecting the corresponding time period?

We are able to filter our data based on years, days, month or quarters using this new feature named Timeline in Excel13.

First of all we must create a PivotTable. In the image below I have selected the data in order for the PivotTable to be created and then selected the Insert tab and from the left area of the ribbon named Tables I selected the command PivotTables as shown in the image below.

Once the PivotTable command is selected a dialog box named CreatePivotTable appears as shown below asking us where we want the PivotTable to be created: NewWorksheet or ExistingWorksheet. In my example I will be selecting NewWorksheet. Once we have selected where we want the PivotTable to be placed we press the OK button.

A PivotTable can give the total and the count of the data that is stored in a table.

A PivotTable makes our life easier.

A PivotTable! How can we be sure that we have made the most appropriate one?

This is where Excel13 appears, with its new feature named RecommendedPivotTables.

This new feature recommends which PivotTable we can use in our spreadsheet in order to summarize out data.

Let’s see how it works!!!

First of all we must select our data in the spreadsheet or just click in one cell that contains data and we want to represent them with a PivotTable. Then we must select the tab Insert and from the left area of the ribbon named Tables we select the command RecommendedPivotTables as we can see in the image below.

In all previous versions of Word, the procedure of placing an object in our document was a little bit frustrating. We all have probably used the WrapText function in order to place and adjust the object with our text. Now, in Word13, a simple click on the object reveals everything that is needed with the LayoutOptions on the top right of the object.

Once the objected is selected by simply clicking on it, the Layout Options icon appears at the top right of the object as shown below.