Exporting Your Analytics: Formatting the date/time column correctly when using Excel

Are you using Excel to read your exported analytics and having trouble reading the date/time column? 

To format the date/time column in the CSV exports when using Excel do the following steps:

On the "Home" ribbon go to "Format" and select "Format Cells"

Now you will see delightfully human-readable dates and times.