Hi 🐠! I have an excel assessment during an interview tomorrow. Role: Business Analyst
I’ve brushed up on:
- Macros
- Basic VBA (loops)
- Vlookups
- Pivot Tables
- SUMPRODUCT / COUNTIF / SUMIF
...

Hi! Can anyone provide insight into how I can increase my chances of getting a position at Microsoft? It's in the Financial Services Group and I think I'd be a good fit. Any help is appreciated!

If anyone is hiring in Canada please kindly give my partner a chance. The wait, dilemma and uncertainty is taking a very big toll from us.
-He got almost 5 years of project management, bid management and proposal management experience for a construction consultant company.
-He got experience in Primavera, got excellent statistical analysis skill, can use python for constructing ML models,
- He is proficient in RFP,RFI,RFQ for construction projects as he got BSc in Civil Engineering and MBA. 🙏🙏

Any one got the offer letter from PWC AC (Bangalore) from last 1 week ? ...if yes then please let me know how much time they have taken after documentation. Many Thanks!PwC Pwc AC

Hello. I have a job interview coming up. When asked the question by the interviewer, “Why do you want to leave your current employer for us?” What is the best answer?

I had a panel interview two weeks ago. I sent the recruiter a status check email last Friday and haven't heard back. I'm really interested in this company and still see the role posted on their site. I'd like to send another email today (to the hiring mgr and recruiter) reiterating my interest along with a list of references. Thoughts on sending the references without them asking? I don't do well with panel interviews and I'm hoping they look past that and check my references.

Hi, this is a bit early but thought y’all might have some good insight. I’m exiting my current startup & have two offers on the table 1. A successful small startup in NYC doing PE/niche executive recruiting and 2. a fairly reputable PE consulting group in Austin. I’m going through the recruitment process at McKinsey for a middle/back office role (capabilities for a really cool space) but by the time I hear back, one of my offers won’t be on the table. Any advice on what’s best for MBA apps?

I graduated with my Associate of Sciences in Health Information Management in 2021and I obtained my RHIT this past February.
I am transitioning from 15+ years in customer service/retail to healthcare/HIM.
I recently moved the New Orleans area and I am having a really hard time finding a job away from direct patient contact.
I am currently in a Medical Receptionist role that is drastically underpaid, just so I can gain experience.
Any guidance to navigating healthcare career field in NOLA?

Anyone have any insight into Capital One’s Capital Markets analyst position? I have an interview for it on Friday. Recruiter says it’s entry level (which I’m okay with) and the description says it’s an IB position. I was unaware capital one even had an IB division?

Hello! Can anyone please provide insight into the interview process for the Senior Strategy Consultant Role? Thanks!

Hi Guyz,

I went through the entire recruitment process and got selected for IBM ISL. Now I am being told by the HR that they are unable to release offer as there is a hiring freeze.

Can any one please tell me if its correct or just an excuse not to give me offer. If its true, when will this freeze be removed?

What puzzles do people generally get as a question in senior data analyst role interviews ?

Hey Fishies
I interviewed at Infosys yesterday and it went well I am expecting positive feedback from HR. Does anybody know how much time they will take in reviewing after my interview i received a message from them that we are reviewing your profile.

Laterals to Deloitte Cyber from other B4: Can you describe your interview process and what each one entailed? TIA!

currently debating if i should work on the hill or accept an IB role. i feel like working on the hill is invaluable experience that could get me into IB but maybe i’m wrong? Which opportunity gives me best resume experience?

Comparable salaries?

Applying for promotion to Digital Design Lead. 15 YoE, currently making about 82k + profit share. 3rd in seniority and department is currently restructuring. Based on some other internal salary ranges, planning to to ask for 106k, about a 30% jump. How does this look?

Hi Everyone,
I am looking for a job opportunity in RPA Blue Prism. Please let me know if there are any openings available in Citi bank/Credit Suisse/Bank of America/Deutsche bank. Thank you in advance.

Does JP Morgan email the initial offer after final interview or does the recruiter call?

Anyone here on the tech side of PwC? Someone from PwC reached out to see if I'm interested in a QA Manager role. How good is the quality engineering practice in PwC? Also what's the range like for QA Managers?

Here’s to hoping the start of the new Serena Lincoln navigator ad is the end of the Mathew mcconaughey Lincoln Navigator ads

I am a Test automation Lead and have 13 years of experience in Software testing (zero job switch) and have been a consistent good/average performer. What shud be my bare minimum salary per annum?

Will accenture accept my CTC revision request 2 weeks before joining , I am getting better offer from other company and still looking forward to join accenture.
Pls advice.

Hi Folks,

Want to get a better picture of pharma consulting in India and how do consulting firms approach clients and what are the kind of projects that we usually get

Happy to chat in DMs

Thanks for the help!

How much do senior UX designers make nyc?

Hello Fishes. 8.5 YOE . Automation Testing. Female with 2 year old baby. Prefer WLB over money.

Following offers in hand :
_VOIS : 22.10 LPA (19 fixed + 3.10 variable)
Nagarro : 25 LPA (23.75 fixed + 1.25 variable)
Intersoft Data Labs (formerly known as VServ) : 26.25 LPA (24.90 fixed + 1.35 variable)

Please suggest which to choose.

hi fishes,

any idea on senior anslyst enterprise procurement level 3 package? i have 2nd round tomorrow any advise? Thanks in advance 😊

Any people looking to date in Atlanta ? 40 F

Which top consulting firms, if any, will pay for your MBA?

Anyone a CFP as a side hustle?

Do you DCA or lump your December & April bonus into ETFs?

Thoughts on pneumatic vs. electric standing desks? Does extra weight make pneumatic desks any more difficult to operate?

My fellow remote workers: Do you ever run errands without saying anything during the day? I try
to go grocery shopping once a week around lunchtime. I just really can’t stand the crowds over the
weekend and I’d rather stay online later if it means getting my shopping done earlier.

Weekly Hot take. While I am enjoying subscription based game libraries. They will be the death of quality game releases.

What’re UX designers making at big tech?

My practice in S&C is transfering to SONG, effective September 1st. What is the likelyhood of getting f* from a compensation standpoint ? Zero chance that I put SONG on linkedin 😩😅

Anyone have suggestions on where to start learning how to program add-ins with office.js?

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

If you had a table of customer experience/satisfaction survey responses for several questions (non-numeric but discrete possible answers, no free text; 1 question per column and 1 responder per row), how would you approach determining significant insights within the data? Excel's "Analyze Data" feature doesn't really suggest things that make sense in the real world. Is there something you would try with correlations somehow, or would you use a non-Excel tool entirely?

Does anyone have an Excel shortcut guide for Mac?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Do you guys have any resources you use to get mock data to practice with?

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

I work on a Mac and excel/sheets can’t handle the size of my data. MS access isn’t available on mac. What do I do 😭

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?