How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

Dropping my 10 yo son off at school this morning: Me: "I love you! Have a great day! Learn a lot of really cool stuff! Him: "Okay, whatever.

Which of the FAANG companies have a better Work life balance and culture? Unhappy SM here who needs to switch cuz of the toxic work culture at D!

Having an experience of 5.5 years in IT Procurements I have joined on a role of an Associate Manager in a renowned organization. The salary offered to me is 7.7 LPA.
I am looking for an idea about how much salary does an Associate Manager gets on this post with this much experience.
Can anyone please suggest? :)

Hey Fishes,
What is the ideal CTC i can expect at Adobe as a CSAM. I have been offered around 20LPA (14fixed+6variables) is it negotiable?

Is SYW UBER integration dead?

I want to put together a XD file with a whole bunch of helpful web and app components for other designers to just drag and drop. 1. Is this a waste of time due to the market being saturated? 2. Where do I sell it? 3. Is there anything I need to know first?

For those who work in Agencies, how do you accurately identify the work capacity of your Account Management team? I’m currently comparing against account billable/number of accounts, however, there are still discrepancies. I layer on time tracking, but smaller billable accounts will sometimes be just as demanding as larger billable accounts which create profitability issues.

Hello fishes..How are pega developer openings for 2 year experienced lately @tcs @infosys @aaseya @coforge @capgemini @techmahindra @cts @verizon @virtusa @pegasystems any information will be of a great help

Hi guys 👋🏻
As we are about to start a much deserving weekend, heres a query that interests us all.

Guys how many bluepoints will be credited into our Global Recognition centre account in January 2023(if India doesnt win the Global Recognition Championship)?

Any companies that are hiring ppl with no experience?

I just saw that a Hubler watch given to Hitler sold at auction for $1.1 million. It is an interesting watch (despicable as the recipient of said watch was), but it got me thinking about a larger question: does anyone here collect watches owned by the famous (or infamous)?

I was wondering if the review course “CPE Self Study Course” for the CFF was enough preparation to study and pass the CFF exam. The CFE review course was enough and like if you get a question wrong it explains it well so that when it comes up in a different way in the real exam you can still get it. But when I saw the outline for the CFF material and there seems to be a lot of topics so I was wondering if the review course was sufficient considering this exam is also multiple choice. Thanks!

Hi fishes!

Looking anyone who can reffer me for SIEM / SoC l2 analyst roles in India, have experience in content development and siem implementation. 4.6 years, serving notice period.

Thanks in advance!

Got an offer from OW entry level London.

Does it make sense to join if I don't really have much passion for FS?

Other offers are EY-P, Marakon, LEK, OC&C

Any thoughts??

Do hours and intensity differ when working in NYC tax for a small city office?

Where do you find inspiration for topics to seed the community with?

Is there such thing that you only want to be friends with your similar ranking especially in a townhall and big company events?

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire bank description as my lookup value, but the table array I’m searching only has the first part of the descriptions (because the last parts are all different bank ref numbers). How can I do this?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

How can I add names/a legend to this chart? After I add names, I will want to distinguish between two types of companies via color (eg, old companies vs new). Any ideas? On a Mac if that matters

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

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.

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?

Why don't recent grads know how to use excel?

If you had a table of customer experience/satisfaction survey responses for several questions (non-numeric but discrete possible answers, no free text; 1 question per column and 1 responder per row), how would you approach determining significant insights within the data? Excel's "Analyze Data" feature doesn't really suggest things that make sense in the real world. Is there something you would try with correlations somehow, or would you use a non-Excel tool entirely?

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

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

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!

What would you consider "Advanced" or "Expert" level Excel usage?

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

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.