If your manager sets up 2 excel spreadsheets to sync up in Sharepoint, and it takes more than 10+ minutes to save the file, what are your thoughts?

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

Manager got busy working on something else more important.

like

Wish that was the case!! All excel spreadsheets were set up with the same thought process!

like

Manager would appreciate the analyst taking the initiative to identify, call out, and offer to improve the load time if they understand where the load time hog is coming from.

like

The Manager doesn’t appreciate in changing the model to improve efficiency. There are macros created, manager does not how to fix if broken. The formulas are linked to a data tab that looks up the whole column and/or looks up additional blank rows, ex 50k, to include weekly new data added!!!!

Is it calculating something? You can disable "calculate on save" for those, I do that for my larger models.

like

Is it applying formulas/formatting in a table or to a whole row/column? If it's formatting the entire row/column then it could be taking a long time to do so. If it's not already within a table, I'd consider putting it in one.

Manager doesn’t use Excel “table”. It will make life much easier!

Correction, including the extra 50k+ rows was for the pivot tables.

If management is ok with spending 1-2 hrs saving files, what does that say about productivity?

Related Posts

Is it still worth buying Tesla stock? Especially after rising so much since year start?

like

After figuring out FI/RE I am less motivated.

likefunny

If visiting home country after transfer approval, will I be eligible for drop box? I have my current employers stamped h1b visa valid till end of next year. Thanks

What is the average yearly hike given in PWC?

like

Is it worth switching from EY GDS to hcl in just for months as there is no project and sitting on bench. EY GDS : CTC 23.5lac fixed HcL : CTC 28lac, yoe 9yrs Designation payments analyst. EY PwC pwc HCL Technologies

like

Hi folks,
How long jio hr take to release offer after all requested documents sent?
Jio hr not answering my call and email idk why?
Is this normal?

Hi Fishes, Got a call from SAP for functional role .I have 10 yrs exp in SAP functional skill , how much can I ask for compensation. Since when I asked 50% hike recruiter behaved abnormally and denied it.
What's job level and avg compensation for 10 yrs exp resource in sap labs.

like

Any advice for a first time manager ?
Context: after ~10y in technical then marketing role, taking over a team of analysts, first management position.
Tips, readings, stories, … are welcome 😁

like

Any idea where is Google's Pune office is coming up??? I mean exact location?

P.S. I have made rent agreement in Kharadi side now I am tensed about if the office is tooo far.

like

Can anyone refer me in Wipro. Thanks in advance.

Hi guys,
Any openings for GIS Mapping operations or as data analysis roles ?

like

Hello, I recently was reached out to by an in-house recruiter at a similar but slightly different company than the one I currently work for. The recruiter provided a base range and an OTE range. The lower end of that range is what I am currently making. The higher end of that range is almost 200k more than my current comp. The role is almost identical. I wasn’t looking to move, but that higher end range would set my family up very nicely for our goals. But I am happy at my current company. Help?

like

What will be the in-hand salary for Tata Consultancy? Please helps should I join or retain by taking hike
Current : 13 lpa Infosys
Yoe 7.5
Skills: .net core, MVC, web api, angular , AWS, azure

Post Photo
like

Has anyone gotten matched to Delta diamond from EP or 1K? In our status match program it shows platinum as the highest tier for matching. Any tricks?

like

I am new to United Silver and I purchase economy tickets. Is the best strategy to check in exactly 24 hours ahead and switch my seat to an open economy plus seat?

like

Platinum AF just posted. First time it’s come in at $695. That’s a losing position for me this year, I think. Anyone have luck getting it back down to $550?

like

I write TV commercials, and since Bulova created the first TV ad, I’ve been interested in adding one to the collection. I know more about their ad history than the actual watches. Anyone have a recommendation?

like

I need to do a case prep. Let me know if anyone is available today or tomorrow? Based on ET

like

Anyone have any similar experience or insight? My boyfriend asked for space/not really together anymore and he says he started to become nervous about being in a long term committed relationship. Even tho he said he saw me as long term & I’m his best friend and he loves me but why then? Does space help you guys figure it out? (Help / advice please😞)

like

How much are you contributing to your 401k?

Additional Posts in Excel Genius

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

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?

likesmart

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”

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

What are your top Excel ninja tricks? Ones that few people know...

like

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?

like

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

likehelpful

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!

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

like

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 🙏

like

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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?

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

like

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

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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