Teaching analytics with modern Excel
Hello Readers, Happy New Year!I've been unusually silent lately, in between the holidays and a nasty virus. Avast! I am back with more.I'm trying a new medium: YouTube video. This is a great platform …
Continue Reading about Quickly Fill Blanks Cells in Microsoft Excel →
Update: After getting clarification from the reader I developed the attached model. It was bit trickier than I thought at first and I am feeling a little under the weather tonight so have not gone …
Continue Reading about Conditional Formatting Across Columns →
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 …
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 …
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 …
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. …
