Skip to main content Skip to Footer

November 27, 2014
Analyst Skillz
By: Caroline Gadsby
So it’s been a while since I last blogged! I’ve been drawn into several “extra-curricular” activities which have been sucking up my free time and which I’ll blog about in future.
Over the past couple of weeks we’ve had some new analysts join our account; two of whom have started on the project. There is some great training provided by Accenture, which as a reader of this blog you are unlikely to have accessed, but outside of that if you are interested in making your life easier as a new starter, what skills could you develop…?
  1. Excel – I find this hard if I don’t have an actual example to go on, but you should know how to use SUMIF(S), COUNTIF(S), and VLOOKUP (or the far superior INDEX(MATCH()) and how to format your spreadsheets to make them really easy to use and good to look up (using a cover sheet, lists and conditional formatting);
  2. Excel VBA – if you can use VBA, great; if you don’t, find someone who does and do a bit of background on what you can achieve with VBA, then learn how to get people to do things for you
  3. Typing – not remotely essential, but knowing how to touch type will make your life a lot easier
  4. Word templates – knowing how to set these up is very useful(!)
  5. SharePoint – this isn’t one that you’re likely to have access to, but it’s worth knowing the principles of version/configuration management, and if you can get access, learning how to set up a site can be very useful
  6. Powerpoint – to be honest, until you join Accenture and have QPT, you’re probably a pro at this; when you join, get QPT and learn all of the functionality
Or you could just make the most of being a student, or being on a gap year, and learn it all once you join… Really, if you can be known for having one niche which you know and can deliver well, the beauty of working at Accenture is that your colleagues are usually very happy to help you with the gaps. You just have to find that niche and make it useful on your project.

Popular Tags

    More blogs on this topic