yes but only if you use your skills to train women in finance how to use pivot tables. better get on it though, i can see AI making stuff like excel extremely simple to use in a few years.
Yes. Especially nested functions, you can perform black magic with the right combos and automate what would otherwise be extremely time consuming calculations.
Pretty much this. If you get good enough you can basically Google anything you need to do and modify the formulas to do what you need. Knowing VBA or python is also super helpful, but not necessary. I’ve basically earned a 12 year career from knowing Excel. Just broke $100k this year. Been fully remote since the scamdemic.
Did a internship and used excel for data analysis by putting raw data sets in excel and using formulas. It made me invaluable for the management team, practically begged me to come work for them.
Pretty much this. If you get good enough you can basically Google anything you need to do and modify the formulas to do what you need. Knowing VBA or python is also super helpful, but not necessary. I’ve basically earned a 12 year career from knowing Excel. Just broke $100k this year. Been fully remote since the scamdemic.
Thanks for your insights, anons.
I've realized that most people, even executives don't know how to use it. I'm talking people like managers and VPs. It's unbelievable but I've seen it myself at work. How they get there without knowing excel is beyond me, but if I can learn it very well and provide them Info they can use to make strategic decisions, perhaps I can also become invaluable
What more can I learn that’s useful other than =SUM(a1:a100)? I’ve developed a nice tidy sheet for my accounting and I don’t need software but I don’t understand what else could be useful.
Excel is a bit of a rabbit hole, particularly once you start learning VBA macros. I'm an engineer so most of my stuff is job-specific, but I've done all kinds of things like: >A program that spits out format-matched graphs when you have hundreds of different data sets (in different files) from different simulations >A program which graphically shows requirements tracing from one document to another, letting you view it all in one spot >A program which looks at existing test results to predict future reliability failure rates and the chance of passing the test
Picrel is a macro-free spreadsheet which figures out the price I bought or sold crypto at in my local currency (when trading from other cryptos) and uses a FIFO system to calculate my tax liability. Made in LibreOffice Calc rather than Excel, so fight me.
Once you know even basic Excel, other people (particularly finance types) see you as some sort of demigod. I used to even make spreadsheets for other people, until some dipshit kid tried to pass of my work as his own on some insanely simple formulas like finding the average of a few numbers. After that, I show them that it's possible and leave them to figure out the implementation for themselves.
get some data and play with it. Kaggle is a good place to start, plenty of reasonably large datasets you can download for free in .csv format. .csv lets you choose how you want to engage it, whether in excel, or powershell, or converting it into a .json, or loading it into an SQL table.
The best way to learn is by writing a program to do something you've already written in Excel. You want to know how to read and write data from a file. You want to know how to manipulate data (i.e "How do I keep only the numbers from this line?", "How do I turn this line of numbers into a list?"). There's a steep learning curve but it will click eventually.
powershell is great, very useful but overkill for most things
What more can I learn that’s useful other than =SUM(a1:a100)? I’ve developed a nice tidy sheet for my accounting and I don’t need software but I don’t understand what else could be useful.
>What more can I learn that’s useful other than =SUM(a1:a100)?
picrel, a formula I use in my trading journal to calculate P/L based on size*(entry-exit) and whether it was marked profit/loss. Don't mind the numbers, it's dummy data. If I note the trade was a profit, then the P/L is positive, if a loss, then the result will be negative. By doing it this way I can use the same formula for both long/short. Ironically now that I think about it, it's somewhat redundant and I could automatically note whether it was a profit/loss by using the Long/Short field as the delimiter for what P/L calculation I should use. The less data I have to enter by hand, the better. And this is a simple example, imagine if it were a dataset which expanded by thousands of rows every day how much time that would save.
another example, this time from my analytics page. Determines my active risk based on risk summed from all trades with a "?" in the PNL field, which they will automatically if profit/loss has not been marked. Array formulas are fucking great as long as the dataset isn't too big. You could take this to the next level and call API requests directly from excel and have all this info populate automatically straight from an exchange. But I intentionally do it by hand to prevent overtrading.
Nope learn power BI and excel, power BI will be the next “excel” as it forces wagies to learn data scrubbing and keying, and can functionally do everything excel can do but cleaner with larger datasets
As a wagie that makes $125k you’ll just need these >Vlookup >pivot tables >Sumifs >IfThen statements >Basic SUM formulas >Conditional Formating >XLOOKUP
Yeah you can learn VBA and shit but you’ll be shocked how little most finance people actually know. I had colleagues who didn’t know what the keyboard shortcut was for fucking Copy/Paste they made $70k a year
The bigger secret is hiring three pajeets that work for $6/hr and do graduate level work. Your output will look insane and you'll get promoted and can spend your time in the office helping other people
Knowing Excel is like the white collar version of knowing how to weld.
yes but only if you use your skills to train women in finance how to use pivot tables. better get on it though, i can see AI making stuff like excel extremely simple to use in a few years.
Why would you need to learn it? How do you not know how to use it already?
>How do you not know how to use it already?
Cause I'm an idiot
Yes. Especially nested functions, you can perform black magic with the right combos and automate what would otherwise be extremely time consuming calculations.
Pretty much this. If you get good enough you can basically Google anything you need to do and modify the formulas to do what you need. Knowing VBA or python is also super helpful, but not necessary. I’ve basically earned a 12 year career from knowing Excel. Just broke $100k this year. Been fully remote since the scamdemic.
Thanks, anon.
Gives me hope.
Did you not go to middle school?
Yes
But they didn't teach that
Did a internship and used excel for data analysis by putting raw data sets in excel and using formulas. It made me invaluable for the management team, practically begged me to come work for them.
Thanks for your insights, anons.
I've realized that most people, even executives don't know how to use it. I'm talking people like managers and VPs. It's unbelievable but I've seen it myself at work. How they get there without knowing excel is beyond me, but if I can learn it very well and provide them Info they can use to make strategic decisions, perhaps I can also become invaluable
What more can I learn that’s useful other than =SUM(a1:a100)? I’ve developed a nice tidy sheet for my accounting and I don’t need software but I don’t understand what else could be useful.
Excel is a bit of a rabbit hole, particularly once you start learning VBA macros. I'm an engineer so most of my stuff is job-specific, but I've done all kinds of things like:
>A program that spits out format-matched graphs when you have hundreds of different data sets (in different files) from different simulations
>A program which graphically shows requirements tracing from one document to another, letting you view it all in one spot
>A program which looks at existing test results to predict future reliability failure rates and the chance of passing the test
Picrel is a macro-free spreadsheet which figures out the price I bought or sold crypto at in my local currency (when trading from other cryptos) and uses a FIFO system to calculate my tax liability. Made in LibreOffice Calc rather than Excel, so fight me.
Once you know even basic Excel, other people (particularly finance types) see you as some sort of demigod. I used to even make spreadsheets for other people, until some dipshit kid tried to pass of my work as his own on some insanely simple formulas like finding the average of a few numbers. After that, I show them that it's possible and leave them to figure out the implementation for themselves.
>Once you know even basic Excel, other people (particularly finance types) see you as some sort of demigod
I've seen it too.
bc actual rich people let others like you do it for them
really no need to be a code mnonkey or excel chud if you are ceo
I wish I had the social skill to use other's work to move up the ladder
What do you do?
Hell no. Learn PowerShell instead if you're working in a Windows environment. You can literally open Excel as an object and automate your job.
This is not a bad idea either.
What’s the best way for an accountant with no programming knowledge to learn?
get some data and play with it. Kaggle is a good place to start, plenty of reasonably large datasets you can download for free in .csv format. .csv lets you choose how you want to engage it, whether in excel, or powershell, or converting it into a .json, or loading it into an SQL table.
The best way to learn is by writing a program to do something you've already written in Excel. You want to know how to read and write data from a file. You want to know how to manipulate data (i.e "How do I keep only the numbers from this line?", "How do I turn this line of numbers into a list?"). There's a steep learning curve but it will click eventually.
powershell is great, very useful but overkill for most things
>What more can I learn that’s useful other than =SUM(a1:a100)?
picrel, a formula I use in my trading journal to calculate P/L based on size*(entry-exit) and whether it was marked profit/loss. Don't mind the numbers, it's dummy data. If I note the trade was a profit, then the P/L is positive, if a loss, then the result will be negative. By doing it this way I can use the same formula for both long/short. Ironically now that I think about it, it's somewhat redundant and I could automatically note whether it was a profit/loss by using the Long/Short field as the delimiter for what P/L calculation I should use. The less data I have to enter by hand, the better. And this is a simple example, imagine if it were a dataset which expanded by thousands of rows every day how much time that would save.
What is there to "learn" ?
How to use it to analyze data?
Eight hour arms instead.
My manager uses excel exclusively as a notepad
another example, this time from my analytics page. Determines my active risk based on risk summed from all trades with a "?" in the PNL field, which they will automatically if profit/loss has not been marked. Array formulas are fucking great as long as the dataset isn't too big. You could take this to the next level and call API requests directly from excel and have all this info populate automatically straight from an exchange. But I intentionally do it by hand to prevent overtrading.
Query() example from a timetracker. Aggregates time spent per day and for each project. SQL in excel
If $20/hr ($40k/year) is financially good for you, you tell us.
Nope learn power BI and excel, power BI will be the next “excel” as it forces wagies to learn data scrubbing and keying, and can functionally do everything excel can do but cleaner with larger datasets
Learn SQL and Python
As a wagie that makes $125k you’ll just need these
>Vlookup
>pivot tables
>Sumifs
>IfThen statements
>Basic SUM formulas
>Conditional Formating
>XLOOKUP
Yeah you can learn VBA and shit but you’ll be shocked how little most finance people actually know. I had colleagues who didn’t know what the keyboard shortcut was for fucking Copy/Paste they made $70k a year
Thanks, anon
I'll put in the work and hopefully I can make 100k in the future tbh
The bigger secret is hiring three pajeets that work for $6/hr and do graduate level work. Your output will look insane and you'll get promoted and can spend your time in the office helping other people
If it's good enough for Tim Ferris, it's good enough for me
B00kmark
apparently excel makes more than coding