Which Excel functions have helped you the most?

I am currently concluding my certificate in Microsoft excel, and I was wondering, which functions have made your life easier on a daily basis?

functions that solve;

Attached poll
*Voting in this poll no longer yields commission.
☁️ Software Tech
24
CuriousFox
WR Officer
9
🦊
Throwing my laptop into a busy street has helped me the most.
funcoupons
WR Officer
4
👑
Same
CoorsKing
WR Officer
7
Retired King of the Coors Knights
I’m so bad at excel. Like miserably bad
hh456
Celebrated Contributor
5
sales
=sum(a2:a999)*.08
Commish
Sunbunny31
Politicker
4
Sr Sales Executive 🐰
I took my first Excel course 24 years ago.
I took my last Excel course 24 years ago.
I can honestly say this has not affected my ability to do my job at all.
FattySnacks
Politicker
3
Senior Account Executive
We’re all in sales not consulting. That said Vlookup 😂
Beans
Big Shot
3
Enterprise Account Executive
Google, google is my favourite function. 
SaaSguy
Tycoon
2
Account Executive
I just run reports in Salesforce, don't use excel much 
funcoupons
WR Officer
2
👑
Excel is for nerds
hh456
Celebrated Contributor
2
sales
Thank you
funcoupons
WR Officer
0
👑
You are welcome. 
SalesPharaoh
Big Shot
1
Senior Account Executive
I'm not into excel and never used it. Is that something wrong? Should I? I only use excel to see things and like pivot tables not solve problems.
Diablo
Politicker
1
Sr. AE
I use basic Excel and one thing I like is formatting to make it look good and meaningful 😅

Had used all the above functions in the past roles where I had huge data sets but that's no more the case
Clashingsoulsspell
Politicker
1
ISR
I’m so bad at excel. Like miserably bad
MaximumRaizer
Politicker
1
Sales Manager
I’m so bad at excel. Like miserably bad
Thatsalesdude
Politicker
0
Account Executive
me no understand 
Dman1b
Catalyst
0
Azure Specialist
The little X in the upper right corner works best for me.....
GreenSide
Politicker
0
Sales manager
Those can't do, steal other posts word for word. Get outta here with this nonsense.

https://bravado.co/war-room/posts/which-excel-functions-have-helped-you-the-most
GreenSide
Politicker
0
Sales manager
.
Jewcan_Sam81
Politicker
0
Account Executive
I like the function where i can type things into the box, and then make that box have a border around it, and then make the border go around other boxes next to it with other stuff i've typed in there. 

(i'm the pointless Excel user ever)
1nbatopshotfan
Politicker
0
Sales
The red x in the top right corner is my favorite. 
MR.StretchISR
Politicker
0
ISR
Throwing my laptop into a busy street has helped me the most.
Mr.Floaty
Politicker
0
BDR
However, if I had to choose it's salary. Can't eat career path.
Cyberjarre
Politicker
0
BDR
Just don’t let a hiring manager promise you the moon but undershoot your market value by something ridiculous like $50k. $10 or $20k difference I’m taking the career path.
28
Members only

Which Excel functions have helped you the most?

Question
37
functions that solve;
66 people voted
6

Is there a tool that can tell if a company is using Salesforce as their CRM?

Question
8
7

Sales Manager: Any Trending Excel Formulas?

Advice
16