Hi all. I'm looking for some career advice. I'm an Excel geek and spend my days using Power Query, Power Pivot and VBA to simplify and automate processes. My current role does not have many interesting problems to solve so I'm looking at a new role.
How do I find a new role focused on using Excel to automate processes? I'm happy to branch out in to other tools.
Many thanks!

Got a 30% salary bump, via an offer for Senior Consultant S&O from Deloitte. Currently underpaid at EY Advisory. I'm MBA and this year is my promotion year at EY for Manager. What to do? Get demoted and move to D? Or counter at EY? Even if EY matches my salary, and promote me to Manager, I will be an EY Manager with a Deloitte SC salary, and probably won't be able to go to D in the future. What do you think? I have built up a good relationship with my Partner and SMs at EY though.

What additional certifications and/or training do you recommended to help boost your credentials in the Healthcare and/or Public Health arena? I currently work for a hospital system (managing litigation and involved with risk management) and trying to help make myself more versatile long term.

Is anyone utterly confused about what they want to do long-term?

Hi..any idea what are the product management courses that can be taken up?

I feel like every company lies about “working your way up.” You’re never allowed to blatantly say that you don’t like your position and you’d like to transition to HR or Finance. It’s almost as if once you get in claims, you’re stuck.

If you’re a manager and you see an employee that wants to branch out into a different department, why would you keep them boxed in for 2+ years?

Are there some background mechanics that I’m missing?

Do folks regularly move from corp dev/strategic m&a to PE? looking at the first as my exit opp, but turning away PE recruitment in the process. Wondering if I can swing back if I ultimately dislike corp dev. got LMM IB experience and two target schools on resume

What made you realize that science was the right path for you?

Out of curiosity...is ALPFA 🇪🇸 friendly? I know back in the day, but curious how it was now. I want to encourage everyone to get into accounting. Thanks!

any startups worth looking at? I think I'm done with consulting and would love to go to a SC startup that's using analytics and tech

I currently work in Healthcare as a respiratory therapist for 10 years. I have been at my job, currently, for a little over 5 years. Alongside my bachelors degree I also have a masters degree in healthcare administration. Although, I am happy with my current position as a respiratory therapist, there seems to be not a lot career growth with where the department I currently work in within my healthcare system. I am wondering what doors/opportunities I have if I were to utilize my masters degree?

Hi, what does the typical career path look like in Tax at EY UK? Thanks.

I am sure this has been something that has been asked many times before but here goes...
I want to become an SEO. What is the best piece of advise you would give me?

Hi everyone, I’m in a medium size consulting firm started working since Oct 2021. I’m wondering is it good to jump to industry for my next move or move up in the consulting world to polish my resume better with MBB or Big 4 in my resume… any thoughts? I really don’t know what to do in life so either one works for me, but I’m just lost.

I currently work as a senior accountant in Nashville. Is it possible to go to public accounting?

I’m trying to make the jump from legal services to corporate IP. I’ve only been in practice for 2 years and I have 0 experience in corporate. Do I have a chance?

Does PwC AC really consider MTech (CSE) as a higher education in Tech Consulting?

Hi,
There was a post sometime back which compiled a list of all companies by country who hire directly from India. Could anyone please share a link to that post if you have it saved? Thank you!

Should I take more initiative? It’s my stub year and I’m getting worried. My hours have been super low the past two months, I’m talking like maybe billing 3-4 hours a day and billing no hours on multiple days. I ask for work but the tasks I get don’t require a lot of time. Should I be reaching out more?

Change my mind: A motion to “clarify” one of the court’s orders is actually just a cute, roundabout way of asking for reconsideration.

Rolling off surge work and onto my first client project. Anything I need to be aware of for folks that recently have done it?

I know I’ve seen a few similar posts before in the past, but do you guys have preferred/recommended apps to keep you organized and productive with work? I have my work calendar and synced through outlook on my phone, but just looking for suggestions to keep everything as organized as possible.

Can I move to Florida the month my bonus hits and not pay any NY State tax on it? Or would I just declare that 1/12 of the year I was in Florida and get the pro-rated refund from NYS on my overall Pay

How long do you guys think it will take for rental prices to rebound?

Looking for a new apt, and noticed 24 month leases cost more net effective (obviously because prices should increase next year).

Is anyone here working in coforge banglore location???

Just want to say this is such a thoughtful bowl. Great responses, lots of questions on self improvement, sharing of resources. Love UX guys #empathy

What sites/tools do you use to create and maintain your portfolio site?

Do you have a "Design System Council" or "Design Council" in your team? What kind of topics do you talk about? Just learned we have that and unclear what it's about.

With so many news sources using a subscription system, there needs to be something like a Netflix for news articles.

Anyone from BCG Gamma who wouldn’t mind DM?

Is it easy to switch from operations to broker dealer side specifically sales?

Best websites to get more of a handle on Excel as a beginner-intermediate?

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?

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

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?

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

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?

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

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.

Still don't have xlookup. #fomo

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!

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 🙏

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 😭

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 🙏

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

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