I made a YouTube tutorial on Sumifs targeted toward beginners. Anyone willing to critique my first video? In need of honest feedback. DM me your email and I’ll send a link!

How long does it take to make at least $300k per year if you are in-house?

Looking at buying a house in Charleston, SC, then I want to get back to buying rental property. I already have two but would like to grow to 10 in the next 5 years. Is that possible and what are some ways to get some capital.

Anyone able to get a mortgage with student loans default?

What's a good % of your gross income to be spending on housing? Does it differ if you're paying the mortgage vs renting?

11/27 Check In 🙌🙌 What’s everyone up to today?

Anyone work at ProAssurance/MedMarc? Have potential to move for 25% higher salary and fully remote work, but wondering if there’s advancement opportunity and how the culture is. Thanks!

Somebody please elaborate on Corporate Functions team at Accenture!! Is it part of Tech?

My mom received an Oculus for Christmas and loves Beat Saber. Does anyone have other game recommendations I can share with her?

Exec consisting Slalom for more creative work and more diverse and inclusive culture. Any insight into partner and above admissions/roles/past experiences. Based east coast but not looking for local

How has the 30 minute phone case with McKinsey been for people who have gone through it recently? I have mine on Friday and wanted to know how many questions typically get asked and how hard the math is.

Where can you get Four Stigmatic mushroom coffee at the cheapest cost?

Hello. Just curious on what's the salary ceiling for a manager position at Deloitte? Received a verbal offer and waiting on written offer. I was told by a recruiter that M at Deloitte doesn't make more than 180. Just curious if that's actually true and if anyone had experience negotiating higher salary than 180.

Good sushi place recommendations? Looking for Omakase for $100-200 pp

Need 11 likes to DM. Can you please help me?

Currently looking for a remote job in the banking industry. I have 17 YOE - 10 in retail community banking in Deposit Ops, Lending Ops & accounting. The other 7 was at a Banker’s Bank in Correspondent Lending Ops then for the Exec Team and BOD as an EA with special projects for Execs. I have several areas of interest and have applied so far at PNC, KeyBank, Regions and FRB Boston. I also just finished my BA in Bus Admin and have Assoc. in Accounting. Any job recs out there for me? :)

In house interview- I am going to hopefully the final round of interview to meet the whole legal team. I was asked about my availability, and it will take 5 hours if in one day. Should I split to multiple days? Will it cause any issues? Anyone on both sides can speak from their experience? Thanks!

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”

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?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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

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 🙏

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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.

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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