In the past three articles in this series, we created a Pivot Table based on file extension and date information, added a Pivot Chart and a slicer. Slicers can be very useful to filter the presentation and focus the charts and tables. An example of a slicer is on the right. However, If this approach to interactivity looks a little…well, wordy, […]

Read more

Creating a Pivot Charts In the previous two articles in this series, we looked at creating a Pivot Table in Microsoft Excel based on textual data such as the file extension or author name, and investigating date information. At the end of the second article, we created a PivotTable, grouped by year, quarter and month. In this article, I’m going to […]

Read more

Introduction It may be that you are interested in the history of your files. Or it could be that you have received a few (thousand) files from a client or third party, and you want to see what sort of information you have available. It can be important. In one job I received three CDs full of correspondence in jpeg […]

Read more

When we receive a new source of data, it can be important to get a handle on it as soon as possible. So much time can be wasted, opening various folders in Windows Explorer, only to not have a permanent record of what you have discovered. The easiest way to start is to create a new catalog using any of […]

Read more

Introduction This is a series of articles about filtering, which is the temporary removal of rows you don’t want to see, so that you can see those rows which contain data you specify. Previous articles talked about setting up a filter, and then filtering a text column. This article will investigate filtering a date column, and finally filtering on colors. […]

Read more

Introduction The previous article talked about setting up filters in your spreadsheet, and other articles talk about copying the list into a spreadsheet workbook. However, if you are cataloguing files using Filecats Standard or Filecats Professional, you don’t need to do this – the filters are automatically set up. Now that you have the filters set up, this article answers […]

Read more

Introduction One of the first things to do when you receive data, be it information in a spreadsheet form or 10,000 files on a hard drive, is to understand the range of data that you have got. This is fairly difficult when information is received on a USB memory stick or similar, because you generally have no idea how the […]

Read more