Advice needed: I have a manager that I do PM work for, including metrics, and often get asked to “re-run the numbers” but this is an incredibly complex process that takes a lot of time to make accurate in excel, even though it’s a single-figure output on a team/teams progress

Is there any way to make them realize the effort that goes into it on my side? I’ve stated before but they mostly brushed it off - worried I backed myself into a corner by not making it sound hard enough the first time

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

Just put a randbetween on the output and change the file name every time

funnylike

Walk them through your process if you can

like

Show the data flow/calculation in a graphic so they can see how the sausage is made.

like

I don’t know about automating this, but if you were on my team I’d press on why this type of documentation would take 2 weeks. It doesn’t have to be every single detail, just enough to illustrate that it’s not as simple as people think it is.

It might be worth spending a few minutes to see of there is a Celonis type of equivalent related for Excel but not sure if the cost-benefit will be there.

The other thing is I know this an Excel thread but your Alteryx workflows will also so exactly the kind of thing I’m thinking of.

Related Posts

Hi all,
Recently I joined in Cognizant but I got an offer with ADP.
Can you suggest which one is better?
Can I abscand from Cognizant and join in ADP?

like

My boyfriend and I have been together for 2 months and he moved to another state for the summer to work. He made female friends that he is constantly texting throughout the day. We spoke and he reassured me that they’re just friends but he’s started being secretive with his phone he even turned off his messages notifications so they dont show up when we’re together. Like one time he went out with them and i didn’t hear from him until the next day(late morning). What should I do?

like

Hi ZS folks,
I'm hoping to join ZS Gurgaon in May 2022.
Any updates on when the WFH will end?
And, can I request my base location to be changed once I've joined the company?

like
likefunny

Hi, we just launched Diversity and inclusion committee at our work place and one of our many initiatives is to share some reminders /notifications about safety and inclusion in common employee platforms/portals e.g There’s no place or time when discrimination is acceptable. Please feel free to report to HR if you com across any discriminatory behavior. Anyone has any more similar ideas what other topics we can add?

like

Favorite fonts right now:::

like

Hi ladies, can someone enlighten me with IVf process? Would like to know how long long it takes for one cycle? And when is it done after period? I.e, which day? Background: thinking of doing it during my visit to india when I am planning to stay there for couple of months. Unsure if it’s a wise choice but considering the cost I am thinking of giving atleast one shot in india..

like

Hi everyone,

There is vacancy for capacity management role. Please DM for referal.

like

Received a letter today stating my mandatory military service obligation has been completed and that I can resign my commission from the IRR and cut all ties. My only concern is I still have 3.5 years left in the IRR per my contract. I commissioned through ROTC, did 4 yrs active duty, then got out. Has anyone experienced this? Seems too good to be true.

like

If I’m only working on support projects will that have any impact on my utilisation? MC, joined few months back and working on support projects right now

like

Can i get an amen?!

like

Anyone else find themselves shopping for baby clothes way too much? Send help! :) (And yes, I know they grow out of it quickly, yes, I know it's silly, just here for laughs)

like

Has anyone been to idllywild?

like

A desi colleague of mine invited me for lunch this weekend. What should I carry to his place? Don't think he drinks, so I got some chocolates for his kid. Any other ideas?

like

How much is the % hike and % of vp(prorated) during appraisal in Accenture AI?

like

Something to brighten your day 🤗
I needed to hear this today 🥹🤲🏻

Post Photo
likeuplifting

Any word about L1 May cancelations?

like

Hi Folks,
Does mastercard allows WFH, or it is operating on hybrid mode. i will be joining Mastercard in Jan 2023

like

Hi
I have joined JPMC with 5 years of experience in my technology.
Role : Software engineer
Position: 602
CTC : 28 LPA

Am I being underpaid or overpaid or fairly paid as per JPMC norms in Bangalore location?

like

Bought $2k ELON, $2K TKING and $2K EGC.
Let's see if it can 10x from here before new year.

likeupliftingsmartfunny

Additional Posts in Excel Genius

What are the most typical models you all build

likehelpful

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Has anyone gone through Elevate Excel by Excel Campus? Looking for reviews as I'm having trouble finding any that aren't on their website....

like

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

What are your favorite excel macros to make you more efficient at work?

like

Anyone have recommendations for good hands on courses to increase proficiency in excel? I want to learn how to do vlookups better and use if/then statements and manipulate large sets of data to create dashboards. I know YouTube but I’m asking for courses that I could put down for development as part of my performance review.

like

I have a spreadsheet downloaded from a SaaS product. Every where there is drop-down multi-select or drop-down there HTML code I need to remove and simply leave my lists. Any ideas? I thought kutools would work but apparently not?

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

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

What’s the keyboard short cut to switch between open apps without using the mousing. It’s something like using alt tab or whatever the combination is

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Does anyone know if it’s possible to return multiple values using a vlookup or index match for duplicate values?

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Has anyone used VBA to create multiple what-if data tables before?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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