I've been reading Guy Kawasaki's The Art of the Start 2.0.It's a great read not just for start-up entrepreneurs but, as the title says, for "anyone starting anything."This quote in particular got my …
When Negatives Don’t Count: MAX( ) Function in Excel
Subscribe and get more tips for the awesome analyst. Plus, your free ebook.The biggest operating expense of almost any business is payroll.And unless you're really masochistic, negative pay doesn't …
Continue Reading about When Negatives Don’t Count: MAX( ) Function in Excel →
Display Negative Percentages Red in Excel
Analysts are constantly comparing actuals to budget. Because humans are better at processing colors than numbers, it's often a good idea to add some conditional formatting to your variances. A common …
Continue Reading about Display Negative Percentages Red in Excel →
Join the MOD( ) Squad
In business, you're often fitting square pegs into round holes. Shipments of merchandise come in different quantities than you can display them.Join the MOD( ) squad!This Excel function will …
Don’t Weight to use SUMPRODUCT
Weighted averages aren't intuitive, but they come up in business all the time. Fortunately, Excel has a quick function for calculation weighted averages. If you're a student, you may be more familiar …
Mark Twain, Data Analyst
A topic of interest to me as a liberal arts grad is the similarity between good writing and good data work.Mark Twain famously said, "I didn't have time to write you a short letter, so I wrote a long …