Key Formulas
Master these few Excel / Sheet formulas
If you're just getting started out or want to be better with Excel / Sheets, just practice these and it'll cover 97.67% of what you'll need to use at a job that prefers "experience with data is a plus". It'll also put you way ahead of those that don't know this stuff.
And no, "I can just use AI." is probably not the answer the hiring manager is looking for (........ yet 🤖).
🔲 Pivot tables (seriously, sounds wayy more intimidating than it actually is):
- Rows, columns, value (sum, counta), filter
☑️ Charts
- Select (drag) the data you want and go to insert > chart
➗ Formulas
=sum
=average
=if(__, __, __)
=countifs
=sumifs
=vlookup
=hlookup
Bonus: =concatenate and =sumproduct
✍️ Syntax
" " (returns whatever's between the quotations)
< (less than)
> (greater than)
<> (not equal to)
<= (less than or equal to)
>= (greater than or equal to)
+-/* (add, subtract, divide, multiply)
🌶️ 🔑 Hot keys
Shift+arrow key (selects one cell at a time)
Ctrl+arrow key (jumps to end of current data set in row/column)
Ctrl+Shift+arrow key (selects entire data set in row/column)
Shift+mouse click (selects all the data up to the mouse click)
Ctrl+mouse click (selects just the first cell and the mouse click cell)