Imagine you receive an annual grant of restricted stock units (RSUs) in January. The RSUs vest quarterly over three years. How would you write a formula to generate the total vested amount in a given month or quarter? It is okay if your formula generates the whole timeline and then you do a lookup based on the requested month/quarter, but I’ll give bonus points if you can do it without the extra table. More bonus points if you don’t mention ChatGPT in your comment… 😄

Is there anyone from Canada here? I’m looking for some information on working out of the country, but selling insurance.
Thanks

Does 401k count as savings?

Analysts seem to like TJX but looking at the long term debt/equity I can’t get comfortable. What am I missing?

For a 2-year associate now tasked with senior-like roles such as reviewing and training, does anyone have advice on how to review individual hnw tax returns?

Any good ETFs to invest Roth into?

How much are you paying for rent (and where) vs how much are you making?

Pre-tax 401(k) or after-tax...thoughts?

Best resoures for realtors just starting out in their career?

Was there ever a time you wanted to give up being a real estate agent?

I am a direct private lender. I offer fast and reliable loan at 5% interest rate with no prepayment penalty. I can close a deal within 3-7 working days.

Do you have any project/deals that needs 100% funding?

-Jeremy

How's the Amazon prime visa card? Any added benefits over the other visa card? Like Chase ones for example

My org will be pausing the Employer match to 401k for a few months. What's the best strategy to optimize my investment at this time?
Ride along/increase or decrease my percentage?

Anyone start later in life? About to turn 32 and my retirement savings are sad.

How to transfer PF fund from hcl to epfo if i was a non pension member???

Best ETF to invest in? I’m 24 looking to invest about $50k and don’t know where to put it. Nothing that’s super high cost or risky please

What percentage of your money do you save, invest, allocate to retirement, & spend?

How diligent is Mintz background check. When it comes to education? My references, credit, criminal and work experiences will check out. However said I already graduated school when I am in reality a month away from graduating. The company sent over the contract and start date at the same time as the background check.

Hey there! really need a change in pace from being in higher levels of care, and am wanting to go part-time with my company and private practice, but I want to buy a house in the next year and am worried about finances. Can anyone speak to the hardships or successes or a counseling of practice and/or buying a home shortly after starting one? I feel trapped in my current job because I’m worried the timing isn’t right.

Soon to be making 85k in LA, looking to move to a new apartment. What would you think is reasonable to spend on a 1 bedroom (not studio)?

Hi guys,

I switched 20 days back to Optum. I have 7 years of experience working as a full stack Engineer, who is passionate working on both front end and back end on latest technologies. But my project is working only on back end with 10 years old tech stack. There is no front end work at all. What should I do?
I don't like working here at all, but I am not sure whether moving out again in a month will give bad Impression on my resume. Hence please give me advice on this situation

Does anyone have experience with a CMS migration? I inherited a migration plan with very little context. Any recommendations or best practices on how to move forward? Who should be included as stakeholders?

Anyone have any recommendations for home office ergonomic desk chairs?

Who is your favorite photographer?

Is it worth it to go back to school for a better track to a FAANG company? The division I’m currently in seems like there are no good opportunities, and I have the funds available to finish my undergraduate full time (Canada). I applied to Amazon before for a highly senior position and made it to final interview so I think I would have a better chance for a new grad type role.

For the people at the Manager level, do you want to become partner? Has your opinions and views changed in the past couple of years?

I'm starting to believe my caffeine addiction is affecting me. After an hour of working today, my hand started shaking!

Any vaccancies in supply chain management / procurement ?

Experience 4.5 years
E2E vendor Management

Has anyone recently onboarded to Accenture and how was the experience. Wat is expected on ur reporting day n when do u get ur laptop delivered.?

I joined Accenture few days back as level 9. Till now didn't get any project. I have one more offer from another company and have not told them that I joined Accenture.
Should I wait for Accenture to allot me project or shall I abscond?
I am worried since I joined Accenture as level 9 team lead and what if they fire me? Or map to some irrelevant project?

Can someone refer me in Accenture. I am currently working as Process Leader with 9 years of experience in project management and process management.

Hi 🐟,
I carry 7.5 yrs experience with a mix in B2B enterprise sales and E-commerce sales (own, 3rd party). Request you let know / refer any opportunities available in startups/otherwise.

Our teachers will be returning to our school building as usual (about 10 days before school starts) whether school is virtual or face to face, so our school is wanting to plan a traditional welcome back for them. In the past, the celebration was usually a whole school group event at on off-campus locale. Unfortunately, with social distancing, etc., it makes it quite difficult to do the big gathering. Just wondering what other schools may be planning to welcome back their teachers. Suggestions??

Am I able to access MyLearning before starting with Accenture? I received a Countdown to Accenture email and it included a piece about starting trainings before your first day, but both the link to MyLearning and the link to support for the link not working were unaccessible.

What is the Wharton HCM interview like? I already had a discussion with June in the summer and got all my questions answered. Is this interview any different?

Any recruiters in the Charleston, SC area? I'm trying to quietly find another PI firm. Please DM me if so.

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

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?

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?

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

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!

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

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.

How long did it take you to become good at excel? Like fast?

Would anyone be willing to teach me vlookup?