I was ready to toast this function at work today.Presented with a list of encounters by physician, I wanted to know how many cells in the array were blank. This meant that we did not have data for …
Y U No…
After receiving three reports before noon on Monday that were not printer-ready, I had to take a time-out for this:Keep in mind that many older coworkers still prefer printed documents. And …
Excel: Lego for Grown-ups
I love using Excel because it's so flexible and adaptable. There's no better vehicle for quick, easy data analysis.Chandoo of chandoo.org often emphasizes the importance of playfulness and interaction …
Find String Length with LEN()
The other day at work I was presented with a list of physicians for whom I needed to find some information. This was necessary only for physicians with ID numbers over 3 characters long.Rather than …
Happy boss > Fancy formula
Chandoo runs a great Excel site at chandoo.org. I really like his site because he frames Excel problems from the viewpoint of a real life data analyst. He's been one and he knows what makes analysts …
Never Fear, Excel is Here (to stay!)
Image from Gartner study If you're worried that your Excel skills may soon become obsolete, take comfort. A recent Gartner study positions Microsoft as an industry leader in BI and Analytics. I'm …
Continue Reading about Never Fear, Excel is Here (to stay!) →