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

Hotel or corporate housing? Benefits and drawbacks of each. This is for a long term engagement in Denver. I really like getting my Marriott points, but wouldn’t mind staying some weekends in Denver.

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

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?

Lifetime SPGer who is staying at a Marriott hotel for the first time. Platinum gift is 1k Marriott points (vs 500 spg points) and the green choice is 1k points for the whole stay (vs 500 per night)...

like

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

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.

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’s the best credit card for points in the UK. I’m from the US and have the Chase Sapphire Reserve and the Marriott Amex

like

Random, but valid/persistent thought.

After 2 years of a pandemic and working independently for many years, I am not feeling interviews AT ALL. There are points in the interview where I want to just say "Look! Either hire me or don't".

How can I get over this feeling? I'm over the whole "stand in the line of fire to prove how good I am" bs. Any recommendations for getting over this or possible industries to pivot into to avoid bs interview processes and ghosting?

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

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

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

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

Planning on opening a Bonvoy boundless chase cc for the 75,000 points and have heard the first year is free. Is that right? If it is, do I still get the 75k? Are the 75k Chase points or Bonvoy points?

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 ?

More Posts

Did Deloitte disable Spark, the email app?

like

Bloomberg Law or Practical Law if you had a choice?

like

What’s the fastest/youngest you’ve ever seen someone make partner?

likehelpful

Can I waive into other UBE jurisdictions using my NY UBE license at any time? Or is there an expiration date for my bar exam score, after which point I won't be able to waive in?

like

Anyone interested in practicing casing? Please feel free to drop a burner.

like

Does anyone in LA want to practice cases?

Looking for some trusted voices and resources. Who do you follow for D2C Customer Engagement & lifetime value?

like

Any NJBs out there?

like

Hi all,i have been taking interviews for my department since the last 3 months.Should the company be paying me for the extra efforts?

like

Hey, another question for y’all. How should I reach out to a recruiter who offered me a full time position but I rejected for a better offer? At the time I was offered the position my main concern was lack of guidance/support from leadership. Now, a year later I have experience being in a role with limited over site (not as scary as I initially thought it would be) and feel confident I would excel in the role I rejected. How would you approach this situation? Thanks in advance!!

like

I work in sales as a coordinator and do a bunch of paperwork with customers online. I LOVE PEOPLE but dread going to work everyday (wfh 3x a week) because the environment is toxic. I just found out that the only positive manager on my team is leaving. I am spiraling. I have a BS in Health Science (no chemistry classes taken and minimal biology education). Where are people happy in their careers? What careers are best for young women with ADHD? Who’s hiring?

like
like

30 July was special.
Salary credited. Tax debited.
Both were equal.
Ab pura August daal-chawal khaake!

funnylike

Is tech product manager work similar to PMO or do you do more than that?

like

No recruiters reaches out to me on LinkedIn. I chalk it to mostly because I’m not in Tech, but what am I doing wrong? How can I make my profile more attractive to recruiters?

like

How does globallogic selects candidates for Ascend program. I looking for opportunity in java domain. If anyone can reffer me for java Ascend program it would be helpful.

The unending cycle is for real. Reached my LeanFIRE number 2 months ago, yet I don’t feel satisfied. Still reaching for the stars… when will this human desire end?

like

Which is the best option - Oracle Financial services or Accenture

like

Hi
I have received an offer from a company and I'm in the second stage of interviews with another company. I am very interested to see if I could make it through for the second company. So can I accept the offer from first company and then if second one also sends an offer then let the first company know I would like to reject? Also i am on H1B visa. Should I be concerned with that?

like

EY India Hi all
Which is better in terms of wlb?
EY India OR EY gds

like

Additional Posts in Excel Genius

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

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

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

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

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

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

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

like

why is index match superior to vlookup?

likefunny

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

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

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

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?

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

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

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

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.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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