live skills assessment in excel
Our take
Hi folks!
This might not be what’s allowed in this sub so I apologize if this isn’t the right place but I have a live skills test in Excel coming up. I have no idea what the contents will be or what data I’ll be using. I’ve used this subs resources (Thank you!) and I’ve been reviewing what I know already, so I’m not asking for a list of things to know (although I always appreciate that) but more of advice how how to remain collected when analyzing in Excel, if any of you have done an assessment on camera like this, what was it like, and how to… excel:)
I used Excel a lot in my Master’s and in my previous role but nothing fancy. VLOOKUP, Pivot Tables, IF statements (CountIF and SumIF), basic visualizations, etc, but I am way more comfortable coding in R and SQL, and feel like that’s more where my skill set lies than in Excel. I also get really anxious when people watch me work, and the only other live skills test I ever did, I bombed horribly.
Have any of you done an assessment like this and have any recommendations on how to go about it?
Thanks and sorry again if this is not a good place to post this!!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Looking for advise/recommendations taking my first excel test for an inventory planning positionHello! I was just told during a phone interview I will be moving forward and taking an excel test. I have never taken an excel test before and am incredibly nervous! I currently work as a supply chain buyer/planner for 3 years and though I work in excel most of the day its mostly from exported sheets that need very basic clean up to work off of. I rarely use formulas of any kind, used vlookup maybe a couple times, created a some basic spreadsheets and done only one version of a pivot table in that time. My knowledge in excel is rudimentary and I have very basic knowledge of how formulas work. I'm concerned I'll be in over my head and embarrassed during this test. I have 1 week to prepare and am looking for any advise, things to specifically work on, or any practice tests recommendations regarding this field. Perhaps some stories on your experience with your first, or any excel tests you've taken as well. Thank you! submitted by /u/Ginoblee [link] [comments]
- A guide for data analyst Excel assessmentsexcel assessments are common in data analyst interviews. they test not just your knowledge of formulas but also how well you can calculate metrics and connect results to business decisions. since these assessments are usually fast-paced, here's a guide that gives you a framework for which skills to practice + how to structure your answers: https://www.interviewquery.com/p/data-analyst-excel-assessment-guide also happy to hear about how other data analysts (professionals/candidates) approach excel assessments during interviews. submitted by /u/CryoSchema [link] [comments]
- Bombed an Excel test in an interview… even though I use Excel every dayI feel embarrassed even posting this, but I’m curious if this has happened to anyone else. I’ve been working in finance for about 4 years. I use Excel all the time at work, building pivot tables, trackers, dashboards, and even using Power Query to clean data. I’m not an expert, but I’m definitely comfortable and get the job done. Recently, I had an interview that was going really well… until they asked about Excel. I told them I had experience, and then they pulled out an advanced Excel test and asked me to share my screen. As soon as it started, I completely froze. I couldn’t do things I know how to do. Something as simple as returning a manager’s name using an ID and using an xlooup formula for it, I blanked. Ranking products by revenue, I blanked. Even splitting the text into first and last name, I couldn’t think straight. It was like my brain just shut off. They ended the interview due to time constraints, and right after they left, I went back to the file and was able to finish everything… XLOOKUPs, ranking, and a few more, except the text functions cuz I am genuinely not good at it, and I rarely even use that at work. That honestly made it worse. I felt like I just sabotaged myself over nerves. Has this happened to anyone else? How do you deal with freezing like that during technical interviews? submitted by /u/Fancy-Security7244 [link] [comments]
- Data Analysis Excel InterviewI've got a interview coming up that is likely going to be testing my excel skills in data analysis how can i prep and any advice from those who have done one before submitted by /u/CryptographerOk4012 [link] [comments]