How to use Flash Fill in Excel

Flash Fill in Excel is by far one of my favourite Excel features. Learning how to use Flash Fill in Excel should be on everyone’s to do list. It is one of those features which stuns during any of my Excel training courses and it’s the most frequent feature that people come back and say […]

How to create a Pivot Table in Excel

For those that are new to Pivot Tables, or PivotTables in Excel, a pivot table allows you to summarise, analyse, sort, group, sum, count, total, and calculate data all with a few simple steps. Pivot tables can seem quite daunting to users who have not used them before. Learning how to create a Pivot Table […]

How to convert text to date format in Excel

Last week I received an SOS from a good friend. She had data that was exported from an LMS and being used for analysis within Excel. A particular column contained a date and time in each cell that needed to be filtered and sorted by month. This was proving impossible as the data was being […]