3rd party recruiter wants to set up a video call so I can meet her team. She said it's not an interview but required if I will use them in my job searching. Anyone have a similar experience?
For those who have left/are interviewing elsewhere, do you mention that you were part of the DC model in your interviews? Has anyone asked?
Hi fishes, can someone provide some insight what is expected in Salesforce Technical Consultant role interview at Salesforce? Is Data Structures and Algorithms also a part of the interview process?
Currently applying to federal clerkships. Is there an average amount of time before you hear back (if selected)? Also, is it proper to call to confirm receipt of submitted apps outside of OSCAR?
Hi Fishes ,
I have recently cleared all rounds of interview for PWC india. HR has sent me mail for sending all my documents but till now they didn't call me for package discussion. I have shared all the documents on 8th aug and after that there is no response from HR. Please suggest after how many days they may call or what can I do in this case . Please suggest.PwC India Pwc AC Pwc AC
Shift2B4 — M1 switch from AcN to b4 interview process in tech. Is case interview mandatory or it’s only for college hires. Can anyone elaborate ?
Just received an interview offer for an outpatient position at a hospital and I've interviewed and am still awaiting a decision on the inpatient position. Does that mean that I may have not been selected or that they're unaware I applied for 2 positions? Is that something I should mention or not?
I was laid off recently from my role as my firm declared insolvency. I had an interview with Deloitte today (My background includes tier 1 graduation, work experience with investment banking firms as well as consulting firms) and the interviewer thought that they could arm twist me. The interviewer was rude from the start, didn’t let me finish sentences, treated my work experience lightly and later told me that the work is tedious and she doesn’t want me complaining later. Continued in comment..
Disheartening to loose an opportunity at Alix due to psyc eval, that too after the final interview! Looking for referrals at MBB or FAANG London. 9 YOE, tech strategy.
My boss and his boss spent the week in the local office. It was a masterclass in how to take an organization teetering on the edge and basically shove it over the cliff.
Can’t wait for my interview with a competitor tomorrow.
Best way to prepare for A&M interview / case studies for the PEPI CFO Advisory group? Heard case would be about the three F/S, which I understand from accounting perspective but wondering if I need to know anything specific. Thank you!
No, Kellogg, I don’t want to join you for Preview Kellogg. I want a god damn interview invite
I did an initial interview with a firm Thursday morning. They asked for references and I provided them the following day along with my thank you note. In past experiences, I would have heard something by now unless they were not interested at all. Am I wrong to just write this one off?
First phone technical interview with google for SWE (Software Engineer) role. Would like some insight on what to expect and how to do well?
NYC recruiters! Is the market really slow for summer?
I’m applying and applying but I can’t seem to get anyone on the phone. I know I’d crush an interview but can’t snag the contact.
Hi! I got an interview invite for Data and Analytics - Data Analyst role at Natwest. Can anyone help me out with the interview process (how many rounds and nature of interviews)? There's very little info on the internet for the data analyst role at Natwest.
Thanks in Advance
Good day! :)
Not sure if this is the right bowl to ask but is anyone here willing to case with me? Have an upcoming interview with BCG. No pressure, only if you have time and if you want to help someone get through case interviews :) currently in the UK!
I have cleared coding with mcq
3 technical interviews in teams done
What will be the next round in nagroo.
Any current BAL attorneys that can share their experience working for the firm? I have a second interview coming up. After the first interview I’m pretty excited about the opportunity and would like to hear from any current employees on their experience with the firm!
I am working as SAP FICO consultant at Infosys. I have 4+ years of work experience. Worked on CFIN migration, S/4 , ECC support projects. Can anyone please help me to get referred in CG.
Co-worker of opposite sex sent me a meeting invitation to a one-on-one Wine and Dine. What should I be expecting?
Happy short month
What resources have you found helpful (books, articles, newspapers, etc.) to further develop your tax knowledge??
“Looking for candidates who appreciate female empowerment and have a passion for diverse representation within advertising”
That’s not to even subtle. Could have just said white dudes don’t bother.
WSB literally saved GME, it’s pretty nuts. So for those that made $$ congrats but it’s just luck, you ain’t a genius. And to all the novice investors on this bowl, GME is as big as an anomaly that can exist in the market. Don’t follow stocks blindly like this as you can be burned bad.
What’s wild about GME’s current valuation is that they can just issue equity and payoff all their debt now (recall this company was almost filing for bankruptcy)...
How lenient with clients are firms being re retainers and bills between COVID and holidays? Standard in our fee agreement is (a) required replenishment of trust balance, and (b) hearing/mediation retainers due 45 days prior. We used to be somewhat understanding, but now it’s by the book. And this change was almost overnight.
How competitive/what’s the demand for Associate or Solution Architects at HQ2? I.e. is AWS hiring to the point where it would be easier to get a job? (Grain of salt: I know lots of prep is needed regardless)
I forgot to submit my timesheets yesterday! Help! 😭 What would be the extent that it would impact my evaluation?
I have couple of offers in hand but have not yet resigned. The hike I'm getting outside is around 35%. Does CS match the offer I'm receiving outside?
Current Designation - ENO
YOE - 7 years
Department - Chief Risk Office
Location- Pune, India
Any new lateral joiner in HCLhave u joined recently ?
Work from home or office , what HCL asked you ?
Laptop sent via courier??
Considering getting a Nomos Orion with the display caseback as my first serious watch. Any other good options around this price point I should consider?
Hello fishes, I am working at IBM as a Data Scientist and currently on bench. I will be resigning today as I have a better offer in hand right now. Wanted to know if I have to serve entire notice period of 90 days even when on bench or IBM gives early release ?
Is anyone starting at the London office on March 15th? Has Vialto initiated your visa process? The recruiter has been unresponsive
Additional Posts in Excel Genius
Hello all! Please have a look at XLR8BI on Instagram and TikTok where I show you quick tutorials on how to use Excels powerful functions and other analytical tools such as Power BI and Python!
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
Is Copy, Paste Link the same as =“randomCell”
I noticed when I pasted cell and came back to it, it would show ref errors where as the =“randomCell” would be okay
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!
Dragging a formula down 50K rows, around the 47k row it just stops. Not stops to calculate the formula but stops to even apply it to the cell (it’s blank with no formula). Am I going insane??? 🤯
Hi there! I'm working on the data modeling assignment and looking for some tips for data mapping (how power query or vba can help). Thanks!
PowerBI/Excel- have payroll data for full year and would like to calculate average pay per employee and extract records +\- 10% of average for each employee. Any ideas on how to go about this?
Can someone please explain a vlook up part with the columns being a certain number of rows from whatever?
Dynamic Range Question- I have monthly P&L data. From this data, I want to create a PL report that uses the start date and end date input from user and calculates the P&L for that period.
Is there a function key to add an IFERROR statement quickly on a formula the same way you can add an absolute constraint with F4??
My excel skills during quarantine
I’m doing a simple IF lookup, if A = B, if true Yes, if false No. it works correctly for 90% of the table but there are a few it shows as false. When I did a simple does Cell A = Cell B to see if any issue, it shows as true. Why is my lookup acting funky?
Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.
If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.
Thanks in advance
Can anyone share any great free resources to practice excel skills? Looking for sample files where I can solve problems vs watching videos.
My suggestion: get a free online official database (idk the country you're currently in) and ask the candidates to perform some analysis and create a functional* dashboard - say you provide them a database of internet connections:
- how it's divided by state?
- how it's divided between mobile, fixed, high-speed, low-speed, etc.
- what places have the most growth rate among the years in the database?
- and other useful stuff
* pls don't ask a "good-looking dashboard" as 1 - beauty is very subjective and 2 - you can easily train someone to get to your (or your company style); it's not a part of excel learning to be good at design
If you're in US, check the census Bureau for good ideas - I have a couple but they're mostly for finance
Gito coursera.com do two things . Take excel skills for business specialization by Macquire University . Second do a Google data analytics certificate do compare with Google sheets . Will do help you alot
Just come up with situational questions around how to or how the people would solve problems in excel. Don't be afraid to have them demo.
When interviewing interns and recent grads I've asked them to send me Excel files they referenced in their interview (when we ask about Excel). For the most part this has been solid in terms of knowing the basic skills they possess, interviewees tend to reference files containing whatever they consider the most complex skills they have. However, because it's generally a school project it doesn't speak to their ability to process fluid information or quickly deliver on said skills. The timeline of a typical school project is far longer than 'I need this by end of day' so I think I'll move towards adding a simplified Excel task and timing it in the future.
Well assuming you don’t want to crush the candidate with an expertise excel test, I would say after proving they know how to utilize a sum function, maybe throw in a little curve ball in there and see if they can utilize a SUMIF, COUNT , MAX, MIN and AVERAGE functions from the same dataset for quick insight.
Learn index match, xlookup, nested sumif, conditional formatting (more than basic), advanced filters, goal seek and you'll be an advanced user.
It is subjective, i agree but despite being an expert in VBA, i don't recommend it to other people. Better solutions (PQ) can be found on the fly. In terms of formulae, once you are familiar with the intermediate ones, the most advanced ones become simple to learn. I think an advanced user is one who isn't scared of attempting any spreadsheet and knowing the intermediate ones, anyone can make good spreadsheets quickly googling the functionality they don't know.
Try taking the Microsoft Office Specialist Certification exam. You can take either the regular or the expert version. I took the regular exam for Excel 2016 back in spring 2020, and it tests core competency. It doesn't go too far into advanced Excel functions, but rather it demonstrates if you're able to navigate Excel via the ribbon to execute a series of tasks. After taking the exam, I ended up earning the highest score in Iowa for the 2016 track. Wow! Since then, just having the certificate has proven to be enough of a qualifying boost when applying for roles. I've found this to be a more successful approach for saying I'm familiar with Excel rather than listing formulas I know; of course, there's still an advanced realm in Excel that exists. You don't have to be an all-seeing Excel wizard; if you have confidence in navigating the program and performing core functions, you are doing quite well compared to those who are reluctant to open a blank spreadsheet.
The course is actually quite garbage imho