This is the video mentioned in the post on how to create waterfall charts in Excel. It will show you a quick and easy way to take advantage of this Excel functionality.
Do You Choose Your Favorite Calculator or Does it Choose You…Like a Lightsaber?
I asked a bunch of accountants about their favorite financial calculator and this is what they said*: [Read more…]
10 Excel Formulas Every Consultant Should Know
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…]
Masters in Accounting Not The Sweet Treat Some Students Think
Getting a Masters in Accounting (MSA) is a waste of money, but aspiring accountants everywhere continue to struggle with whether or not to pursue this advanced degree. [Read more…]
One Thing You Should Never Do On LinkedIn
A few days ago I got an email notification that a person invited me to connect on LinkedIn (If you’re not active there, you should be. Read why here.). It had the default message, so I decided to hit reply and ask how the person found me and what prompted the interest in connecting with me on LinkedIn. This was the message I got back.
Hello Eric,
I am current pursuing my CPA and live in Chicago. I have completed BEC already and planning to give the other three in next three months. I was randomly searching for CPAs in Chicago to connect ith them in order to learn more about the opportunities available for professionals in the accounting field. Also in case you know about any job openings or opportunities for me please do let me know as I am looking for a job. For any further questions feel free to contact me at any time.
You notice anything wrong with it? The email was nicely written but falls short on a couple of things. [Read more…]