Great question - what are your most used formulas in Excel? Mine's gotta be vlookup, IF and SUM. I'm pretty simple lol.

I want to start dabbling in photography, but don’t know which camera to invest in. Anyone have recs/prefs? Looking to spend under $1000 for initial camera bod + lens set up.

I have got an addendum letter from Wipro today stating that my date of Joining has been extended by 45 days. My joining was in mid August. I have 2 options to Accept or Reject the addendum.
Can i reject the addendum, how will it impact if I reject it ?

We are all sleep walkers (specifically in Europe) walking towards the second wave of corona virus cases and potential lock-downs even though we should all know better.
Change my mind!

What is the audit senior manager salary in bay area. I am third year senior manager of that help.

Bad part of being laid off: many many interviews (and of course lack of job). Silver lining: no more virtual company happy hours! I do not miss the pressure to participate.

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

Is anyone from McKinsey or Bain available for a quick chat? I’m looking to change geography and my best bet might be with a different company. I’m currently a consultant at BCG

Hi - I have never used this. I’m planning to schedule fertility test. Would this programs offer me any benefits?

Thanks in Advance!

What's the word on spark foundry (chicago office). Seeing lots of wins and reading interesting things.

Do you Expense Golf tournament entries for Industry events that have a golf tournament, or do you pay for that out of your own pocket? Is there a difference whether the golfing is with Vendors, or Customers?

I love living in Miami, but have found it incredibly difficult to make friends. I had a thriving social life/ friend group in Chicago. Anyone else finding it hard to build friendships here?

Living in a ~700 unit rental building with 50+ staff - any suggested holiday tipping? Staff at the building come and go all the time (we just got a whole new wave of doormen in November)

Hello everyone! How do you manage holiday pay when the holiday is on a Saturday/ Sunday. For example, if I have someone working on Christmas (Sunday), they should be paid 1.5 but what if they work on Monday as well?I know this might sound silly to some people but I’m covering for payroll for the holidays and I don’t want to mess up!

Hello Everyone
1. Wanted to know what are the roles and responsibilities of HR Solutioning Teams and how can one enter those teams ?
2. Also is having in-depth backed knowledge and practice on Workday has massive demand in the market?

Can we stay long term in nagarro for about 3-4 years thinking about it any suggestions

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

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 is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

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?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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?

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 🙏

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

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?

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

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?

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!

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!

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

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 🙏