Hi everyone! I will be going through my first whiteboard/case-style interview for the first time (I was converted from an intern to full time at my current company). This marketing associate position would require some level of excel knowledge specifically on Pivot Tables & VLookUps for email campaign analysis. What’s your experience with interviews like these, and any tips for a first-timer? Thank you in advance!

If anyone with 1 YOE or higher (non-internship experience) is looking for a referral to EY's Oracle Services practice, DM me. Referring for Staff 2, Seniors, Managers, Senior Managers and above. They are scrambling to fill many senior roles due to our practice's rapid growth.

Looking for UI Architect candidates that have heavy front end enterprise wide application experience including knowledge of Angular and/or React. Remote position but need to be legally able to work in the US with no sponsorship. No C2C or agencies please.

Anyone from KPMG India would like to tell me the hierarchy in IT advisory. How many levels are there in analyst position ?

Anyone here know which consulting firms or other companies in the area that are still hiring? Unfortunately, today is my last day at my firm. #covid19

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?

If a hiring manager wants to talk to you again that’s a good sign right? I’m just bracing myself for this offer😅

Hi everyone,
I relocated with my family to Ireland recently, one month ago, and while I got a lot of screening calls with recruiters, I did not hear back from any of them after our interview. I am still on the process of getting my work permit and I am very clear about this during the interviews, but I suspect that this is the reason why I am not getting any call back. Any tips on the first screening call with recruiters? Should I touch base with them after our interviews?

Is opening a boxing gym worth it?

If I’m servicing over 300 accounts when I was told 250 upon hiring, should I ask for an increase in salary?
I have made the most touch points/meetings on my team and I am the newest member.

So I work for a small company as a SEM/Director… which in my world just means I am really Lead Developer, Part BA and part product owner as well as reviewing the devs. I came up in this company starting at about SE3 of 5 so the position is just kind of what I made it. I have recently been getting interest from some larger companies like Amazon. Long preamble to ask, what are the day to day responsibilities/expectations of an SEM at a FAANG?

Position - Functional and Manual Testing
Certificate - ISTQB Certified
Experience - 6.5 years
Joining - Immediate Joiner
Location - Bangalore/Remote
Skills - Functional testing, Manual Testing, Agile and Scrum methodology
Domain - Banking, Payments Cards

Request to all fishes please suggest and refer me for open opportunities in Your organization

Anyone working in Progressive as a CAT field rep? What are your thoughts on this role? Pros, cons, tips?

Who has experience being successful with a counter-offer for a role based on another companies offer? I want to accept the lower salary role but with a pay nudge - the higher salary I don't care for. I'm worried I could lose out on both

Favorite halal restaurant in Boston? Help a Muslim brother out 😅

Hi Sharks,

Has any of you attended interview with ServiceNow company? I am shortlisted for second round, want to know what to expect in 2nd round and what to prepare.

Hi All,

Few days back I had cleared 2 technical and one managerial round in JPMC. But not yet received any update from HR yet. Can someone please let me know how long will they take to contact after completing 3 rounds? And any idea how long will they take to schedule HR Round?

Has anybody faced interviews in Antal international??
Can anybody suggest what questions come around for technical discussions?

Does anyone know of a coworking spaces that focus on creatives and/or marketing companies? All the ones I know of like technexus, wework and 1871 in Chicago are tech company focused.

What is the best performing NPS available on market. Let's assume that I invest 50k per year for tax saving, what could be my retirement benefits out of this(30 yrs of investing). Please help me with calculation and suggestions.

Does anyone’s practice also include patent lit? I’m thinking of switching from prosecution to litigation (my firm has separate lit and pros practice groups). If you practice patent lit, is there anything that you dislike about it/anything you wish you would have known earlier?

So a higher up made a new rule that for a service we offer , we have to offer it to the customers three times and If they say no a manager has to get involved and document. it is this not wrong?

Moving to NYC from DC. I had planned to come up for a weekend or two to tour apartments. When would be the best time? I thought about a month ahead of needing to move - and then coming back a weekend or two later - would make sense. But I am seeing so many listings on StreetEasy that say the unit is available immediately. Any advice? I have a cat so trying to avoid moving into a temporary Airbnb in between to apartment hunt, as I’ve seen some people suggest.

Are folks getting RFE on H1 transfer to Big4? My question is specifically because initially your office location is the only one mentioned coz you don’t know what client you will be assigned?

What % do you guys charge a partner to advertise on social using your handle/ad account? Is a 100% markup fee plus an "agency" like fee for maintenance of 15% too aggressive?

Is anyone looking for freelance help?

Hi fishes,

TCS Hr said to expect offer letter by Feb 7 if business approval goes through.
Or she would have to come back and negotiate.
I didn't get offer till now.
How can I check my status?
It shows evaluation in progress in ibegin portal.

@women in the ME, I’m moving from NYC to Dubai. Is there some things to consider for attire in a business environment or is it the same as in NA? I’m thinking about business travel to other countries like KSA 👀

Did any of you tried the free website creation from @thefreewebsiteguys ?

how does one make sure the client does not send out an RFP ? I am assuming once u build the level of trust with the client you make it all single sourced and keep the competition out.

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Any book recommendations on excel modeling for real world business applications?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

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?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?