Eric P. Butts

THE Career Site for Accountants and Consultants.

  • Home
  • About
  • Useful Resources
  • Articles
  • Work With Me
    • Breakthrough Resume Writing
    • How to Get Smart in Excel…Fast!
    • Corporate Ladder University (Book)
  • Privacy Policy
  • Terms of Use
  • Disclaimer
  • Login
You are here: Home / Archives for data analysis

April 24, 2016 by Eric Butts 15 Comments

10 Excel Formulas Every Consultant Should Know

Top 10 excel formulas

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…]

Filed Under: Excel, Management Consulting Tagged With: accounting, consulting, data analysis, excel

Featured Posts

Why You Need To Be On LinkedIn

Why All Your Years of Experience Mean Nothing

What I Learned From the Promotion That Got Away [Case Study]

Stop Dressing Like a Clown and People Will Stop Treating You Like One

How to Get Into Business School – Part 4 (Recommendations)

Popular Posts

  • 5 Reasons You Should Be Proud to Ask Dumb Questions at Work
  • What Does It Mean to Have a Sense of Urgency
  • Always Stay Close to the Gatekeepers
  • Why Are There Still So Few Black CPAs?
  • What's the Difference Between FP&A and Accounting?
  • 3 Reasons Average Students Become Good Accountants
  • One Thing You Should Never Do on Linkedin
  • How to Handle Double Standards in the Workplace
  • How to Pass the CPA Exam Without Breaking the Bank
  • Masters in Accounting Isn't The Sweet Treat Some Students Think

Recent Posts

  • Here’s why you may want to rethink that skills section on your resume
  • Internet troll triggered by a pair of tweets
  • Some knitting advice that might help you fatten your bank account
  • What Elon Musk should’ve learned from how Thanos approached handling his business
  • Here’s an example of why you need to change how you’re doing cold DM pitches
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts