Please help! I have a project plan and am looking to use formulas to automate the status column for each task based on if the due date has passed and completion % is below 100%. How best can I do this?

^when the client puts you on actuals^

Hey all, been sucked into a busy project and haven't had time to make plans for the weekend. New to San Jose. Looking for things to do, places to explore, restaurants/experiences to try. Please please please help me.

In a meeting we a client, we were looking at a stock image of a smiling Black man holding a baseball bat while wearing a hoodie. The client comments that it’s the wrong way to hold a bat. Cool. But, then follows up and says, “Also, he just looks aggressive. Like, this person would definitely attack me and my family.” I was shocked. But, apparently, I was the only one. Because everyone else on the call laughed. They were all white except for my partner who is Mexican. But, he still chuckled.

Which agency has the Corona virus test kits account? Any rumblings of which client is working on a vaccine?

Hi, any tips on leading/having a post mortem with a new client? Articles or first hand experience appreciated! Thank you!

Does anyone here work for any public accounting firms in the Charlotte area with a decent work life balance? I am looking to go somewhere where I can focus on a few clients for longer periods of time rather than constantly bouncing around. I find it much less stressful to put in longer hours if it's a client that I have been scheduled on long term.

My project client location in Denver started in person mandatory days. Few of colleagues started to go there. I’m confused as I was hired as PDM and I live in east coast and project is in west coast. My leadership is not forcing me anything and they left it to us but I don’t want to lose job because I’m not traveling. Any suggestions?

I have a client who needs a 401k, or a solo retirement account w loan options. When I was at UBS/Ameriprise, it was no issue but now it seems tougher to find a firm that does solo 401k as a RIA's.

What is the starting salary for a young MBA graduate with a project management certificate? Should I expect 6 figures?

I have joined Capgemini in the month of July and have never been on bench before. After joining till today (5th sept) I'm on bench. I keep checking internal job posting as will as jobs in R2D2. nothing found yet. Still I'm getting those harsh alert mails mentioning you have get a project within so and so date..as if I have done a crime. So my question is this risky for my career in all and appraisal cycles?

#Suggestions (Help) Required
I have received an Email from BCG for Analyst - Project Accounting.
Profile looks decent to me.
I am currently working with Deloitte as US Tax Consultant from 1.5 years.
What is the CTC I can expect from this position?

Hello All,

Have a few questions regarding IBM Joining, HR response is strangely lacking and so does in the slack(prejoin channels). Hoping can be cleared here..
a) I've been told virtual onboarding is no longer a thing.
How many days does in-person onboarding activities occur?
b) HR Informed,"After onboarding is complete, can get perm WFH based on project or extension of WFH as IBM is flexible"
Is this true? Can managers extend/grant remote for a month then let us transit to remote model?

I have been offered 14.5 lpa fixed and 1 lac joining bonus for SDET profile? Should I join ? They will deploy me at MasterCard client.

My ECD keeps changing our work before it goes to client and it's cost us making good work. Our books are suffering because he can't get his hands off the tools. Our books are only full of spec now.

Hi everyone, applied for an investment consulting internship few weeks back.
It's a client facing job, but it might come at a later stage of a job, maybe after finishing my internship and getting a job offer.
I'm interested to know what is the must develop skills, must take courses or must read books to get insight, develop the required knowledge and skills for the position. I majored in business management finance and currently preparing for CFA level 1. Thanks in advance ☺️

Hello Fishes ,

I have got an offer from GlobalLogic , with client as Google. Can anyone guide me if it is a good company to work for ?

I received an offer for 80k to work as a desktop engineer for TCS at one of their client’s locations. However, I have seen poor reviews for working at TCS and I’d like to get some feedback from anyone currently or had previously worked for that company. What is the environment like and has anyone been in a situation where the contract with TCS and the client ended and had trouble with TCS finding them a new role at the same pay?

Does anyone want to get brunch this weekend?
Finally settled into the city and have the time and desire to keep up with social calendars!

F25- Southeast Austin.
Don’t work at Deloitte anymore, if that matters!

What is the best advice you have recieved?

Hey Fishes

I will be joining Barclays Pune office in December.

I just wanted to know about salary account, do they need account in any specific bank or any banks old account would work?

Hello All, I wanted to know if anyone could give me some info about tech sales and how lucrative it can be. I am really thinking of pursuing a new career and tech sales is it. The other option though is sales engineer. Need to know about the best schools and all. Thanks

I decalred FBP, and the amount got deducted from my salary.
Now I can see I am eligible for some amount under FabP. What is it and when will I get it?
What exactly is the funda of it?
Let say I am eligible for x amount in FBP LTA. And some y of x got deducted in a specific month, now that y portion is showing in FBP tab to upload the bill.

What if in case I have LTA bill which is exceeding x amount itself, do I need to raise reimbursement request every month th with same bill?

Does your office recognize admin appreciation day? Does your executive do anything to show their thanks?

Does anyone have any insights on the Certificate Investment Performance Measurement (CIPM)?

Note to self: stop wasting money on women on dates. I’m tired of this honestly.

Hi. I was made redundant from Zendesk in August and looking for my next role. Im looking for a Senior Recruiter or Lead Recruiter role in Dublin Ireland. The market seems difficult for inhouse roles. Anyone looking for someone with my skillset?

How long does it take to get a job , when you actively apply every day for weeks. Or better still how do I do it right?

Hows the onsite situation in LTI?

Can anyone provide information on Alix partners - PE and M&A groups? What is the experience like? How would it compare to say a Kearney T&T (their PE/M&A group).

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Top spots for bolognese in Boston? Ideally holes in the wall

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?

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 🙏

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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

Dear auditors, please explain how you pick samples for substantative testing.

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

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 😭

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

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 !

How can I use a cell value (user input) to control the number of rows in a table? For example, I want to make a dynamic table containing a number of rows specified by the user. Thank you!

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

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?

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

Alt W H

For your enemies lol

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