Anyone have a an idea for showing the following in Excel or PBI? A hierarchy of portfolio>program>project decomposed with values of planned vs actual costs with the associated roll ups. Something like the picture below with multiple nodes without having to manually enter it all?

Hi All,

Is there a mandatory client interview for all projects in Capgemini after joining ?

Hi guys 👋🏻
So I joined IBM 5 months back, was on bench for this long and got project just a week back.

My PSP and People Manager have been kind of lenient, cooperative and kind to me because I was never told I will be put in PIP, I have to enter project not matching my skillset etc etc.

Is it wise to appreciate both of them via blue points for their support?

I just got a mail saying I have 200 bluepoints to send out appreciations if I feel like.

I'm feeling a lot of anger towards my manager (now he's acting normal but there were moments where he was condescending/dismissive/mocked my and others work/arrogant/said stuff was "wrong" constantly/belittling the difficulty of tasks etc. in the past project).
Maybe it is "standard chewing out" but it bothered me a lot. So much that I find myself still getting all fired up inside thinking about it...
Idk how to let go of this :/ Thoughts?

ZS 🐠, how often are you at the office vs client site? I’m curious because I’ve heard they don’t travel much

Will I seem like a jerk and risk being able to boomerang if I put in notice before big audit client? I won’t know I got the job until 2 weeks before then and new job would start when the audit starts.

Im 21, recently got a project manager job in a big media group, I still have about one year to do in my degree. Where would you recommend I take my career next, what would be the logical next jobs I could explore in that field?

Simultaneously leading a Logfire and an EBS WMS project. Pray for me.

How are the client and project interviews for SAP in Capgemini? Are those tough?

Name the most ridiculous micro-managing by partners that you experience.

I’ll go first: MP told me that on initial emails, I am always to start with “Hello [name],” but after the initial email, I am not to address her by name again in the same thread. Initial greeting can only be “Hello [name] ” because just first name is too brisk and a “Hi [name]” is too informal. Had a 5 minute, in depth conversation as to why she prefers it this way…

Hi Fishes, I joined LTI on 21st Nov as Specialist- Product Engineering. While HR discussion, hr told me that this for LTI product FOSFOR. After joining one person gave me assignment on java+react js, which I completed and shown to them. Now they said your RM will get you a project.. Is it that now they are not considering me for products? In iprofile it shows project name as ABAS but manager name as RM name. Can someone help me?

I have offers from below, help me choose best in these. Skill tech consultant/BA yoe 6.8

EY GDS - in pipeline 19 fix+1.9 var (my preference due brand name and wfh as of now and low cost of living in noida)

Iris -19 lpa 18.3 fix (behind ey GDS) -direct client onboarding

Cognizant consulting - 19.5 fix + 1 lac var (gurgaon more expensive) EY Cognizant

Hi Fishes,
I have an offer from Nagarro So Anyone know
How are the project in Nagarro for Java Spring Boot Stack.

Thanks in Advance.

HCL people want to conduct the Cleint round before releasing the offer letter.

I have already received selection email from HCL but not the offer letter yet, it's 25 days.

What should I do, should I give client round before taking offer?

If I am a S&O C going up for early promo to SC this year, how detrimental do you think it would be for me to be on a pure human capital project from July-March? I have previous S&O experience.

Hey guys, I’m a freelance broadcast producer and I’ve spent most of my career working for larger agencies. I’m doing something for a smaller agency and they want the production company to hide costs in their bid and then have production bill the client the inflated amount directly and pay the hidden costs to the agency. The agency is calling it a “consultation fee” but client just thinks production costs more. Is that common and I just haven’t experienced it before? Or is this a big red flag?

Hi Fishes,

Got an offer from TCS for the Bank of America project. Is it a good project? And which location should I choose Bangalore or Mumbai?

Anybody else have a desire to bill more hours on a project than you actually work when the project itself is incredibly frustrating? In agency and/or freelance? Because let’s be real, 1 hour of standard work does NOT equal 1 hour of work when someone makes your job incredibly difficult.

Are hackathons still relevant after college for profile building?

Hey Fishes,

Currently I’m looking for an opportunity with Big 3 firms.

Presently working with a Big4 firm.
Yoe : 5 years (before MBA)
Qualification : BE, MBA (tier 1)

Hello

Can anyone refer me for associate/ consultant profile under technology consulting role? ( IT strategy/ M&A/ Digital transformation role)

On NP and LWD is 29th November.

Having offer from 2 big4 but want to get in bain badly !!

Did anyone left coforge recently? I have to leave by next week, and company asked to courier their laptop back to office.

Anybody here an Account Manager at AON?

How do you like it?

What company runs the background check?

Are their recruiters that specialize in placing CD level creatives in Creative Director roles at cool brands? Brands like DWR, Casper, Aesop, SweetGreen. Tired of surfing LinkedIn, Indeed etc. Help!

Does the sf office have lockers?

Any insights on Disney Streaming Service as a company? Culture, pay etc ?
Also why are they requiring people to be onsite ?

Any good business/consulting books on amazon kindle that y’all have read that has helped you in your job?

Any ideas on which communications agencies would have a significant west coast presence and strong health departments? Everything seems focused on NYC, which I’m not interested in.

What's the point of all this research if nobody ever reads it?

Industry vs. academic research, what have your experiences in either been like and which do you prefer?

Wanna a learn Data Science cource.Anya vs suggestions please

Any European companies hiring for tech roles from India with Visa sponsorship? I am a Sr Frontend Dev with almost 7 YoE.

To keep it general across tier 1 consulting firms...what would be the typical pay band for a practitioner with ~6 years experience and a MBA

Does it always make sense to max out your HSA? I have ~$6k parked there now as a healthy 28 yo with virtually no healthcare utilization

Salary for PwC Revenue Cycle SA? 4.5 years experience, CPA?

🐠 with <10 total YOE and $200k+ base. Can you highlight your role and path? Trying to identify more stable non-banking and tech roles. 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!

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

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

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?

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

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?

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?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

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?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

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.

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

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?

Would anyone be willing to teach me vlookup?

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 🙏

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to