ChatGPT said I should ask y’all to share your spreadsheet horror stories so we can learn from our bad experiences…now I’m too curious not to! The worst experience I’ve ever had was as a consultant, showing off a prototype and then having the client ask to do something I hadn’t tested, ultimately resulting in an embarrassing error. But in the grand scheme of things, I wouldn’t call that a horror story. Can anyone beat it?

Hello Guys,
Salary discussion is done. How long will it take get official offer letter ? Its been 3 days since then.

Does anyone getting similar mail daily :Know Your IBM January'22 - Register Now ?

Hi peeps. Need a suggestion , I am about to switch for a change and I have an offer from LTI for PM but my current location is noida. I have been offered in Bangalore but moving there is little tricky with growing kids and family. How long WFH is going to go and how is the growth ladder provided I take this opportunity and switch and wait for things to happen. How much does a project manager travel and how will this role help?. Please help

Looking to learn what other people’s jobs are like, what’s your role and what’s your day to day like?

BOA Planning for permanent WFH ?? Is that true??

Happy Monday!! Just a quick reminder to NOT feel bad for taking time off. You deserve it! You only get 1 chance to live your life. There are no do overs. This is not a game!

🚨Motto for the rest of the year: Working to live not living to work.

Side note: you’re replaceable at almost every company but not replaceable to your family.

What's the point of Delta drink vouchers when they serve alcohol on request anyway? (Even in economy)

Anyone have any suggestions on how to discuss not spending my own money on office expenses? We don't have corporate cards, yet I'm expected to purchase snacks on a constant basis for meetings.

How to best calculate the loss of value(diminished value)to my car due an accident? Insurance agency quoted a really lower amount.

ZS fish, Is there a Senior Consultant level at the firm? I am currently a M3 in Lighthouse at 174k base (7.5YoE) doing data science.
If SC doesn't exist, is Manager a good level to target, or is Consultant more like it? Looking for 200k base at a minimum.
Expect my current year TC to be around 200-210k.

Hello Everyone,
Would someone be willing to refer me for a position in Salesforce at Hyderabad ? I am looking at Program Manager roles currently with 9 years of experience.

Many many thanks in advance

Got few questions regarding LTI and business analyst role. 1:Does anyone have any idea how many rounds are normally conducted for LTI business analyst interview. 2.How how many days they take normally to release offer. 3. How much should i expect /ask for 4.8 yoe for business analyst role.

Hi,

If we survive the notice period in BNP are we allowed to take block leaves?

I want to buy a Rolex explorer 1. Should I buy it used for around $9,500? Or someone try to wait for the AD which who knows when it’ll be. I’m a bit hesitant to buy a used Rolex. Is buying used from a reputable source risky?

What all wellsfargo check in BGV ??

Hi! I’m a generalist looking to get more involved in sustainability. As I continue to learn more about the space, I’m thinking about career exits from management consulting into something more meaningful to help the earth. Any advice on this transition / potential roles I can work towards? Thank you!

Could anyone share ISSP certification study guides or general info?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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?

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Would anyone be willing to teach me vlookup?

Still don't have xlookup. #fomo

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?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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.

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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

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!

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 🙏