You're not limited to the date formats built into Excel. You can format them however your heart desires. The underlying value (the exact date) will … [Read more...]
How To Use Google Docs’ JOIN And SPLIT Functions
Google Docs offers two functions in its spreadsheets that Excel doesn't: JOIN and SPLIT. They are the finessed alternatives to Excel's CONCATENATE … [Read more...]
Show Change As A Delta Symbol in Excel
When I'm working with tables or charts, I like to make labels as short as possible. So when I'm showing a change in a metric over time, like percent … [Read more...]
How to Find Your Top Content on Your Homepage
UPDATE: The Google Analytics interface has changed significantly since this post was written. Check out the updated post and video. Problem: We … [Read more...]
How to Find Duplicate Content with Google Analytics
Problem: All of a sudden my site has lost a lot of organic search traffic. Is there anyway to see in Google Analytics what may have caused … [Read more...]