[Anonymous]

So I am starting an entry level job tomorrow for a consulting role at a mid size company. I am pretty strong in my technical skills, but I am worried what exactly I will need to know in particular to impress my seniors/managers/partners. I know Vlookups, Pivot Tables, Time Value of Money, and basic calculations in Excel, among other stuff in Excel. Is there anything else in Excel I should know, or anything else for other softwares?

Thanks for the help.

[Mathgirl7]

It really depends on what your task is but you sound like you have a solid foundation. Google is your friend for anything that comes up that you don't know. 😉

AUD - 2/1/2014 - 92
BEC - 2/8/2014 - 79
REG - 5/17/2014
FAR - 5/21/2014

CA Ethics Exam - Passed

[Marc]

Good Luck 🙂

Passed And got my license too ..

[How many letters do you need]

Ahhh yes. I've consulted but no idea what your focus is going to be. The biggest differences for Excel is lookups, pivots and then being able to effectively get the information from whatever source you get it from into an excel friendly format. I loved consulting because sometimes that's SQL, sometimes it's SAP, Cognos or sometimes it's ancient like green screen AS400. Once you have the basic Excel stuff down your focus should be system expertise in as many formats as you can. That's really what is going to make you valuable early on in your career. Then as you progress into mid level you figure out what the heck to do with all that information:). Congrats and good luck!

MBA,CMA,CPA, CFF?, ABV?

[Anonymous]

Know Sumif/s just to add to your list. 🙂

[Author]

Replies