How do I get good at recording data and performing calculations with excel?
I have an interview as an excel slave this monday and I lied on my resume saying I was good at it. Basically all I know is putting shit in cells.
Excel
This is pretty much teaches everything you need to know. It's so easy that even a fucking monkey can do it. Good luck on your interview and don't get cucked by pajeet.
support.office.com
t. Microsoft Office Specialist
You'll outperform 95% of the boomers by knowing the INDEX MATCH formula, it's one of my most used formulas. And boomers love pivottables for some reason.
thank you raj this was the needfull
Excel is the most basic and intuitive shit if your not a mouth breathing boomer retard. It literally fucking tells you with constant highlights and tool tips how to do anything. Just go in the help section in excel and have a look.
Boomer employers love vlookup and pivot tables
Install Gentoo
>Basically all I know is putting shit in cells.
Fundamentally, a spreadsheet is all about affecting one number usign another number. If you can express what it is you want to *do* with some data, you're half of the way there anyway.
Take a look at this guy's videos, I found them invaluable for 'how can I play with this data':
youtube.com
nice
>make a table
>mark it
>insert pivot table
>insert pivot chart
>drag some stuff around
WOOOOOOW
>mark column
>conditional formatting
>add another column
>index/match
HIRED
Kek this is basically it. Make sure to use keyboard shortcuts for the extra hackerman points. Once you're in go around to the 27+ year old hit the wall office ladies and show them some sweet macros and formulas, you'll make their thongs wet.
>recording data with Excel
don't.
It's a calculator, not a database.
>wysiwig data is bad because they anger my brain worms
every time I see a normie using a Microsoft Word I scream in anger and dropkick theiur FUCKING monitor. i find LaTeX or (snort) ...markdown... far superior
No, it's bad because it has no structure.
Using Excel for data always ends up a shitty mess (like dates getting confused with numbers) and very slow because lol no indexes.
>Using Excel for data always ends up a shitty mess
in YOUR sheets, maybe. I think you need more practice at spreadsheets
Is this all that's needed to be a 300k/year Excel specialist?
I never work in Excel.
But I often get data from clients as Excel documents are it's nearly always a horrible mess that takes hours to fix (no worries though, I charge 100 euro's per hour).
Okay but how do I do this in MS Excel? I ain't gonna use Libre Office.