Related Posts
More Posts
Resume keeps getting rejected at Atlassian
I recently applied at multiple positions at Atlassian but my application keeps getting rejected. Before switching to my current org , i had given Atlassian interview for frontend in April and i using the exact same resume just with the update of current org. I Had cleared all rounds back then but was rejected without any feedback i am confident i will clear it this time can someone help me with the resume review?
Atlassian
What is the usual annual hike % in accenture?
Bowl Leader
Got an offer for a sales applications manager role at Cisco and a Strategic AE role at Amazon - both are basically the same pay (130~ base, 220 OTE)
I don’t have any friends at either company so I was curious if anyone has experience and can shed some light on culture/ work life balance to help me make a decision? Thanks for the help guys!
Conversation Starter
Additional Posts in Career Advice for Students
What’s the culture like at FTI Consulting?
How is the company culture like at Gartner?
Hello, I have an offer from Publicis Sapient for their product management internship program. Wondering if anyone has any insight into the program (exits, etc) and how the return offer looks like in terms of salary. I still also hold an interest in data science so might go with another offer but I’m not sure if it is a wise choice to let go of a PM offer while I have it.
New to Fishbowl?
unlock all discussions on Fishbowl.
I think it depends on the type of analyst role you are going for, but the types of skills I've seen my data analyst coworkers utilize regularly on my engagements are things like:
- Advanced formulas (VLOOKUPS, INDEX + MATCH, SUMIFS, COUNTIFS, etc.);
- Data validation;
- Macros;
- VBA;
- Regression modeling;
- Data visualization; and
- Dashboards.
I'd do some research online to find out what excel skills are typically needed for the role you are applying for and then look for resources to help you practice those skills. There are a ton of websites that off free tutorials and videos. When all else fails there are a ton of helpful videos on YouTube. Don't hesitate to use any and all resources, including those at your school.
YouTube tutorials and forums like Stack Overflow pretty much carried me through college. Even now, whenever my coworkers and I can't figure something out we look for the answer online. 🙃
Hope this helps and good luck!
Data modeling, VBA and macros is a little advanced for an entry level rule IMO. Pivot tables, basic data manipulation so sumif, if statements, vlookup etc would be great to have. Best is ability to demonstrate you can synthesize data and draw conclusions out of it, such as discrepancies between two sets of data, missing values etc
Thanks for posting an articulate answer that is realistic for op
Structured thinking and not making mistakes. Honestly, just having solid attention to detail is like 90% of being good at excel. The models that I have seen fail never fail because the person did not use the fanciest formula. They failed because of a stupid mistake which they did not spot.
Be good at explaining your work. Make sure they don’t fall behind as you do your calculations.
I personally like the ‘rule of thumb’ which is that no excel formula should be longer than your thumb unless absolutely necessary. What this means is that you break out multiple statements into separate columns. By doing this it is much easier to spot errors. So instead of having lots of nested IF statements, you split them into their own columns and have one IF statement at a time. Then, for example, your final formula can simply say ‘if all these columns are TRUE then return TRUE’. Therefore if the last formula says FALSE you don’t have to wade through your formula to find out which nested IF was causing it to fail. It will be clear because one or more of your broken out columns will clearly say ‘FALSE’.
Xlookup (people stop reccing vlookup or index match).
If statements and nested ifs.
Pivot tables.
Light modeling (can this person quickly project out a few different scenarios in a clean way). Fyi had a client ask for exactly this on the fly the other day.
Pivot tables + vlookups/index match + use you keyboard instead of mouse with shortcuts (all the macro and vba stuff is a nice to have). But more importantly, have fluency with the data, understand what you doing with it before showing off your excel skills. Good luck
Nothing to add except go Quakers!! ♥️💙