Tag: FORMULA

Microsoft Excel's charts are powerful, but boy are they a pain to use, especially if you just want quick, simple bars alongside your data. Well, no more: The blog at Juice Analytics has some very cool tips for making instant bar charts from your data. All it takes is the REPT() function, which will repeat any bit of text as many times as you want, and the | symbol. It certainly doesn't sound ...

I've been using Excel for a long time and might even consider myself a power user, so I'm surprised I never came across this tip before: You can toggle a formula view to see all of a spreadsheet's formulas at once by pressing Ctrl+`. That little fleck, in case it's not entirely clear, is a backtick (or, as this site takes way too many paragraphs to explain, a gravé), i.e. the seldom-used ...