Please Log in to view this content.
Excel is one of those things you can spend a lifetime trying to master everything it can possibly do. Luckily you don’t need to know everything Excel can do to get a lot out of it.
I work with a partner now who is known to make the claim that Excel is the world’s largest Enterprise Resource Planning (ERP) system.
Also, I can tell you when I started in business school at Kellogg, we used two fancy macro workbooks to run sophisticated statistical analysis until they shifted to having everyone use STATA.
STATA was/is infinitely better than Excel, but you’d be amazed at what you can do in Excel, with a little bit of coding know-how.
This post is about the Excel formulas, though – the little statements you type into a cell to make magical things happen.
Read on to dive into the ten Excel formulas you need to know and love to…excel as a consultant. [Read more…]
Odds are your clients have a day job in addition to supporting the consulting project where you spend full-time hours. That means wasting client time needs to be a top concern for you.
You know you need to build a relationship, which takes some time but if you take up too much time you might start to come off as overly sales-y. Once that happens, it’s a matter of time before you’re looking for your next gig.
Make sure you keep an eye on these three things so you don’t overstay your welcome and cost yourself long-term opportunities. [Read more…]
One of the hardest things to produce as a management consultant is an executive summary.
The more effort you put into a presentation, the harder it is to summarize.
I’ve been there and I get it. After all of the iterations, you made it so that every word had to be justified. Every single word is important to telling your story.
This is where people have things all mixed up. [Read more…]
When you work on a presentation or a project deliverable, do you like to sketch out the full document first or polish each section in sequential order before moving on? One of these is definitely better than the other. [Read more…]
How do I gain access to the C-Suite?
Everyone either wants to be the CFO or they think they need a personal relationship with the CFO or CEO to excel as a consultant.
Luckily for most of us, that’s not entirely true. Here’s why. [Read more…]
Client retention is tricky.
If you don’t watch yourself, you current client can quickly turn into an ex. I’m not talking about major missteps like you making out in the office. Most could agree it wouldn’t be surprising if your client decided to make a change if you did that on their campus.
As it turns out, there are some lesser degrees of weird that can still send your client retention rate plummeting to its death.
You know what’s weird? [Read more…]