/biz/ - Business & Finance

vlookup boomers, rise up

>>52447060
The redpill on Excel is to use Google Sheets for free.

>>52447067
I wish VBA excel programing was in actual demand. I feel like I mastered something two decades too late.

>>52447090
nah the real redpill is using pirated office

>>52447060
extremely useful. only autistic retards think otherwise.

The backbone of every finance department at every company I've ever worked for.

>>52447067
xlookup zoomers will bury you

>>52447060
Got 100k workbooks stacked
Excelchads WAGMI

It's the future of crypto

>>52447155
Same. Most ERP’s are shit, we always ended up doing 95% of the work in Excel and then importing shit into the ERP software which costed $10k per license

>>52447067
I haven’t used a V-Lookup at work in years

>>52447060
It is easy to use, but also easy to break if you use any of the actual powertools. Then your file is corrupted and you have to start all over.

you can get it for free until your death if you crack it or just subscribe to every trial version you have on office 365

also it never breaks or has incident

t. microsoft support "engineer"

>>52447060
The entire worlds services economy relies on this product. Microsoft is an easy buy for this simple fact alone.

>>52447060
functional programming language
reactive
no real version control
near monopoly on spreadsheets

for me it's index & match

>>52447093
Power query is where its at now. Havent written a formula in a excel cell other than SUM in years

=ifs instead of =if(nested hell)

is power BI as based as everyone says?

>>52447459
You can just use gnumeric or libre office

>>52447060

>>52447662
it's not as good and you won't have support

>>52447060
I use google sheets

>>52447516
half the fucking office thinks I'm a wizard because i told them about power query

>>52447590
I’m a sharepoint dev, power BI isn’t bad for low code dashboards

>>52447806
i spent an hour learning power query to unpivot and clean up a report from another department. then the retard changed the format of the report and fucked everything up, so i gave up.

>>52447835
SIR PLEASE DO THE NEEDFUL AND REVERT

>>52447060
Buy iExecel RLC instead bro

>>52447067
step aside peasant, INDEX/MATCH chad coming through

>>52447060
https://www.youtube.com/watch?v=kOO31qFmi9A

>>52447060
had the best ads
https://youtu.be/kOO31qFmi9A

>>52447155
It is the backbone of the world economy. I've worked in huge companies with all kind of software and Excel was still heavily uses. We received reports from all over the world in Excel although there was a big player ERP system in place.

>>52447505
>>52447898

>>52447516
>Power query
Not gonna help me identify replicates by condition, select controls, and calculate pvalues ... but I guess for simple spreadsheet folks it's a much smaller barrier to entry than fitting the 'ol f11. I hate these tools though because while they do what they do well, you can't do anything outside their specific scope. So you better hope you don't have a different use case than they envisioned.

>>52447687
this is right

I miss the times when it had CHUNKY BUTTONS

>>52448582
I remember those days. I also remember Lotus 123.

t. Gen X anon

>>52448582
sovl

>>52447060
Like google sheets a modern day botnet farming your 'habits' for revenue.

>>52447067
>>52447898
There isn’t much reason to use either of those anymore, now that xlookup exists and is easier to use than both

recently playing with array functions, surprisingly useful way to automate shit where using power query or anything else is ideal

>>52447898
Absolutely Chad Pilled. Flex on the hoi polloi stuck in söyLOOKUP land.

>>52451941
index match still mogs xlookup on performance

can excel get me a job somehow?
are any positions built off of it?

>be me
>almost no education slav
>Brother asks me if i would like to join company he is waging for, they are looking for someone to sit in office and manage shit
>They ask me if i can filter in excel
>"Uhhh, yes"
>Get the job
>Fix a ton of mistakes that would cost the company thousands of euros
>Still get replaced by a dumb woman

At least i work in warehouse now and its still better job than what i had but still, boss was busting my balls for tiniest mistake when i was doing his shit, but when women went to office (not even hot ones, fat and old) its like "no big deal" now

Yep

To be fair excel is an absolute cancer of a software.
Bloated shit with 99% of functionalities that normies never use
Maxi database shit shared across departments with versions floating all around the place

I guess normies really like GUIs so they keep buying into the Excel delirium but this software really needs to be replaced fast

>>52447060
Bruv just learn SQL . It's easier.

>>52447687
These fucking iq memes never get old

>>52448582
>Amen brother
These fuckers are on my last nerve, they need to revert to the old styles immediately, my phone is like an ice cube

>>52454797
Yes but it still feeds into big daddy excel a lot of the time for ad hoc analysis.

Office 2010 is the best office, fuck this nu bloated shitware.

>>52454797
SQL is a superpower
teaching it to my kids whether they want it or not

>>52447060
Why don't people just use relational databases and dashboards instead?

>>52447060
it's like a blockchain but without the blocks or the chain

>>52447067
eh

>>52452269
Every entry level generic office job

>>52455125
bullshit - you work with databases anon, not spreadsheets.

