On stressful days, I secretly enjoy cleaning up a messy dataset—removing duplicates, fixing typos, and getting it all to line up. Weirdly therapeutic!
Does anyone else find spreadsheet cleaning oddly satisfying? What’s your Excel de-stress ritual?

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

Was just thinking about the same thing few days ago… I thoroughly enjoy it.

like

Yesss you get it !

I like having time to spend building a couple of slides from scratch. No production, no AC help, just me, an hour or so, making those pretty pages

like

What a great exercise!

I love making formulas consistent.

like

Love consistency 🤩

You are my people. I find quantitation oddly soothing.

My excel guilty pleasure is a workbook called “lottery fun.” It lays out what I would do with an epically big jackpot. How much to preserve for personal wealth, how much to establish a charitable foundation, how to allocate the annual earnings from said foundation among my philanthropic priority areas. Excel plus wishful thinking.

like

yess that sounds awesome!!

That actually sounds really relaxing right now :)

Related Posts

How do you deal with your boyfriend still being friends with someone he slept with before? Kind of bothers me but not sure if it’s normal....

Deloitte USI Hi All,
How does the 2nd round of interview goes in PwC? Is it very technical ? What are the chances of getting rejected in the 2nd stage? HR told me that would be the final round. Need your help asap.
YOE : 9
Tech stack : Data engineer, data warehousing
PwC PwC India Pwc AC EY Deloitte USI Deloitte India Deloitte KPMG India

Everyone working in SEO: what do you do day to day? I am looking at moving SEO in-house instead of the company we have now, but I don’t know where to start. Tips?

like

Do I put these succulents in soil now? What’s next?

Post Photo
like

How is the price of equity calculated while giving an offer? Is it the price as of date?

like

Has anyone successfully moved capabilities? I work in Client Service Delivery and am aligned to PMO. CSD is a mix of PMO and SC but it seems like we do the same work for different pay.

Looking to take the CISA exam. I have over 5 years of audit experience. How long do you think it’d take to study? Also, what study material should I use? Any good boot camps you’d recommend?

What are the pros and cons of joining a Captive Organization for Salesforce ?

It is true that in service based consultings the learning curve will be better coz we'll get to work on a lot of projects compared to a captive organisation ?

How should one decide? Can someone list out the pros and cons of both. It would be really helpful for a lot of people.

Thanks in Advance!

like

Anyone ever have experience negotiating a new offer to include unvested 401k match and stock grants from your current employer? I hate leaving money on the table but there are some good roles out there. I’m not fully vested in my current 401k yet and my stock grants haven’t matured yet either. This would be at a global director level.

Google S&O manager total compensation expectations in Bay Area ? Please suggest numbers as I need to negotiate soon, thank you.

like

Offering advice to job seekers who go around recruiters and message hiring teams, execs, etc. You are putting the Recruiters job in danger. If a Recruiter declines you or doesn’t choose to reach out, it is because the hiring team declined you, or you don’t have the experience. You will most likely not be considered for future roles because of this. When I see people giving advice to reach outside the Recruiter, it’s bad advice. Very rare is this a good idea.

like

I’m a PR manager with 5 years of experience and have been applying for copywriting, project management and comms strategy positions with no luck. I’ve been applying since April and have only had 2 interviews. Any advice on how best to transition or what other fields I can look into?

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

Hello People,
Please post or reply with good consulting firms that could help in getting jobs in and around Hyderabad. Thanks in Advance.

like

Help me out - I'm starting a HedgeFund. I'm calling it ____________ Capital.

like

What is the difference between financial due diligence (FDD) and delivering deal value (DDV) at PwC?

like

How much Joining bonus @eli lilly offers if joining in <45 days?
It has clause that we need to return amount if leaving before 1 year or 2 year?

Do they provide relocation bonus?

@eli lilly company

like

Which has more listings: Zillow or StreetEasy?

like

Additional Posts in Excel Genius

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 have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Anyone know what these badges are?

Post Photo
likefunny

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

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 have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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

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.

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

likehelpful

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

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Still don't have xlookup. #fomo

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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