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...]
How To Convert Google Analytics’ Funky Month of Year Format In Excel
UPDATE: Since I've had a couple questions about how to display the date as just the month and year, I created a Google Sheet demonstrating several … [Read more...]
Formatting Dates in Excel
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...]
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...]
- « Previous Page
- 1
- …
- 5
- 6
- 7