Excel tabular data format

Excel tabular data format

3 November 2013

Today I want to share with you an Excel secret. It's so powerful that when you know this your Excel life will become much easier.

I say it's a secret because I get A LOT of questions from people struggling to use the built in Excel tools like PivotTables, and functions like SUMIFS, COUNTIFS etc.

Most of the time they're struggling for one reason… Their data is in the wrong format.