Coolest, best, or nerdiest thing you've been able to do with Excel?

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

Learning how to use Power Pivot to analyze millions of lines of data! I know it’s not the most technically advanced thing, but I’m generally a pretty vanilla excel user (good with formulas and clever tricks but stick to those rather than macros/VBA/etc.)

like

Bc i do not know how, nor did i know the extent of capabilities of either option at the onset of my being forced to expand past my “vanilla” excel knowledge.

I started making YouTube videos of fun and kind of pointless excel stuff while playing lofi or instrumental music. I got 6 subscribers 🤣🤓 it’s fun honestly

like

Nah no one specific. Just favorite #exceltok and the algorithm should promote things like that.

like
Recent IconRecent

Changing the clients world with the press of one macro button 🤯🤯🤯 and being called the master of dark arts 😂

likefunnyuplifting

Was considered a high performer on a project because I am lazy and built a macro to do all my work...

likeuplifting

Awesome. I’ve been in the same boat. If necessity is the mother of all invention then laziness is the father. Nothing wrong with that!

Closed it out

likefunnysmart

Stop using excel, showed the partner airtable, then showed the client and got them to buy the SaaS

like

Alright you’ve convinced me. I’ll try it. Thanks!

like

Someone creates insane pixel art using only Excel. I think it was video game characters or something

likehelpful

Run a multi billion dollar trading book

Combo of MS SharePoint query connections, metadata/table mgmt, dynamic indirect referencing, limited macro functionality to polish it up, and the ability to auto-build new merged tables using dependent dropdowns for the user on the front end

Being able to automate multiple jobs through Macros. People are usually impressed about the “effort” but it’s just because I like doing as little as possible 🤷🏼‍♂️

I made a pick list once

There's this macro that doesn't let the user close the excel file so I sent it to my coworker as a prank with a popup message "We have detected signs of illegal malware. Please do not close this file until cyber security arrives for further assistance."

Related Posts

Guys ..
When will final settlement take place? What will be the components of it?

What questions should I expect on techno managerial round ?

Thoughts on having a baby 👶🏾 with a surrogate in West Africa or the Caribbean ? Also looking towards Mexico.

like

Thoughts on dark chili color dress shoes with black pants?

Best performance quarter zip sweaters for men? I like Peter Millar’s golf apparel but not looking to spend that much again

like

Any official update on pune office address apart from the one in Viman Nagar?

2019 grad in big law entertainment litigation, thinking about exit options. I don’t think I would like transactional work very much, but am nervous that if I stick in lit too long, my in-house options, particularly within entertainment and/or FAANG are going to be extremely slim. Any advice?

like

Its been two weeks since HR confirmed my selection and no CTC breakup letter has been sent. Is it normal or there is a possibility that management can revoke my selection? 12 YOE , Azure Skillset, 22 LPA requested.

like

Hi everyone. Hoping to chat to some Roland Berger people regarding their experience at the firm, and specifically about the Senior Consultant role aligned to the Aerospace & Defence industry. Coming off a career in the military along with a recent MBA qualification. Any RB people out there willing to have a chat? Thanks all Roland Berger

like

24 yr old, 110k TC, maxing out Roth IRA and Roth 401k, no debt or large expenses. Also have ~35k sitting in a bank account. What should I do with that money?? Am I better just sitting on it for a while then watching it shrivel up in my brokerage account?

like

What were some of the challenges you had to deal with when you first started working abroad? I’m in the middle of interviews and hoping I get an offer so I could work abroad 🤞

like

Which RPA vendors do you think are targets for acquisition?

likesmart

Is it possible to get High CTC like 20lpa+ who doesn't belong from a development background??

like

I've got $130k should I put it in index funds or bitcoin?

likefunny
like

Relocating to Boston for consulting, would love any recommendations for local tailors for dress shirts & suits. Thank you!

like
like

Hi people, what would be in hand salary per month based on this below salary structure? Total fix salary is 16 lpa.

Post Photo

Why are all of the chocolate bars horny on Twitter today? Do social posts not go through an approval process beforehand?

likefunny

Additional Posts in Excel Genius

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

Best way to visually display trending data on sales when looking at how a few factors influence volume and price? Also any tips for including both in the same chart?

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”

likefunny

So xlookup? How is it going for you? Still haven’t use it.

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Looking to set up conditional formatting to indent a cell if another cell has a certain number of characters. Please see comments for details.

Post Photo
like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Hi,
I am trying to match in a specific row of a different sheet, although I want to use a calculated row value to specify the array to look in, see the photo for the logic I am trying to do… any ideas on how to get this to work?

Post Photo
like

Does anyone know how to reformat a date from yyyy-mm-day to month-day—yyyy?

like
like

I wonder if there is a quick guide for excel ??

like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

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

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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