>>52455140
I think it's underrated - i'm a SQL advanced user and will say it's better than R, SPSS, VBA and PowerQuery ( fuck you excel)

Great for scratch work and analysis but a nightmare when used as a production model

>>52455326
kek

>>52447112
If you're not using LibreOffice you're not redpilled

>>52455326
If it's not a date why am I hecking paying for it???

>>52455266
Whatever go jerk yourself off in the corner.

>>52447060
it's like crypto but for actual purposes

>>52455266
>databases, not spreadsheets
This is the single most fucking autistic argument in finance I encounter. If you correct people on what's a database and what's a spreadsheet, use shotgun on own head ASAP

>>52455266
SQL mastery is the ace up my sleeve as a fullstack dev
everybody loves a guy who can make them big queries go 20x faster

>>52447687
This is so fucking true.

>>52447060
>>52447093
My team manages a $50bn portfolio using a bunch of VBA spaghetti code lmao
t. self-taught BASIC/VB(A)/VB.NET script kiddie on $250k total comp
>>52447067
For me it's =IFERROR()

>>52455412
>LibreOffice

>Completely shits, pisses and farts all over you for anything beyond mouthbreather tasks

>>52455138
>Office 2003 is the best office, fuck this nu bloated shitware
FTFY.

>>52455805
I’ve been meaning to learn python as an accountant yet I can never find a end result worth learning it for

>>52447060
What if I were to tell you that I work for one of the most important and powerful tech companies in the world, and that our entire operation is held together by a 20 year old excel file with 90000 lines and broken macros.

>>52456035
I would tell you I probably work for the same company.

>>52456035
What are you talking about >>52447687 is telling me Excel is high IQ. There's no way that a wojak image is wrong, so there's no way Excel can be bad.

How can I make a career out of writing Excel macros?

>>52447060
damn OP I hadn't experienced such a comfy biz thread in a long while
>>52455178
because you cannot easily read and fuck shit up at the exact same time

>>52456566
He didn't say excel is bad. A broken shitty spreadsheet serves the world's best companies better than all these gay database and ERP systems

>>52447898
based

>>52447687
This. power bi and Dax are awesome tho

https://youtu.be/x1RVNGDSdw4

>>52457076
i have some bad news for you anon.

>>52451941
maybe I'm retarded but whenever I buiid anything with array functions the performance is terrible.
I didn't even know there was a loading bar for spreadsheets before array functions

>>52456723
you probably could do it by moving to a company that is mostly old boomers that fear excel (95% of them), but the trend is moving to powerquery and powerbi, it’s cleaner and faster
honestly though it’s hilarious how understanding vlookup is enough to always have a job

>>52447060
I genuinely love spreadsheets bros
I tried to learn coding a bunch of times and failed until I found out about macros. It's basically like visual programming. The combination of being able to lay things out in cells with functions, making your own functions and then being able to record macros to get little snippets of code. It's so comfy.
I love that you can have an idea and there are multiple ways to go about building it and all of them work but you can refine it and improve it. Spreadsheets rock.

>>52447067
Bitch you can't even hookup.

>>52447548
Holy shit. How have I never heard of this?

>>52447687
Me on the left

>>52447060
to most people it is just a spreadsheet program. to a gifted few it is a tool of the dark arts

>>52457185
how big is your source data? If it’s thousands of cells I could see it being slow

>>52447060
It’s dumb, gay, and pretty much useless.

>>52457360
because IF(AND(),,) works just fine

>>52447060
It is designed to keep you in the square grid based matrix. Take the red pill and use hexagonal spreadsheets

>>52457785
Give me the basic gestalt

>>52458066
Look up flower of life

>>52447060
It low-key runs the entire economy.

Extremely useful, utilized in every lab I've been in

>>52447093
I've been gitting good at VBA at my job. I still see it mentioned in data analysis type jobs. I don't feel like it's a useless skill at all.

Even if they move the api to JavaScript or python, you still know the underlying fundamentals if you learned vba

>>52447516
Soon Power Automate is gonna take over a lot of easy scripts.

>>52459199
>low code
Nothing will feel as useful as writing exactly what you want in vba

Based Salesforce Chad coming through

>>52459199
no it won’t. microsoft will develop it for 2 more years before leaving it as-is for the next 3 decades. maybe a cosmetic update.

>>52447687
Painfully true. R kind of spoils you for design of experiments, but you can absolutely just build 3-4 macros to run all your checks in excel.

The real redpill is using python. Don’t know why normies need a constant view of their rows and columns. Can do so much more with python and its way faster.

>>52447093
chemical plants and the like use VBA a lot to interface with their data historian and to populate information and so forth. That stuff can get pretty complicated.

Currently using Cyfe for real-time BI.
It’s kind of lacking in the ability to merge datasets. Any anons got any recommendations? I’m looking at Tableau or making my own dashboards in python with web frontend. Halp.