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

like
Posting as :
works at
You are currently posting as works at

(B-A)/A

like

Then format the column as Percent 💯

like

(B/A)-1 then format as %

like

(New weeks count - Last weeks count) / last weeks count

I do it the same as EY1

like

What everyone else here is saying

like

new/old-1

like

B/A-1

Related Posts

Hey Accenture! You good bro / sis? Didn’t see your Friday post? Today is Friday, right? This week was a blur…

like

What brands/artists are inspiring you this week?

Any thoughts on Pinpoint Partners? One reached out to me about JPM TMT and a few other roles.

like

Any Female 🐠 in for a FWB/casual relationship? 30 M here. Nyc based.

likefunny
like

Hey All, what’s your personal experience with work life balance (WLB) in Singapore? I’ve heard varying views on this so would be good to hear from people on e.g. Big/small tech/consulting etc. companies and how they differ in terms of working hours and WLB. 😊

like

Are people going on in person dates (first dates with people met on dating apps) still?

like

If you have written it well, I will read your long copy.

like

How difficult is it to get an Explorer I from a Rolex AD? I live in Boston, and haven’t seen them in stock. However an AD in Boca Raton told me they could find me one. Continued...

Hello Fishesh,

Is any one have recently given interview at accenture?

Kindly help me with the interview process

like

Best place to get sample slides for proposals?

like

Hello fishes,

Can you please let me know what happens on the joining day and in that week on mindtree, how much time it takes to get Id card and laptop

like

During my job search, I am getting a lot of recruiters asking for me to answer right to represent emails. These particular recruiters follow a same pattern and seem unprofessional. Shall I be aware and not sign these right to represents? Are they a scam? Or is it a cultural thing… can someone advise me, I’m based in the USA

like
like

What’s the average salary for a senior and mid-level copywriter in SF?

like

What's a good answer for "why industrials"? I'm interviewing for a lateral position at a much larger firm but am not really interested in industrials...

like

Hi All,

What is the advantage and disadvantage of working in SAP labs as external worker

like

When is the best time to leave as senior? Does it make a difference leaving one year after making senior vs two?

like

Looking for guidance, any tips would help:

I'm trying to lose as much weight as possible in the next weeks.

Currently,

I fast about 16-18 hours,

eat 1 or 2 medium-sized meals,

no processed carbs or sugars.

I walk/run for 30 mins and do 15 min HIIT (or substitute the whole thing with 30 min HIIT)

Can I do anything else? I'll work out another time of the day if it helps.

Additional Posts in Excel Genius

Sensitivity analysis: Guys do you have any tips on doing sensitivity analysis for an xls with different tabs for inputs, cals, and outputs? I need to calibrate net income for 8 revenue scenarios based on flexes on two inputs (one is a flat rate OPEX unit and the other one is forward oil curve). Data tables won’t work coz I have 8 cases each of which needs its own cals and output tabs. Appreciate help! 🥺 inherited this model so noone to ask! 😅

likehelpful

I’m struggling with some pivot charts that are connected to an update button. When I update the excel sheet, the formatting for the secondary axis is removed. Any solutions?

like

Hi all, urgent request for help:

Say I have two rows (New and Lost customers) and a bunch of columns for the number of months passed. I can input a specific number of months that customers get retained for (X), and to calculate lost customers each month I want to subtract the new customers from X months ago. What formula do I use to grab the value X months ago from the New row? I want to make sure that the value I grab can change based on the X input. Manual example below.

Post Photo
like

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

like

Favorite Excel shortcuts or formulas that are not so well known?

likesmart

Change my mind

Post Photo
likefunny

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

like

Alternatives to Power BI for Mac users? Trying to branch out of excel. Reports aren’t too stable with excel

likefunny

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

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!

helpful

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

Do you recommend using INDEX(MATCH) instead of VLOOKUP/XLOOKUP in all scenarios? Or are there times where V/XLOOKUP may perform better?

like

is there a way to use my keyboard to go through drop down options in a given cell?

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

What macros do y’all have set up?

like

Does anyone else feel like they are really stoned while trying to type out the logic for a nested IF AND with an OR formula? My mind doesn’t work that way but I cannot quit the process of figuring it out. So satisfying when it works.

likehelpful

I would like to create a geographic heat map in excel using a list of addresses that will be continuously added to and would like the map to update as addresses are added. TIA

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

I want to learn more about excel. Are there courses that you would recommend?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal