One of the most annoying things to have to do in Excel is writing a Nested IF statement.  For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for.  The most common usage of this formula is to assign ... Continue Reading >>

How to Learn Excel

by Matthew Kuo on January 16, 2013

in Excel

The majority of people who are really good at Microsoft Excel will tell you that they gained their knowledge simply through experience.  When I was a management consulting analyst, I’d frequently be given tasks that I thought were impossible with a spreadsheet; the process of coming up with an Excel solution was what really Continue Reading >>