What’s the funnest or weirdest thing you’ve ever used Excel for outside of work, and did it actually work out the way you planned? I've been working on a fantasy football tracker with Excel, complete with team stats and player profiles. It started as a small project but ended up becoming a full-on dashboard with filters and charts.

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

Trick or Treat is still pretty big in my City and I give out full size candy bars.

I use Excel to track Halloween Candy bought and then what candy people took. I did this to understand what candy is popular so I don’t have as many leftovers at the end of the night. Surprisingly, the kids wanted candies like sour skittles and nerds gummies more than anything else. I didn’t track the times each ran out though.
This year, I’m going to track what time each candy type sold out to understand what to buy most of and what gets taken last so I can buy less or none of those.

like

I use it to track my cats eating habits.

like

My kids and I used Excel to decode Gravity Falls ciphers.

like

Honestly, I used it to create a renovation design for my home, all cells 1:1 to represent 0.5m by 0.5m, which allowed me to put walls in pretty easily and show where all renovation needed to occur to give to an architect rather than describe it. Would recommend!

like

So much fun! Thanks for sharing this! You’ve expanded my mind with your interpretive flex of what excel can be. I’ll want to try this too!

like

One colleague created a spreadsheet to objectively evaluate individuals who were proposing marriage, with criteria and scores

like

And before you asked...no, I won't share it lol.

But… but… plz? 🥹

One of my coworkers has made an extensive spreadsheet for fantasy football as well. 🤔😂

A water chemistry and additive table for beer recipes by style. Works really well, but I have to import a lab analysis of my well water each year.

Related Posts

Hello Fishes , I recently got the offer from Infosys . I am not getting what would be my Net salary,Can anyone help me with this ?

Post Photo
like

Wishing PDX had a bigger ad scene so I can relocate 😩 I love this city

like

Hello to all b4 🐠 - what's your view on the cultural differences between b4 in Australia? Feel free to put down a ranking to your best knowledge, anecdotal or not. Thanks!

like

Any recommendations for trip for July first week. With a 1 year old. Thinking international, leaving from NY.

like

I am looking to identify committed Christians within Deloitte who would be interested in serving on the US board of a global non-profit committed to restoring the lives of those who have been traumatized via human trafficking or gender-based violence in SE Asia. Deloitte has been instrumental in partnering with Hagar International via pro-bono consulting and we would love to leverage this partnership on our US board.

likehelpful

Have a 2 year project for Romania which will be extended, what are the Pro's and Con's to move there?
Also need to decide if i need to take my wife and 5 year old kid there...
Any links and suggestions please..

Any advice for a vet looking to get into federal consulting? I’ve got a TS/SCI with poly and several years of experience in change management and process improvement.

Do you broach pronouns with your team? How do you approach that conversation?

like

Halloween costume ideas? This will be my (👩🏻🏳️‍⚧️) first Halloween presenting female (so apologies in advance if this is off topic for this group). Trying to stay away from sexualized costumes or anything too elaborate. All suggestions welcome!

like

Hi Fishes,

Can you please confirm how long does the joining offer ( provided by PWC ) remain active in workday portal?

Any one staying in kumar park infinia, Fursungi and working in Barclays Kharadi?
Need quick information on travelling !! Please help

like

Been at Paychex(payroll) as a channel rep for 3 years. 70k salary and 110k max with commission. Love WFH but need more pay. Want to leave for more money, what's out there and what should I look into? I work I. Bay Area CA

like

Anyone works at PHD media grp? Any idea how much media planning manager makes in Toronto?

like

Have an interview with Sixth Street Partners and coming from consulting. Any idea what to expect?

like

So is the Friday night ritual a pic thread in this bowl?

like

Hi guys.

How is the KGS in terms of growth and learning. There are lots of negative reviews on Google.

Can you help me in this ad my interview is scheduled next week with KGS.

like

Hey everyone! New interesting (REMOTE) job opportunity! Potential candidates must have background knowledge on disability/accessibility services as it relates to technology. 5+ years of experience in UX/UI required.

Need help here,
Due to health issues I resigned from paytm in just 2 months.
5.2 lpa was the CTC.
Which skill i can learn that lead me for a higher package.
Total YoE : 3.5 years
Knowledge: SQL, Clevertap(basics), Digital Marketing

please help me here

like

Any one looking for a job in Banglore.

YOE:- 3+
SKILLS:- ETL, Data Modeling, Dimensional Modelling
Company:- Deloitte

like

Hi,

I will be joining PWC AC bangalore soon.
Is there any policy for higher education support(executive mba) or support/reimbursement for certification like TOGAF, scrum, PMP or other certification to take our career development forward.

Thanks

like

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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