Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

How is EY client in LTI? Role: .net core + Angular for my cousin . Iam surprised that Ey itself provides services and it is client for LTI. How is the work and learning in ey client project in LTI. Please reply.

Looking for some advice! I am currently employed as a Project Coordinator. I am looking into ways to to advance my skill sets and move forward in my career. Thoughts/recommendations on a Scrum Master certification? Anyone know of remote entry level jobs open in this field? TIA

I have an interview with Korn Ferry for an associate principal role and am curious about others’ experiences have been with work-life balance here. Also, I have an idea of what I should be compensated in this type of role, but any insights on how they pay compared to others would be helpful. Are you traveling during the pandemic or have client interactions been virtual? Lastly, if you are a consultant here, are you on billable hours? My current consulting role is not - so this would be new.

Client gets distracted driving ticket. Pros adds no ops charge but it’s not on the ticket. Issue or not? He hasn’t received a new ticket.

Hello Everyone,

I am actively looking for a job. Let me know if you have openings or can refer me.I have 2+ years of experience in project management, Initiation, integration, and Research & Development. I was associated with Escorts Kubota limited and there worked on vehicle design and integration on UGNX11 along with Teamcenter. I handled BOM/Data management on Oracle.

I have certification in Six Sigma Green Belt, Project planning and execution and currently learning Business analyst Tools.

Can we change project in Capgemini?

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.

Any construction/design companies in Pinellas county hiring experienced Admin Assistant or Project Coordinator? Looking

Hi Fishes anyone here working in ADDA project

Hi, I came across an HR role for a company that offers consulting services for other employers. Has anyone work for one? My understanding is that it’s project base. Can anyone here share their experience in a similar role? What do you think?

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

Why is it assumed PMs are responsible for scheduling all meetings and taking notes? When did this happen? I was responsible for providing a recap of meetings in the sense of next steps, not in depth notes on the conversation. As for scheduling meetings, I was responsible for scheduling the milestone meetings (kick offs, internal reviews, post mortems, status meetings that I led), I did not schedule the team reviews (CD reviews with ADs/CWs), client meetings, etc. Comments?

Yoe 9
Relevant 4 years
Location : almost remote always (as i requested)
Package : 17lpa +2v + 1joining bonus

Feeling like lowballed by hr.
Though i had counter offer of 17.3 (15.7 fixed)

Queries:
1. Will exl pay the variable pay fully ?
2. Hr mentioned for client meetings i may need to come to Noida on my own expenses ( from chennai) but may be once in a year.
Is that true ?

Hello fishes,

I have been working in research and bemchmarking dividion in KGS.
YOE: 2 years
I am currently bored with my current job (not learning anymore) and looking to exit in project/product managent domains.

I am willing to work in startups and fast paced companies...can you all advice?

I prepared a presentation for an interview with a sales leader, it went well and I was offered a final interview with regional manager. The sales leader I interviewed with gave me a bunch of feedback, but said to find out information about tech stack, which I for some reason, didn’t consider. I come to find out that deep, hidden within the website of the hypothetical client, they use the service already. Do I roll into the final interview and play dumb or do i present and then come clean?

Any SAP EWM fish in here? I am new to SAP and just finishing my first project in EWM. Would like to continue building Expertise in this Module.
I am therefore looking for advice on how to go about this?
Which areas within EWM to focus on or start with to build a good foundation.
I have not had formal training so just learning on the HUB and by doing as I go.
But I feel like I need to focus on one area. I cannot decide how/ what though.
Happy Holidays!
Thank you.

What are the best resources you’ve found that walks you through step-by-step, the data incident management process and what to ask your client?

Hello fellow fishes!

I'm looking for a change in either Big4 or MBBs in Delhi. Currently in business consulting and outside Delhi on a project. Referrals would be appreciated.

Much thanks in advance! :)

What is a good salary for a non-tech client-facing director role at a Series B company?

I want to thank everyone in this bowl for getting me trough the nightmare that is PCOS related fertility issues. After 1.5 years of trying, two rounds of medicated IUI, accupuncture and every other homeopathic treatment available, a vanished twin…. Hubby and I welcomed our little girl on Friday at 37 weeks. She’s perfect. It was conversations in THIS bowl that gave me the hope and advice I needed to get here. So thank you, all of you- and to those that need it - hang in! There is hope.

Got an opportunity with PwC, Global Information Reporting team. Any suggestions? 49% Hike

Hi Fishes i am making a whatsapp group for the people who are transitioning from non-tech field to data science
If anyone would be interested plz join
And let's learn , and transition together

Agenda:
Putting self progress on the course they are doing ,so that others can be motivated and
Discussion on topics related to transitioning

Can anyone please refer me for Senior Informatica/IICS/Datastage developer , open to Pune/Bangalore/Chennai/Hyderabad location.

Total experience -7.8 years
Relevant - 6 years
Notice period - Serving (45 Days Remaining)

Hi everyone, I recently applied for a graduate position with AECOM but so far what I've read here doesn't sound very nice(a lot of people quitting). Does anyone have more insights, should I rethink my options?

I am working in AS400 production support. I would like change to another domain. Any suggestions on which domain to move?

Hi everyone, i think of starting part time side tax prep practice. Will you form a c corp? I am working in public now

Hey all, just claiming my seat on a Saturday night. Was just struggling and another comment helped me get back to a healthy space. If anyone is struggling tonight, know there’s one fellow here thinking of you

Has anyone been to Chamonix for skiing?

Wondering where the best area to stay in is and how easy it is to get around?

Any tips on best value Marriott points redemption for a beach vacation? Preferably Europe or Caribbean, and luxury resort.

Has anyone got the PDF version of the PMBOK - sixth edition and would be willing to send it to me?

Not sure if this is the right place to post this but who do you all use for financial management/financial advisors? My stuff is getting a little complex with some real estate and retirement accounts.

Now I'm in a client location, My manager is a good person but he told me, I should report to Lead.

Lead is a psycho. He shows hell to the team members including me.
What should I do ?

Does Google really have better WLB than Apple? My average work hours is ok here but I constantly have early morning meetings, next week I have 3 days in a row 6am meetings and I am not a morning person. Does Google employee all work 9-5?

how much package i can expect with total 6 year of experience includes web API development and 2 year of AWS experience on EC2, Fargate etc (certified with AWS developer) and 3 years of Onsite experience

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?

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?

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?

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?

why is index match superior to vlookup?

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

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?

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

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.

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 🙏

What are some of the unique use cases you have leveraged excel for?

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.

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

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

Hi there! I'm working on the data modeling assignment and looking for some tips for data mapping (how power query or vba can help). Thanks!

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)