Teaching analytics with modern Excel
It's a slow week, the last week of the year. Time to break down gift boxes, heat up leftovers, and reflect on the year gone by. It seems like a lifetime ago that I left my job at a hospital to …
Continue Reading about So, you want to work in hospital administration? →
Russell Ackoff (1919-2009)One of my (many) writing assignments this semester is to write a biosketch of a prominent information systems theorist. I am finding a lot to respect in Russ Ackoff, my …
Continue Reading about Russ Ackoff, Modern Management, And You The Analyst →
I love teaching people Excel, because I know how much it can help people at the office.People often approach me with the request: "Teach me Excel!"This attitude is great, but it's important to begin …
Continue Reading about Focus! Why “I Need to Learn Excel” Isn’t Enough →
You’re scheduled to interview for a job whose description calls for “advanced Excel skills." You’ve used Excel for basic data entry… but what the heck is a PivotTable?n How the heck are you going to …
I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.Introductory SlideShare:Here are a few of my top posts …
I call VLOOKUP the "duct tape of Excel" because it can mend and join practically any sets of data.Introductory Slideshare:Here are a few of my top posts on VLOOKUP:Why Vlookup?Vlookup: the …
