by admin | Jan 11, 2017 | Excel Lists | List basics, Excel Lists | Sorting and Filtering
This is my first blog post of 2017. I have to say I do love the energy of a new year. My favourite time of the year are those days between the “two Christmases” i.e. 25th December and 6th January. There is no pressure. Just movies to be watched, sweets to...
by admin | Jul 3, 2013 | Excel Lists | List basics, Excel Lists | Sorting and Filtering, Excel | General
Tables in Excel One of my new favourite features in the “new” Excel is Tables. When you convert your list to a table you quickly do the following: Apply slick formatting Apply filters Enter a formula once and see it whiz down the rest of the column...
by admin | Jun 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering
In this tutorial we are going to look at how to quickly delete blank rows in Excel. This technique is useful if you have a large list with many blank rows to remove. It works equally well if you need to delete blank columns. The tutorial given below shows you how to...
by admin | May 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering
Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following:...
by admin | May 14, 2012 | Excel Lists | List basics, Excel Lists | Sorting and Filtering
Excel Filter If you are using a list in Excel, a key skill to have is the ability to filter. Filtering allows you to extract records that meets certain criteria out of your list, so for example if you wanted to find all the transactions you had with a particular...
