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 […]

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. […]

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 […]

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 […]