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

Is my manager forcing me out?

In our 121 last we had a good discussion on creating a personal development plan, with the idea being I’d write down clear goals & action points to get from my current level to the next, and I’d provide weekly evidence of it. I prepped the doc accordingly, but instead of wanting to discuss it, he said I have 4 weeks to “turn things around” - without giving any new info on what I’ve done wrong - esp given I wrote my goals based on this same feedback from last week??

like

First travel project. What are the most valuable airline points to accumulate? How can I maximize my travel points (hertz, Marriott, air, csr) to be redeemed for free flights?

like

Took content knowledge praxis for the 4th time today and missed by 2 points for NJ standard. Does anyone have any study tips? I want to give up but I don’t. It’s just very frustrating! Help please!

i’m first place in my fantasy football league rn - best record and highest points. should i give away my backup TE for a backup RB? i don’t really need … everett for henderson 🫠 hmu fam 🫠

upliftinglikefunny

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

like

Looking into credit card, most likely between emirates nbd Bonvoy card or the Emirates offering. Anything better out there? What has been your experience. My understanding is you can convert the emirates points to Bonvoy? Not sure if the same works Bonvoy —> emirates.

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

Looking at how market is going up everyday no one is afraid of Jpow now. Doesn't matter if it's 50 or 100 basic points rate revision. With this speed SPY 500 by end of month. No fear left. Even shitcos have gone up 40% from their jan 24 lows. BTC 50k. This really scary for bears.

like

Hi newby here. I am international and only been in the US for a couple years so I wanted to ask a few questions about the chase saphire. What is the best way to apply for it to get the best deal? Any additional benefits beyond the 100k points? Is it ok to apply without an account in chase? How long does it takes to receive? What is the limit of the card? I am planning to buy something that is like 4,200 so I want to ask for the card but want to make sure I will be able to pay that much at once

like

Hi folks 👋🏻👋🏻

Anyone has blue points to exchange? I have 80 bluepoints. If interested then please let me know.

like
funnylike

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

If I book a flight on delta with points and then the flight decreases in points later on, can I cancel the flight and rebook to get the better price?

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

What agencies have the best washrooms? Bonus points for luxurious TP

like

Folks, very new to the EE process. Most recent draw cutoff was 75 points but there are still folks with higher scores in the pool. Does that mean candidates are picked based on time in the pool? A CRS100 could be picked over a CRS300 if the CRS100 has been in longer?

like

Just started and Keep being told by the analyst on 2 of my deals to stop using exclamation points and “Hope all is well”s. Objectively, I don’t overuse them. Thoughts?

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

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

More Posts

I always thought of Oracle as the evil empire, but for real, what's it like working for them?

Found an attractive posting and I don't want to pass up something good over an opinion I formed as a high school linux geek.

like

How much % yearly hikes MasterCard give to its employees for average performance?

like

Hello All,

Have a few questions regarding IBM Joining, HR response is strangely lacking and so does in the slack(prejoin channels). Hoping can be cleared here..
a) I've been told virtual onboarding is no longer a thing.
How many days does in-person onboarding activities occur?
b) HR Informed,"After onboarding is complete, can get perm WFH based on project or extension of WFH as IBM is flexible"
Is this true? Can managers extend/grant remote for a month then let us transit to remote model?

like

IT

Hello, not sure if I should move this to the Referral Bowl or here is good.
I have multiple years of working in Sysadmin/Tier 2-3 roles. Still experience trouble getting another SysAdmin role since I lost mine. I live in a state with plenty of work if sec-cleared. I cant get one.

Anyone work somewhere that could use an exceptional sysadmin, and that understands people aren't their past mistakes. Stuck back on helpdesk & want back to sysadmin
Have documented proof of work/performance

like

I am actively Looking for Job Change in UAE, Qatar having 2.7+ yrs of experience in Cyber security domain ,#cybersecurity, #networksecurity , #SIEM , Log analysis, incident response, threat hunting and vulnerability assessment.

Ready to relocate , Any leads could be helpful for me.

Hope to hear from you soon.

For further information please contact me.

Hello guys is anyone living in chennai nearest to tril infopark tharamani? I am looking for a pg please do let me know if anyone vacancy is there

like

How does everyone spin what happened today?

Post Photo
like

MAGA!!!
America first!!!
Winning!!!

Post Photo
likehelpfulfunny

I'm curious does anyone know any specific community for Indian tech people who want to immigrate? especially if they are going to immigrate to European companies.

like

Hi GL people ,
Are people who joined in this September are eligible for financial year increment that will happen in March 2023??
Thanks in advance .

like

Hi Guys,

I have an OL from LTI with a CTC-20 Lpa..As my mother had brain surgery, i need to be with her. i have asked HR to provide WFH. Does LTI support in these kinds of cases?? I have also asked HR to set up a call with the Project Manager.

Comments pls ..

like

Any experience with Frederique Constant? Seems like a good starter brand

like

What's God been doing in your lives? Struggles, goals, praises?

likehelpful

Post your favorite books atm mine are:

Atomic Habits by James Clear
Outliers Malcolm Gladwell

like

How do you answer “Tell me about yourself?” Is there a specific format you follow? Examples greatly appreciated! Thank you :)

like

We interviewed a great candidate, extended a verbal offer and she accepted. We sent the written offer a few days ago but she hasn’t opened it or accepted (it’s expiring tomorrow). Have you ever had to follow up? How did you handle it? My company is small with no HR, so I have to handle the hiring myself.

Is Bain Australia under hiring freeze? Recruiter said they won’t be hiring this year (Consultant role) but keep seeing job ads on LinkedIn

like

I am an AD at a WPP agency. I work 12 hours everyday and I’m handling one of the agency’s biggest clients. I have worldwide experience of 12 yrs, I get 100K. Is it because I’m not American?

like

What are the chances that PA with ctc 4.5lpa 2yoe who is on notice period gets a promotion and a on-site opportunity? How much of a hike should he expect if the on-site location is Canada?

Ik this sounds weird but i am in a situation like this.

like

I just started meds yesterday and the change in my focus and attention to detail is mind blowing. My only concern is, just yesterday I had a tough feedback session with my manager around how I’m taking too long to complete my work, giving them anxiety around close deadlines. I’m new in the job (3 months in). Should I explain anything about my adhd to my manager or just wait for them to notice the change in me?

like

Additional Posts in Excel Genius

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

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

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

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

like

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

like

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

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

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

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

Anyone know what these badges are?

Post Photo
likefunny

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

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

like

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

like

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

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

like

why is index match superior to vlookup?

likefunny

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