Tag Archives: excel 2013

Using Timelines in Excel 2013

Inserting a Timeline – a new tool for the Pivot Table What is a Time Line? A timeline in Excel 2013 is a new feature for enhancing Pivot Tables. In the same way as the Slicer tool acts as a visual filter for data, the Time line is a visual filter for dates. It can be used to change the… Read More »

The Slicer Tool in Excel

Using the Slicer Tool for presenting If you use Pivot Tables in your work you will know that they are an excellent resource for presenting large datasets in an easy-to-understand way. I often find myself presenting to groups of people who, in many cases, are not at all familiar with the data I am using. If I glance… Read More »

How to use Flash Fill in Excel 2013

Flash fill Excel 2013 is a new feature that was introduced only in this version. It is a very versatile automatic filling tool that allows you to specify any format for a text field such as a name and automatically apply that format to the rest of the entries in a column. For example, if you have three columns… Read More »