What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

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

Formatting multiple tabs simultaneously. I wanted to standardize the formatting in 10 tabs (e.g. first row of all tabs is colored in blue, cell a2 of each tab has the word “Title”)
I went to each tab and replicated the changes.
Shortcut: Press Ctrl and select each tab. The changes you make on any tab will be reflected on all selected tabs. ALL AT THE SAME TIME. Wasted 3 hours on what should have been 30 mins max

likehelpful

The flip side of it is that, if you select multiple tabs by mistake, you will screw up formulas and formatting; and chances are you won’t even realize until much later. I would love to say this was my worst horror story, but ...

(It also works with keyboard shortcuts: Shift + Ctrl + Page Up/Down)

When I was an intern I didn’t know how to do index match or structured references so I manually copy pasted one row of data after another from one sheet to the the next

I did that for 20,000 rows of data

likeuplifting

Long ago I worked for a gas utility call center. Supervisor accidentally deleted some important reference cells, formulas, etc. trying to migrate a spreadsheet and saved. Was awkward spending a few hours doing someone else’s job who got twice my pay because they didn’t know how to do their job, while they got to take an extended break from work.

like

Back when I was a starry-eyed intern, I tried cleaning an OCR output with formulas (of the type ifs(isnumber(find(“keyword1”,B4)),”label1”,...), so the very calculation-intensive ones 😬). It was a 50k-line file. After literally hours of work and several crashes, I was shown the way and wanted to cry.

Related Posts

Diamond medallion on Delta. They lost my bags on the outbound (3 with my wife who is Plat) and inbound flights (1) on a trip to Europe. How many points should I expect? Any advice to deal with this?

First timer here. How do anyone request or demand for points for any uncertainties?
Ask the front desk politely for compensation? Appreciate sharing your experiences

Hello Société Générale folks,

Looking for some honest advice. Considering an offer with SocGen B’lore for Specialist Software Engineer position with 5.5 years exp and into Tech service management. Could you please tell me a bit about following points?

- I see 25% of the compensation(5Lakhs) is Variable. Does company even pay 60% of it at the end of the year if you perform say 4/5 rating?
- What is an average annual hike that the firm gives?
- How is the work culture? Societe Generale

What are some good trips to do with Bonvoy points in the Northeast (thinking more spa/relaxing vs touring cities) e.g Berkshires, Vermont etc

like

Hi all

The CPE courses that i pursued on june 30 got credited to next fiscal year

I raised a complaint to the us learner team and they reverted my credit points back to be compliant as of june 30th 2021

Today am shockingly getting an emAil that i am non compliant. In the system, my points have been again moved to next fiscal year

Please advice what to do. I have emailed them. But there is no phone number to seek help

like

What are some easy to make, low stress holiday meals for a school holiday staff party? I was "volunteered" by our principal to set it up this year (🙄). I'm making decorated sugar cookies but kind of drawing a blank when it comes to savory dishes. Bonus points if you have any adult holiday themed games or fun drinks to suggest! It's off school property and there will be a bar (thank god), for context.

like

How many remote jobs do you currently have, and how do you manage your time between the two roles?

Bonus points if you share the industry you are in and your total salary from working all your roles.

like
like

Potentially at an all time low - personally, professionally and emotionally. I have to believe that life’s inflection points happen for a reason. There’s a bigger lesson for me around this corner...

like

Why won’t AA let me book business class flights with points if they’re available to buy cash? (Qatar flight on AA site)

like

Are spg and spg points eventually going to get phased out due to merger?

like

Can someone please point me in the direction of some NYC recruiting firms?

Bonus points if they hire international talent (I'm Australia based).

Thank you in advance.

like

I'm working on a Fintech startup related to commercial banking pricing. We would like to do some "expert interviews" with current RMs (we would compensate your time.) We want to better understand the friction points when it comes to price C&I or CRE loans. Please DM me if you are interested.

We are not looking for any private information, but more anecdotal evidence of issues that can be improved.

like

What credit card to you recommend pairing well with chase sapphire preferred for maximizing redemption? Pretty new to points and def don’t know a lot! I’m considering one of the Marriott cards bc we love Marriott or an Amex one! Any ideas appreciated 🤗 TIA!!

like

Hi,

Today I will be having an interview with Hexaware for data science role. I appreciate for sharing key points to crack it, and how well is the work culture & is it WFH ?

First year post my consulting exit and I’m dreading the inevitable dwindling of my points… is this what separation anxiety feels like

likefunny

Hello All,
If anyone is interested in getting an Amex card as first year free, please dm me. I can help with referral so that you get the card FYF and 2000 bonus points on spending just Rs. 5000 in 90 days.

like

Anyone have a primary care physician they like in NY? Ideally one who integrates holistic medicine as well as western medicine? Bonus points if they’re on Cigna or take insurance.

like

Anyone else not getting points / nights for recent Marriott stays? Account activity isn’t working in the app

More Posts

Hello Team, who are from Risk Advisory function, want to connect with all of you, we are on same domain.@USI KOLKATA @RiskAdvisory

like

Any positions in business or consulting?

like

Crypto industry in Singapore, any idea of salary range?
Happy to discuss by pm if easier
Appreciate any insights :)

