by Consultant's Mind | Learning
For many readers, your are excel professionals. You get happy – almost excited – to create tricked-out excel models to impress your boss and clients. The fact that there are 500+ formulas,100+ functions, and 200+ shortcuts, is kinda cool. Yes, you are a...
by Consultant's Mind | Learning
For weathered consultants, Excel is not new. In fact, we teethed our brain on it many years ago as analysts, consultants, senior consultants. In fact, it’s possible – just possible – that we have gotten pretty slow at it in our, uh um, old age....
by Consultant's Mind | Learning
Data is often imperfect As consultants we know that perfect data is a myth. No matter the organization or website, data is gunky, irregular, and often broken. Was at Starbucks this morning doing my travel and expenses. Went to the American Express website and...
by Consultant's Mind | Consulting
Every senior manager has a different style This is one of the hardest parts of being a consultant who rotates on projects. Have to cater to the preferences (some say whims) of managers. That said, some of it is common sense too. I reviewed a presentation today, and...
by Consultant's Mind | Learning
This week I coached a new consultant in creating an excel model. Here are some of the words of advice I gave him. I wish I knew these pointers 20 years ago. Excel model structure = easy to understand Put all the assumptions, drivers at the top of the page. This...
by Consultant's Mind | Graphics
Tableau Yes, this is french for Table. It is also the most user-friendly, powerful, and amazing desktop visualization tool for consultants. Tableau is a company based out of Seattle Washington, founded in 2003 to commercialize work out of Stanford. Fast-forward 10...
by Consultant's Mind | Learning
Recently, I was given an excel model that was the Titanic: large, slow, overly ornate, and structurally unsound. Not only was it frustrating to work with and laborious to fix, it was also a bit laughable. It did not answer even the most basic questions: Who is...