Anything cool you have done with excel?

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

I keep making tables, and they keep giving me money

likefunny

I nest a formula and everyone goes nuts.

Completely serious

likefunny

I have a hinge profile prompt about how much I love excel and it gets me hella matches

likefunny

It definitely is, all the responses are about excel

At one point I used it for a dirt simple analysis on where I should go for vacation. Pulled up a list of ~30 Marriott resort properties and had columns for points cost, round trip flight cost, and hotel rating. Did a shaded red/green color coding across the criteria and funneled the list down to three properties which were dark green across the board.

Took maybe an hour of mostly data collection and managed to get an economical and super enjoyable vacation

like

In the Korean Army we didn’t have internet (only intranet). Some Korean programmers made Tetris on Excel out of sheer boredom.

likesmart

I wouldn't really call it "cool" per se, but in my 20s I built a very detailed multivariate retirement projection spreadsheet.

If memory serves, I modeled geo pay differential, inflation, investment growth rate, comp growth rate, social security, pension projection, HSA, family expenses, tax rates, and a few other data points I'm probably forgetting.

I had it set up so I would just update a few data points each month (e.g. family expenses, comp, investment rate, and a few others) on the first tab and it would spit out retirement scenarios based on year of retirement.

Alas, this was before the days of OneDrive and stuff, so it was lost when that computer but the dust and I never rebuilt the spreadsheet.

like

And here I am, still trying to figure out how to freeze panes without fcking up the whole sheet 🤷🏻‍♀️

likefunny

https://youtu.be/8uoevnP-aho

like

https://youtu.be/AWgMyPFYGlY

like

I did an =FV calculation that told me I’d be working till I was 70, or need to start contributing 30% to retire by 60.

likefunny

Me make slides.

funny

Goal seek is useful when you need to optimize quickly

like

False, you don’t work properly for it.

funny

I created a “dark mode” template well before it was cool.

like

On excel? Does it work well?

I made it to not work for whole 30 mins as I had 30+ workbooks opened at a time and it didn’t save my ongoing work so I had to sit for another 6 hrs to recreate it.. just me and my excel stories!

like

Close it and use a better data processing tool

like

There is cool excel art if you Google it. Some animated though macros.

With excel and python. I used Python to read a certain type of Outlook email that was coming in about 100 times a day that carried excel data always in the same format. The script read the read, created a compiled report, Deleted the email and moved excel file to its final destination for record keeping. Eliminated ~1 hr a day of mindless document moving for 4 people + generated insight (summary doc) that we never had

Related Posts

The call volume on 200C for this Friday is comical... yes this was also GME post.

like

Been here about a year. So disappointed at the work culture here. Everyone just wants to push back and get no work done. I was left in tears today. Abrasive, condescending, and rude people everywhere.

like

Speaking of boutique firms. What's the name of the trendy millennial one with crazy health benefits that was ranked #1 recently for fun and WLB? I think it was in PA and did primarily healthcare...

like
like

Company - Attra Infotech

Location - Multiple

Exp. - Multiple

plz DM

Post Photo
like
like

Has anyone had experience managing someone significantly older then you? I’m struggling to provide feedback and with being able to communicate in a way where she isn’t personally offended. Advice?

like

So how did you end up doing this shitnin the first place?

like

What are the different designations for BA4 in India?

like

Hello! I’m a Copywriter currently looking for a junior AD partner to work with me at Droga5. If interested, please message me. Thank you!

like

Anyone here from NYC? We should all plan a happy hour or meetup! DC and Atlanta blacks always doing something lol

like

Hello, I’m a Senior Software Engineer with over 17 years of experience. Primarily worked with the Microsoft tech stack, but also worked with Java and Python. If you know of any opportunities please feel free to reach out. Thanks!

like

Hi fishes, can anyone refer me for Senior Java Developer Role in CISCO banglore ?
I am an immediate joiner. I have applied through jobs portal but I guess cisco recruiting team take 20 - 30 days to start the process if not reffered.

