Is there anything better than Excel? I need something better than Excel for sorting text with numbers but SQL seems a bit overboard
>>100174596No, there is nothing better than Excel./thread
Excel is only good for accountants and retards who doesn't know SQL and how to use a database.
>>100174655Well said.But also widely used in quality management because of pretty but nerfed diagrams.
>>100174596There's no good too to do that, but if you can suffer through some bullshit you can use python + pandas and it will be good enough, with the benefit that you can find a lot of information about it on google/chatgpt.
>>100174622Based.R + Rstudio is just a better Excel.
>>100174933python works in excel THOUGH
>>100175928Cloud only.
>>100174596Excel is for like <100 rows, at 1000+ you should be using SQL.
>>100174596>for sorting text with numbersawk
>>100174596git gud faggot
How many of you guys actually work in a business context where you have some proximity or visibility on positions that communicate with other businesses? Getting my teams to replace Excel with even something like R is unfathomable to me lol.
>>100174622>>100175484This + libraries openxlsx and DataEditR
>>100174933>python + pandasNot OP but I tried that recently (reasonably good at Python with a passing familiarity of pandas) when AWK wasn't right for the job. Ended up using sqlite (with litecli) which was super comfy.
>>100174596No, Excel is the sole reason I am a top 2% earner in my country. And I dont even use Macros
>>100176212>Excel is the sole reason I am a top 2% earner in my countryHow?
>>100176212Maybe it's time to stop living in Bangladesh
>>100174655>>100174622>>100175484>>100175959Hello Sirs how can I use R and SQL for my cash flow modeling?
>>100176265>>100176236UK and I work in a private equity fund. I'm the best Excel person in the company and everyone is impressed lmao (doesnt mean much because we're only like 20 people)
>>100174596For you, no. Use excel.
>>100176947Assumindo you're not lying, what exactly do you do with Excel that's so special?
>>100177545He excels
>>100177545Nta, I work in finance, and I'm not an excel genius, but if you display even a rudimentary aptitude for googling something you are considered a fucking wizard in this industry.
>>100177761Maybe I need to make my bachelor's capstone Excel centric and go from there.
>>100177545Investment analysis (cash flows etc), property development calculations, portfolio analysis (how we perform compared to relevant indices), debt calculations (interest coverage ratio forecasts etc)
>>100177789Smaller practices>large firms They pay more and value every little proficiency that you have, as it legitimately adds to the resources available in the office.
>>100177761I worked in a finance-adjacent startup and can confirm. Everyone with even basic data handling skills stands out as extremely competent.This extends to technology companies working close to finance. At the time we barely had any clue what we were doing and we were leaps and bounds ahead of the competitors in our niche.
>>100174596Sadly it's the absolute standard in almost every company. Sadly because it's performance is lacking and macros are slow as fuck but used basically everywhere. I believe that there is no other program with it's flexibility for a large amount of tasks so we are stuck with it.
>>100177848I'm a mediocre CS student, Excel looks interesting, and I need to stroke my ego.
>>100174607This.>>100174655>User friendliness is bad>t. freetard>>100176001None. This is a NEET board. That's why all suggestions are CLI-tarded anti-user kludges.>>100176212>And I dont even use MacrosNow I don't believe you!>>100177860Give me a job, anon.
>>100177860Really high up finance people that understand factors and nuances that go into investments literally can't set up their own wifi or printer. Lack of trust in new tech means that the tools used in the industry are usually 10-15 years old as well, at a minimum, which makes the issue worse.
>>100177973>Give me a job, anonI don't work there anymore. The company was well-run but it wasn't a great place for me. Now I am much happier working part-time in a low-stress environment.
>>100174596SQLite or pandas
>>100174655If your only tool is a hammer, then every problem looks like a nail. I won't say Excel is an appropriate solution, but relational databases and SQL are not the only way to deal with large data.
>>100178901>but relational databases and SQL are not the only way to deal with large data.For that you need Excel.
visidsta for TUIawk for CLI
>>100174596Ig it's just text and numbers, it would be relatively easy to make your own program.
I remember using numpy instead of excel to do my graphs
This really is a pajeet board
>>100174596post a sample of your data you cuntif excel is not enough and sql seems like overkill then python+pandas might be a good middle ground, as already mentioned
>>100174596good morning saar
>>100180442>Excel is ONLY used for data analysisGet out of your CS bubble
>>100174596>pickek'd