Merry Christmas! I hope you are enjoying the holiday and spending more time with friends and family -- and maybe less with your spreadsheets!Here is an appropriate Excel tip as your Christmas tree …
Is There a Problem Here?
If there were such a thing the Analyst Scouts, it'd have the same motto as the Boy Scouts: Always Be Prepared.A good analyst is thinking two steps ahead of his data, anticipating problems and taking …
Scratch that!
Ctrl + 5 applies a strikethrough line to selected cells in Excel. This can be useful if you are collaborating with colleagues on a list-type project and want to clearly show when projects have been …
Open Borders?
Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel. …
Ctrl + 1derful!
I call formatting a necessary evil in Excel. It can easily take as long as the analysis itself -- but the nice thing is that good formatting makes for better, quicker data analysis.Keep the Ctrl+1 …
Double Up on Pivot Magic
Did you know that you can use the same value field twice in a #PivotTable? Follow these steps to include a % total or running total on your report. …