If you have to run a report in Google Analytics that shows traffic over time, you'll need to use a custom report. Custom reports allow you to choose … [Read more...]
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel's best-kept secrets) to divide a list of keywords … [Read more...]
[VIDEO] Excel Bug In Pivot Charts On The Mac
As I mention in my post on creating pivot charts, you can't create pivot charts in Excel for the Mac. It's, hands down, my greatest aggravation with … [Read more...]
Real-World Example Of Advanced Filters in Excel [VIDEO]
Not too long ago I wrote a post on the Search Engine Land site about advanced filters and how they're an amazing alternative to regular expression … [Read more...]
My Biggest Pivot Table Annoyance (And How To Fix It)
If you use pivot tables in Excel a lot like I do and you've ever had to pivot data with long entries, such as URLs (like from a Screaming … [Read more...]
- « Previous Page
- 1
- …
- 12
- 13
- 14
- 15
- 16
- …
- 20
- Next Page »