Is there anything better than Excel? I need something better than Excel for sorting text with numbers but SQL seems a bit overboard
Is there anything better than Excel? I need something better than Excel for sorting text with numbers but SQL seems a bit overboard
No, there is nothing better than Excel.
/thread
This.
>User friendliness is bad
>t. freetard
None. This is a NEET board. That's why all suggestions are CLI-tarded anti-user kludges.
>And I dont even use Macros
Now I don't believe you!
Give me a job, anon.
>Give me a job, anon
I 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.
Based.
R + Rstudio is just a better Excel.
This + libraries openxlsx and DataEditR
Excel is only good for accountants and morons who doesn't know SQL and how to use a database.
Well said.
But also widely used in quality management because of pretty but nerfed diagrams.
Hello Sirs how can I use R and SQL for my cash flow modeling?
If 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.
>but relational databases and SQL are not the only way to deal with large data.
For that you need Excel.
There'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.
python works in excel THOUGH
Cloud only.
>python + pandas
Not 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.
Excel is for like <100 rows, at 1000+ you should be using SQL.
>for sorting text with numbers
awk
git gud homosexual
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.
No, Excel is the sole reason I am a top 2% earner in my country. And I dont even use Macros
>Excel is the sole reason I am a top 2% earner in my country
How?
Maybe it's time to stop living in Bangladesh
UK 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)
Assumindo you're not lying, what exactly do you do with Excel that's so special?
He excels
Nta, 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 fricking wizard in this industry.
Maybe I need to make my bachelor's capstone Excel centric and go from there.
Smaller 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.
I'm a mediocre CS student, Excel looks interesting, and I need to stroke my ego.
I 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.
Really 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.
Investment analysis (cash flows etc), property development calculations, portfolio analysis (how we perform compared to relevant indices), debt calculations (interest coverage ratio forecasts etc)
For you, no. Use excel.
Sadly it's the absolute standard in almost every company. Sadly because it's performance is lacking and macros are slow as frick 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.
SQLite or pandas
visidsta for TUI
awk for CLI
Ig 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
post a sample of your data you c**t
if excel is not enough and sql seems like overkill then python+pandas might be a good middle ground, as already mentioned
>Excel is ONLY used for data analysis
Get out of your CS bubble
good morning saar