Blogs from Wise Owl on Tables, pivot tables in Excel

The new Excel data types will make a big difference to your life

Posted by Andy Brown on 22 December 2020

Soon you will be able to display information from almost any common dataset in your Excel worksheets automatically. For now your access will probably be limited to stocks and geographical data, but many more data types (including your own custom ones) should be available soon.

How to create multiple worksheets based on pivot table report filter values

Posted by Andy Brown on 08 December 2017

Did you know that you can automatically generate multiple versions of a pivot table, with each one configured to filter by a different item? We didn't - this blog is an attempt to apologise for our oversight!

How to get row labels for a pivot table group to repeat

Posted by Andy Brown on 01 November 2013

A short blog showing how to stop Excel hiding duplicate values for pivot table groups.

How to Remove Duplicates from a List in Microsoft Excel

Posted by Andrew Gould on 12 October 2011

If you've ever had the tedious job of manually scrolling through a long list of data to remove the duplicate entries in Excel then this blog is for you! Discover how to hide or delete duplicated data in Excel 2003, 2007 and 2010.