like

What's the pay range for a Director in Financial Crime and Compliance in any of the top consulting firms in New York?

like

Steve Wozniak isn't afraid to critique Apple devices, and said he couldn't tell the difference between the newly released iPhone 13 and its predecessor, the iPhone 12.

like

Anyone have or know where to get a good returns analysis template for a take home case study?

like

While the h4-EAD application is in process (already been over 8 months of wait), can one travel outside the US?

like

Looking for room in a preoccupied room in a flat in Gurgaon. 15-20 mins travel to cyberhub or near rapid metro

like

FML. I’ve been dating someone for 8 months and have been having doubts about the longevity of the relationship. This week he tells me he is thinking about leaving our city and working remotely. Even though I was already thinking about ending it, this hurts. I know I’m being childish - being rejected by someone who I was planning to reject! And I know he isn’t the right guy for me in the long term. So why does this hurt?! 😭😭😭

like

Hi there - my company is returning to office next month. Hybrid to begin before they ramp up to 5 days back in office by end of year.

I think the fact they want to bring us back 5 days is disrespectful considering how much work we’ve put in remotely over the last year. Not to mention productivity studies say people who WFH (and have no kids) are substantially more productive.

All that being said, does anyone work at a FinTech/Tech company whose RTTO policy is more flexible? Looking to leave

likefunny

Anyone else feel like Chicago has very limited "upward" exit options, especially for tech? It seems like outside of consulting, most people who earn a higher incomes are in trading/banking/PE 😕

like
like

Can anyone working for DT’s ARA or PwC’s CMAAS tell me what does their job specifically include, hours and exit opportunities?

like

Haha it's a mix of product management, project management, product development, consulting work, technical stuff, analytical stuff. Literally anything the project needs to succeed haha

like

Anyone talk to a Muslim therapist? Muslim matters because I’d like to talk about marital issues, and not sure others will get the religious context. NYC preferred. TIA!

like

If i haven’t signed anything with my firm regarding repaying them for receiving my series 7 license with them I’m assuming i owe nothing if i leave? Is there a way to find out without my manager knowing I’m looking at other firms?

like

Is anyone concerned the push for sexual equality in pay without accordant leveling of parental leave is gonna backfire?

Here’s a hypothetical:

A company has 2 candidates, aged 25-30, equal in every respect save one’s a man the other’s a woman. Maybe the woman is a slightly better candidate overall. They’d have equal comp.

Company considers the woman a riskier bet due to possibility she’ll take maternity leave — and considers the man less risky for his ineligibility to take as much leave. 🤷

likefunny

Getting in the Black Friday spirit...what are your favorite places/stores/areas/shopping centers to spend your hard earned money?

like

Additional Posts in Excel Genius

Looking to write a macro to rename a worksheet based off whatever is in cell A1... Anyone have any ideas? 🤓 👀

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

What are some of the unique use cases you have leveraged excel for?

like

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

Dear auditors, please explain how you pick samples for substantative testing.

like

Any book recommendations on excel modeling for real world business applications?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Sheet B pulls data table from Sheet A. Sheet A is my base sheet for inputting data and will use Sheet B and other similar tabs to pull info from A and run calcs accordingly.

Question is about adding rows to data table in Sheet A. Will often have to append data in Sheet A by inserting rows in middle of data like shown/highlighted. How do I ensure the tracker ID column starts at 1 and counts sequentially all way to bottom, even with the newly inserted rows. Thanks in advance!

Post Photo
like

Anyone know what these badges are?

Post Photo
likefunny

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

like

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?

likehelpful

why is index match superior to vlookup?

likefunny

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

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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