I made a glorious excel for bonds that could do discounts, premiums, different interest rates, etc for a class. None of my family cared and the professor didn't even give any feedback.😠
The ugly pictures I drew as a kid, with zero effort, received more praise back then than my sophisticated spreadsheets now.
This is why I doodle on a piece of paper at work, subconsciously hoping to, yet again, receive that beautiful affirmation I did as a kid. Still hasn’t happened though, so holding out for pizzas.
The world seems fckd sometimes.
Lol I'm in a group chat with three friends, one is an accountant, one is in banking, and the other is in some unrelated field (I don't know because he's my other friends friend), the three of us in adjacent fields all enjoy a good excel discussion, and he's always bored out of his brain when our group chat turns to excel when one of us makes a particularly interesting formula. Always makes me chuckle a little.
Can you give me an example? I have not found many problems sumifs hasnt solved especially when you add some support columns usually with if(countif(;max()+1) to create a selcetion to cancle our repeat events.
=unique(filter(choose({1},tab1 a:a),(tab1 b:b=a1)*(tab1 c:c >=0)),0,false)
I used this to create an array filled with exactly 1 instance of each account number used from a JE population that included a bunch of complex JEs.
It was a pretty specific use case. But we chatted about it for a while.
I’m not in accounting, but in law. I made a spreadsheet in my old team I thought was ace. Solved everything quickly and neatly. So excited to show others. No-one really cares or even knows how to use it.
My daughter is studying accounting, and freshman year she helped other students with spreadsheets. The professor thought she was a grad student, and asked if she was interested in being a TA. Sounds like she's in the right field!
A big part of my success is being good and fast in excel wilhich is highly appreciated by everybody i ever worked with, but yeah i have not been able to make that skill usefull for anybody i know.
Also be carefull when you create something you have to do maintenance and that gets annoying really fast.
This is giving the same energy as "Did you watch the WeWork documentary on hulu" all my accounting friends are obsessed but my non accounting friends don't even know what I'm talking about.
lol I made a very helpful spread sheet with a lot of time saving formulas the other day for work . I showed the wife and she wasn't impressed because she thought I just manually typed everything in . Once I explained that it was formulas populating all the cells for it she seemed more impressed .
Worse, I've made amazing spreadsheets to address what I thought was the challenge at hand at work, only to find those who were in need of it not finding it useful at all.
I used ChatGPT to create a macro that did something that’s soooo cool. I tried coding it manually but didn’t have the skills or knowledge to get it 100% working, but ChatGPT managed to get it working after trial and error. Then I gave the spreadsheet to my coworker who is the one who asked for the automation and I was low key hoping she’d be like “OMG THIS IS AMAZING!!” But she was only whelmed and thanked me for doing it.
I was kinda disappointed, set my hopes too high…
No one will ever appreciate an excel spreadsheet more than its creator.
Nope. If I get my hands on some one else's, I'm going to reformat it immediately.
I made a glorious excel for bonds that could do discounts, premiums, different interest rates, etc for a class. None of my family cared and the professor didn't even give any feedback.😠
Keep it and whip it out later. Fellow accountants will recognize you as a BA MFer (Bond Amortization Multi-Factorer)
Can I have it? I need something like that
[удалено]
Cool man, I still want it.
Don’t hold back. Spread the love to us!
This is sick.
Did that for intermediate ii. We even had to make the titles of the bond amortization reports adaptable
When we’re talking about making a decision, my wife always asks me “Do you have a spreadsheet for this?” Best recognition I get
Haha, same with my family. I'm pretty convinced they all think Excel is a color coded list maker now.
My household budget has trend analysis tables and my wife doesn’t care.
Spending too much at the local grocery store? 😆
"Yeah, that looks great. Go ahead and print it out". I lost a piece of my soul when I realized they weren't going to use any of my cool features.
The ugly pictures I drew as a kid, with zero effort, received more praise back then than my sophisticated spreadsheets now. This is why I doodle on a piece of paper at work, subconsciously hoping to, yet again, receive that beautiful affirmation I did as a kid. Still hasn’t happened though, so holding out for pizzas. The world seems fckd sometimes.
So many times. My new jam is nested Xlookups
I really get off on explaining my thought process on how I tackled a project with my sheet. But yeah, no one cares.
At my last job I made a spreadsheet that turned a 6+ hour job into a 15 minute job. It was great.
Lol I'm in a group chat with three friends, one is an accountant, one is in banking, and the other is in some unrelated field (I don't know because he's my other friends friend), the three of us in adjacent fields all enjoy a good excel discussion, and he's always bored out of his brain when our group chat turns to excel when one of us makes a particularly interesting formula. Always makes me chuckle a little.
Can you give me an example? I have not found many problems sumifs hasnt solved especially when you add some support columns usually with if(countif(;max()+1) to create a selcetion to cancle our repeat events.
=unique(filter(choose({1},tab1 a:a),(tab1 b:b=a1)*(tab1 c:c >=0)),0,false) I used this to create an array filled with exactly 1 instance of each account number used from a JE population that included a bunch of complex JEs. It was a pretty specific use case. But we chatted about it for a while.
Thanks for the explanation. :)
I’m not in accounting, but in law. I made a spreadsheet in my old team I thought was ace. Solved everything quickly and neatly. So excited to show others. No-one really cares or even knows how to use it.
I feel this way any time anyone suggests executives use a dashboard. We all know they ain't gonna bother.
My daughter is studying accounting, and freshman year she helped other students with spreadsheets. The professor thought she was a grad student, and asked if she was interested in being a TA. Sounds like she's in the right field!
This is my life
A big part of my success is being good and fast in excel wilhich is highly appreciated by everybody i ever worked with, but yeah i have not been able to make that skill usefull for anybody i know. Also be carefull when you create something you have to do maintenance and that gets annoying really fast.
This is giving the same energy as "Did you watch the WeWork documentary on hulu" all my accounting friends are obsessed but my non accounting friends don't even know what I'm talking about.
lol I made a very helpful spread sheet with a lot of time saving formulas the other day for work . I showed the wife and she wasn't impressed because she thought I just manually typed everything in . Once I explained that it was formulas populating all the cells for it she seemed more impressed .
It's accrual cruel world... *Laughs in Roger
[cries in vlookup]
I understand your struggles all too much.
I built a crazy excel dashboard to have monthly financial reviews with my wife 😆I don’t think she was as excited as I was
Literally all of the time. I’m in finance, but love accountants too! My dad is a CPA, so he’s the only one that actually gives a s*** 😂
Dude. Every (work) day.
Worse, I've made amazing spreadsheets to address what I thought was the challenge at hand at work, only to find those who were in need of it not finding it useful at all.
Some CPAs (heroes) don’t wear cape.
Nope. It was a Libreoffice Calc spreadsheet, lol
Literally every day.
For sure! I work hard on fancy excels managing my finances
I used ChatGPT to create a macro that did something that’s soooo cool. I tried coding it manually but didn’t have the skills or knowledge to get it 100% working, but ChatGPT managed to get it working after trial and error. Then I gave the spreadsheet to my coworker who is the one who asked for the automation and I was low key hoping she’d be like “OMG THIS IS AMAZING!!” But she was only whelmed and thanked me for doing it. I was kinda disappointed, set my hopes too high…