Tag Archives: Excel

Enhance your Microsoft Excel Pivottables with Pivotchart and slicers

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

Find similar text in Microsoft Excel columns

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