Related Posts
More Posts
Do not be distracted 🤝

I have had several rounds of interviews for a role at Visa London office. When I reached out to the HR to check on progress/status after what they called the "final round", they said everything is positive and then set up another round with the hiring manager last week. TBH, that round seemed as if they want to make sure I have understood the job well. And there has been radio silence after that. Any idea how to read this? I have another offer and deliberating if i should just accept that.
Additional Posts in Excel Genius
Anyone know what these badges are?

why is index match superior to vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.








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