How to create a Pivot Table in Excel

How to create a Pivot Table in Excel

Learning how to create a Pivot Table in Excel is one of the most useful skills you can have when working with large amounts of data. A pivot table allows you to easily summarise, analyse, sort, group, sum, count, total, and calculate data all with a few simple steps. Pivot tables can seem quite daunting […]

How to convert text to date format in Excel

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