It's safe to assume most people know how to create links in Excel that point to Web pages. Personally, I prefer to use the shortcut Ctr-K (Mac: … [Read more...]
Auto Increment Lists By Dragging In Excel
One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. … [Read more...]
Change Dashes To Zeroes In Excel
I might be alone in this, but I hate seeing hyphens in lieu of 0's in tables and charts. Here's what it looks like: To change these … [Read more...]
Clean Up Data Labels From The GA API
One annoying idiosyncrasy of pivot tables is that all of the headings are prepended with a label indicating how the data is summarized. The most … [Read more...]
Do Math On The Fly In Paste Options
One annoyance with using the Google Analytics API is that it doesn't format percentages correctly. Instead of coming in as fractions that you just … [Read more...]