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

Started as a BDR and got moved into partnerships within the same org. Comp was initially 75k CAD with OTE 120K CAD. New comp for new partner channel I am carving out, I am offered same base but guaranteed 75% quota attainment payout. Is this a fair comp? Would love any constructive thoughts/points on this. Company is in eComm vertical

like

For people with Non-technical backgrounds who are now Product managers in the Tech industry, what kind of resources did you use to prep for your interviews? I've had people recommend brushing up on cracking the PM code but there's SO MUCH information out there and it's hard to figure out if I'm looking at the right thing or not. Please share resources that helped you get into PM roles (bonus points if you work at companies like Amazon and Google).

like

Is anyone annoyed that accolades has oddball pricing like 106 for a gift card and you need to pay $10 for 10 points. You can’t just get 6 points?

likesmart

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

What are the best credit cards for travel points?

like

Need a recommendation for a contract analytics service provider. Don’t need the lifecycle or repository bells and whistles, just need something I can feed 10k documents and it provides me with data points, preferably individually and in aggregate. Does something like this exist??

like

hi fishies! I'm wondering what people think about ESG investing and how much ESG metrics / data points impact your decision to invest (or not invest) in a company? Would you find it helpful to see things like "percentage of women on the board", "ceo pay" etc. within an investment app before making a decision to purchase stocks from that company?

Would you rather have 5x amex MR points or 3x chase UR points for each dollar spent on flights? Why? Company let's me book flights on personal cards and trying to decide which to choose.

like

Failed REG by 2 points... I feel defeated and honestly don’t know if I can do this anymore

like

Looking for recs for best bang for the Bonvoy points hotels outside the US? I found the Rayong Marriott for only 17,500 points (not sure if it’s nice in person) but that’s what prompted this curiosity

What’s the best use of bonvoy points?

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

Turned away from my weekly hotel at midnight bc they can’t find my res and are sold out. Res w/ conf number actively shows in Bonvoy app, they can’t figure out issue. Platinum elite. How many points?

like

What all are the benefits IQVIA provides. Need to understand on below points-

1. Leaves
2. Meals
3. Transportation
4. Medical benefits (like dental, optical)
5. Allowances
6. WFH
7. Bonus that excludes from CTC and variable
8. Annual/Half yearly parties
9. Goodies or gifts during major festival
10. Anything else 😅

like

My favorite part of consulting is helping the consultants I manage improve their public speaking by designing talking points, reducing their fear or anxiety around speaking, and improving their executive presence.

I read about people on this platform needing help in these areas. At the same time, I’ve been wanting to spend more time helping more people with these topics. If anyone would be interested in sharing about their public speaking-related challenges, feel free to DM!

likeuplifting

Bathroom smells of cig smoke and they can’t transfer me to another room till tomorrow. How many points?

like

What’s a good Marriott Bonvoy points vs $ conversion to make decisions on using points or $?
I’m contemplating 40k points vs $168 including taxes at a category 4 location

Had two flights, booked with CSR points, overseas in April, one on Singapore air; after that was cancelled by Singapore Air I booked another flight on Lufthansa. Numerous attempts to contact CSR and

like

Delayed 6 hours ORD -> JFK (Delta Platinum) - how many points?

funny

Port ops senior associate comp benchmark at mega fund? Anyone have reference points?

like

More Posts

What is caregiver leave in bny ? How to opt for caregiver leave? Any medical proof required for the same?

like

Best Bumble/Hinge Profile Intro- GO

like

Forget Secret Santa presents and gifts for your SO, the real question is what are you getting for yourself for Christmas?

like

What’s your take on Ackman’s CNBC interview in light of his bet on credit spreads?

like

Which one to choose from below:
1. Publicis Sapient
2. Hexaware Technologies
3. Wipro

Tech Stack - Salesforce
YOE - 6.7
Note:- Each of them paying similar.

Thanks 🙏

like

Hii all, I got an offer from KGS as Associate 2, with 8lpa, should I accept the offer?

like

Can Somebody refer me for SAP SD position in GSK? I have applied twice in portal and it is sitting at recruiters review

Any single lipstick lesbians here, what to chat 😉?

like
like

If i do 1 year post graduation diploma certificate course from canada (online or offline) and at the same time I do a full time job in canada of 40 hours/week (may be few months diffrence but they will be overlaping). Can I put both of them in PR application?

like

Recent Christmas gift from life coach.

Post Photo
likeuplifting

Hi All, After HR Discussion its around more than 10 days i have not received any offer letter and HR is not replying on mail too.

Did anyone faced same issue.

like

I just got an offer at McKinsey and I was wondering if the base pay is the same across all first year BAs or if there is typically room for negotiation this early in the career. What other questions do I need to be asking?

Anyone have recommendations for headhunters in the Los Angeles area? Industry agnostic.

like

I’m a Junior accountant, recent MBA grad in Finance, located in NYC, just got laid off due to a merger. Anybody hiring or know any opening positions?

like

Hi All, I have an offer for SA - Agile Program Management . Have few queries:

What is typical wait time on bench to get projects (for non Java people)?
Are there any salary deductions on bench?
I heard Sapient have fired people on bench in past. Some have mentioned it is no more a practice currently. Need insights on this?

Thanks in advance.


like

Is thought works a good organization to join , in terms of job security and work life balance ?

like

I have been interviewed and selected for a role in EY UK. The status of my job application is “congratulations on receiving an offer from EY”.
However I have not received any email yet.

Can someone confirm which team sends the final offer coz the HR is saying that he has processed everything from his side.??EY

like

Looking for a public sector consulting project in BA role. Any leads?

like

Hiring in EY India for below roles: 1) Java + AWS Developer 2) ETL Developer 3) Python Developer 4) Project Manager. Interested candidates do send your resume here : 22monfire@gmail.com I will refer
EY Deloitte Accenture Tata Consultancy

like

Additional Posts in Excel Genius

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

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

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

likehelpful

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

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

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

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?

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

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

like

If you have never created a macro, any tips on where to start? Any good Udemy courses or YouTube videos?

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