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!

Chicago & suburbs: seeking advisor min $20m AUM to change firms and team with me at my RIA to service clients better as co-advisors and build practice. Great tech, transition, and admin support!

How many of you are in an interracial relationship? And what are yours and your partner's ethnicities?Just wanted to do a quick poll :)

Anyone in this bowl based in Central Florida that would like to connect?

Looking for honest opinions: would you trust career advice from someone who doesn’t necessarily have a background in career coaching but has always been “that friend” that everyone calls for career advice, resumes, salary negotiations etc?
I have a long background in management and have been very successful in climbing the ladder but I would love to start career coaching on the side. Any feedback is helpful!

Females, how much of your personal life do you disclose to the men in your team? I.e. Lovers, relationships, ONS etc

How do you pick your fights with management during promotion year for scheduling?

Hello fishes,
i have an offer of X amount from jp morgan and x+ 3.5L from Mphasis, my joining is within a week, I asked counter offer from HR, she said we will look if there is any backup candidate to fill that position then we will not do counter and it will impact my DOJ also since offer approval process takes around 2 weeks. should i wait or should i join on my current doj. and also if i will wait will they give me another doj on my current compenstion or they will revoke the offer past doj?

Hello All ,

I am immediate joiner. Looking for Application support L2 or L3 role .
Having 7 years of relevant experience

What to expect when you are joining JP after Christmas 😅?

Are there any additional deductions from the first salary of new hires?

Any one make a move from fund admin after big 4 assurance and then was able to make a pivot to a PE fund accounting team? I am considering moving to a fund admin now. Have 9+ years of big four experience. Worried that I can get stuck in fund admin. But I have interviewed at several big name pe shops and make a few rounds on interviews but then get the same feedback that they are worried about my lack of operational experience.

In need of advice: I am starting a full time role (Senior Consultant) in an industry that is my post-MBA goal. I want to start MBA Fall 2022. Does it look bad to AdCom if I apply R1 having been in my job for 1 month? (Will have 1 year when I attend). Thanks!

Lady 🐠- any recommendations for a good OBGYN?

I know I am opening up the doors for a troll feast, but finding a good doctor can be difficult- WOM is the best option and I can trust people here more than the average yelper.

Looking for remote working opportunities as a Business Anlayst or Product Owner. Have 5+ years for work experience as a Business Analyst/Product Owner post MBA.
Please share any possible openings or referrals.
Thanks !

What do hiring partners (or HR in in-house) generally think about a lateral that are in the middle of a part-time MS degree program (STEM MS program)?

Hear that appraisals happen for an employee every year around the first ever joining date. Is this true? And, does performance review happens with your manager or how does it work ?

Hi all! I’ve been dating my bf for about 4 months now and there are some things he says/is into that make me believe he is either Bisexual or has gender dysphoria. I could really use someone’s advice who has a similar experience like this. Is anyone willing to chat? I just want to be supportive and helpful.

What are your thoughts about OMSCS course by Georgia Tech?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

why is index match superior to vlookup?

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 have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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).

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?

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

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 🙏

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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