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?

Looking to return to an industry job from consulting. Director and up level. Experienced in Agile, Delivery, People Leadership, Strategy. Corporate world and consulting. Please DM if you can help. Willing to relocate to select states, remain local and work remote. I have a list of solid references and project outcome examples.

There is an opportunity in another office to build out their business in a large industry that I identified. The office has very little client base within the industry. The partners do not have experience in the industry and there are no senior managers or managing directors in that office. As a SM4, how do I go about asking to build out that business with the hope that it’ll build a strong case and accelerate my path to partner?

Hello all! Has anyone completed the Professional Certificate in Product Management program with Kellogg Northwestern?

I’m currently a technical project manager looking to pivot into Product Management. I’m wondering - is this investment worth it? Interested to hear your thoughts.

For context, I graduated in December 2021 with a business degree and have 1-1/2 professional experience in tech/marketing/project management.

Thanks in advance!

Hi Fishes,

I have offer from both nagaroo and Publicis sapeint. Project is not decided in PS but Nagarro hire me for the ZS Client itself.

I am looking for job security, wlb and good project to work on.

Fishes, can you please suggest which should I join?

I have received an offer from Mphasis but client is DXC ...is it a good option to consider. Are there chances to get development. Stack - .net angular

Hi All,
I am looking for java developer position in adm domain as getting released from my current project on 31st July.
If there is opening in any of the project, please let me know.

Hii joining CGI in support project is good for future... please help me with this need to confirm the offer by tdy...

Currently I work for a small company that does the construction of small cell utility poles and roof top sites for the major cell carriers like VZW, T-mobile, AT&T and so on. I am a project coordinator but I do everything under the sun. Created project tracker. Submitti bids, sourcing material, negotiating price on materials, handling post construction inspections, scheduling sub contractors, notifying stakeholders, coordinating with construction managers - property owners - building management.

Hi folks,
Need ur suggestion!
I am havng 2.7 yoe and working in project in ibm past 2 months. I am facing difficulties in settling in this project. As it’s early stage of my career I need to learn and then implement but because of that I am daily facing pressure and I am daily worried abt my work . How to overcome this pressure? Sometimes I feel to take release but on other hand I think I need to face and learn !
Plz help

UBS or Morgan Stanley ??please help fishes I have joining next week

Both at client side

Hi Guys,I joined Cognizant as a BA.One client took interview for RPA Project.I was pretty happy it's a new tech but into the project the onsite BA's r doing all the work n m just creating documentation.I am really frustrated.I picked cognizant of many good offers.They r spoiling my career.What shud I do? Tell my manager or just resign.Its not good leaving company in 6-7 months.
Plz help.

Good morning, hope everyone is having a great week! Does anyone have any advice on breaking into an analyst role? I am currently a Senior Customer Success Manager, with a background in Operations/Process and Project Management as well. I have always enjoyed the analysis pieces of my roles and would love to expand my skills to show how qualified for a position in data analytics. Thank you in advance for the help!

Hi Guys, Anyone working in snet project?

Hi I work in paid search. Would pivoting to project magnet be feasible/realistic. All advice welcomed. Just a mid 20yr trying to figure this corporate game out. Thanks.

Hii all ....
Can anyone give me some info regarding project allocation in tiger analytics?
It has been 3 months since I joined...still not allocated to any project.....
I am little worried about the recession news coming......

Hi Fishers,

Can you please let me know if there are any openings for Oracle HCM or SCM for fresher? one of my friend has 3 years of experience in the Non-Oracle background and looking for purse career in Oracle ERP.

Please do the needful

Any Strategy& SM available to DM? Have an offer and would like to get some thoughts on the base, sign-on and bonus - negotiable? Also, bonus cycles and timelines etc?

Anyone have idea on below companies. Which is better in terms of WLB & hikes? Both offering almost same CTC.
1)EPAM Systems
2) FactSet

How do I get a job at a startup? I have an accounting/finance background, but don’t enjoy that work and want to get into the startup space (been interested for years).

Anyone hiring in NYC?
Willing to sponsor a work visa?

Best prep material for cissp?

Looking for a job dojng cloud security. Which are the best and worst companies to work for? Optiv any good?

It’s week 5 for me of the breakup and even though I had a full and fun weekend with friends and people I love, I woke up today so so sad because I wanted to text my ex. I just feel overall so defeated and exhausted from sadness and unmotivated at work :(

Best desi food recommendations in Toronto doentown?

Employer is trying to force me (disabled using a walker and immunocompromised) to return to work at the office after WFH efficiently (covering 2 roles!) For 2 years. I actually can't even do my job from the office. Office isn't ADA compliant and my walker doesn't fit. Some employees aren't vaxxed and mask mandates are being removed. I've been fighting this order loudly. And now I have to meet with the CEO, HR and my supervisor. Wish I could leave, but I don't have a new job lined up.

What would be decent package for RPA production support lead role in Fujitsu company

Hello People,
I am actively looking for Job opportunity in O2C- Accounts Receivable profile.
I do have relevant experience of 3 years 9 months in collections, billing & cash application.

Would really appreciate referrals from anyone or if someone can just let me know if there any vacancies available.

Hi, I'm getting lot of interview calls for SAP SD Consultant but they want someone experienced 2 to 3 years of experience, 1 or 2 implementation done, support or rollout etc, Relevant experience of sap is zero I have, for BFSI industry is 3+ years I've, so what would u suggest??I'm not getting any work, 5 months gap already now in doing SAP course, hana certifications etc,any fresher in SAP, how u made it in SAP? I'll start working anywhere now, in SAP I'm not getting anything, tired or have i

If I want to apply R1, when should I request recommendations?

Looking for a new roommate for a very affordable and spacious Capitol Hill apartment in a great location (right by Lincoln Park). 2bd + 1br. $1000 for the larger bedroom (2 closets!). Basement apartment but very well lit in common area. Hoping for someone chill and friendly, since we'll likely be seeing a lot of each other this year! Flexible move in anytime in October. Prefer female roommate (I'm female as well) since the bathroom is shared. Please message for more information if interested.

Anybody knows how brexit will impact Tier 2 Visa

Has anyone successfully pursued a relationship with someone they met at work? An MD I am really attracted to has been chasing me, but I am nervous about what the repercussions could be if it doesn't work out. Still, it's tempting

Hi fellow fishes, just received an offer for EY cap. Markers as an M, and wanted to get your view on how life at EY is like e.g. work life balance etc. Also wondering why EY has such a terrible rating (just 1.6) on Glassdoor. It’s kinda scary it’s so low

Guys how much is expected pay in Capgemini for BI consultant Role for 8yrs exp..n how is Job Security n work culture with Onsite opportunities in Capgemini?

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

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?

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 are some of the unique use cases you have leveraged excel for?

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

Looking to write a macro to rename a worksheet based off whatever is in cell A1... Anyone have any ideas? 🤓 👀

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.

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

why is index match superior to vlookup?

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 😭

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.

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 🙏

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?

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

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?

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

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

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?