Thanks in advance.

like

Truth be told I have never been through onboarding via remote. It’s a bit of a struggle. It’s taking forever to get access to certain resources and my assigned mentor is always underwater. How is everyone dealing with this? My manager seems hard to please in our first couple 1:1s.

likehelpful

Any good shows to binge?

like

Has anyone partially funded college for their children with Roth IRA withdrawals? I think withdrawals for education expenses are not subject to penalties for early withdrawal. Did your children get "penalized" when applying for scholarships because their parents had Roth IRAs to fund some college expenses? Considering routing 529 contributions to a Roth IRA. If my children don't go to college, at least I have more retirement savings.

like

So finally got my standing desk set up. Got a birch butcher block from Homedepot,stained and gave it a few coats of poly.

But its been a few weeks and the smell of the poly is strong when I'm near the desk. I can't stand it, does it eventually go away? Anyone have expertise on this? Tia!

Post Photo
likefunny

Has anyone tried press-on nails and recommend a certain brand? I love having my nails done, but the salon acrylics, dip powder, etc just ruins my natural nails.

like

But why is no one talking about the fact that KPMG took gifs off of teams. This job just gets worse and worse.

likefunny

Additional Posts in Consulting

Leaves call with “thanks everyone”

Post Photo
likefunny

Who’s got book recommendations? No lame “business guru” books that repeat the same principle over and over again.

like

BCG folks, I hear rumors of layoffs happening given the slow pipeline. Is it true?

like

Worked really hard on some work only for it to be discarded/not get utilized. Super demotivated right now...how can I change my mindset to feel better?

like

Time sheets my dudes

likefunnyhelpful

Looking for advice - what are the pros and cons of leaving consulting & moving to a tech firm in the west coast as a senior data analyst. Looking for inputs from fam who've made this switch. Thanks!

like

Just told my manager to respect the holiday after she texted me. I feel so alive right now

likeupliftingfunny

I've been asked to share my insights and long term plan for my role in our business. I am actively looking to exit and have been for the last six months. 😬

How would you approach the conversation? Do I have any option other than straight up lying? In previous roles I'd have been comfortable being honest about wanting to move on but I feel like my manager will take it personally that I want to leave and be a bit of a drama queen about it...

like

Any tips for someone coming into Big4 GPS consulting as an experienced hire from industry with no consulting experience? Trying to make the transition as smooth as possible but I’m sure there will be a big culture and operational differences.

like

Speaking of boutique firms. What's the name of the trendy millennial one with crazy health benefits that was ranked #1 recently for fun and WLB? I think it was in PA and did primarily healthcare...

like

So finally got my standing desk set up. Got a birch butcher block from Homedepot,stained and gave it a few coats of poly.

But its been a few weeks and the smell of the poly is strong when I'm near the desk. I can't stand it, does it eventually go away? Anyone have expertise on this? Tia!

Post Photo
likefunny

eat alone at restaurant or at hotel room?

like

Is working at MBB in 2022 still makes sense? I bet it was a huge deal back in 2000s , but right now when there are so many great startups, FAANG, etc

like

If I move to a town a few hours away from my home office, how often am I going to be expected to go into the office on fridays? Seriously considering a move to the beach for my own sanity

like

Ladies, recommendations for work bags that fit laptops and are good for travel (ideally not Tumi or Lo and Sons)?

like

Any candid insight from those who went from a big firm (Deloitte, Accenture, etc) to Slalom? How are you enjoying the technical projects and do you often have to drive to a client?

like

How would you compare/rate Mercer with Big4’s?

likefunny

Book recs? I love reading self-help books but sometimes they bore me. Any good fiction series out there that can get me reading more often?

like

Seeking a restaurant recommendation in San Francisco Chinatown. Someplace higher end that’s not too touristy for a family trip. Any recommendations appreciated!!

like

Electric standing desk recommendations for home office?

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