What is your favorite excel add in?

What will be salary for 3yrs data scientist

Anyone who applied for Data Analyst role at Infosys?

Tried to jump to a big 4 as a senior 2 in risk assurance . SF market - offered 93k base and 15k bonus. Is this worth?

28M Sikh in LI/NYC area, looking to make any friends!

Sunday 4/19 FYIsland thread! Comment if you want visitors or want to explore new islands.

In terms of total comp, who do you think makes more: an EP at an agency or a mid level producer at a FAANG company?

Hey Guys, does anyone know if jp has plans to call people to office full time from next year? I have my joining date as 1st November and want to know if they’ll continue with the hybrid model or no?

Do you find that most customers you deal with are polite? I've noticed a lot of them don't even say "thank you" after I have fixed their problem... it's disheartening

Hello fishes,

I'm a Business Analyst with 1.2 years of experience and currently, I'm trying to switch to a different organization.

I have worked on and have been part of various analysis and case studies in my current project and have experience working on Bridge Insurity tool, Python , SQL ,C#, .NET, Data Structures and Algorithms.

Please refer me if there are any related opportunities in your firm.

Thankyou!

How is pre-sales culture/comp/career growth at Google within GCP? is having a solid pre-sales track record at another large tech company (non-FAANG) plus good performance on the interviews enough to break in? Or does one need to have prior solid experience with GCP too?

Hi Fishes,

I am thinking to diverting my career towards freelancing in accounting.
For that I have to resign from my current job in Pwc. I am thinking of starting a job as accountant and work as a freelancer as part-time.

Any thoughts or advice?

Does Boston Consulting have an M&A and Private Equity Practice? Based on company webpage this is not quite clear…perhaps it is not a main focus as it is with, perhaps, Bain? Or the competencies are integrated within the practices of BCG?

Anyone down to practice case this weekend. Have an interview early next week.

Best way to improve critical thinking?

Do you have a favorite movie or show character with ADHD? It’s difficult to meet others with same issues but was hoping to watch something.

Hi all,
I am from Deloitte USI, Pune. Can anyone let me know whether Deloitte USI has a professional Cricket team/Club? Would love to be a part of it. I have represented state team (U-19) and national team as well :) Do we have various tournaments too where we can play with other Company teams?
If we don't have any club, then we should create one. I can volunteer in preparing one.
Its good to see that Deloitte focuses a lot on Well-being. So, we can write to higher authorities to have a club!!

For expert witnesses/lawyers

I’m a former forensic scientist that left the field several years ago. I recently received a subpoena from a case I worked and suggested to DA to have evidence re-worked by the lab or stipulation. If I am required to testify (as an expert witness), I would need to book a flight, hotel, etc. My question is this: can I ask for my requested hourly rate, travel, and hotel to be covered when speaking with DA or is that “not how this works” as the investigator put it?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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 🙏

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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”

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?

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)

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

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.

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?

How do I compare two sheets to make sure they are identical?

How do you fix microsoft excel cannot paste data error?

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?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Still don't have xlookup. #fomo

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?