Chris Gemignani of Juice Analytics wrapped up my tour of eMetrics with some great, in the dirt tactics to "juice" your use of Excel in web analysis. Chris focused his presentation on ways to maximize each aspect of the analytics triangle - reporting, exploration and presentation.
Can You Repeat (Function) That?
If you're a fan of the "over/under" charts in Google Analytics, you can mimic the visualization with the Repeat function. The syntax goes like this, REPT(characters, # of times), e.g. REPT(“x”,5) -> “XXXXX”
- To make bars = REPT(“|”, F3/10)
- Bar and text, REPT(“|”,5)&TEXT