Andr3dwar profile picture
Andr3dwar profile picture

Andr3dwar

Logistics Manager

Arsonist
Valued Contributor
Opinionated
+5

Which Excel functions have helped you the most?

I am currently concluding my first 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
28

37 comments

Sort by:
Kinonez
Celebrated Contributor
10
War Room Enthusiast
IF Statements and Countifs are soo helpful, Even though I use sum for everything!
Andr3dwar
Arsonist
10
Logistics Manager
of course, its very helpful but in my way i think vlookpup solve my life 
Kinonez
Celebrated Contributor
9
War Room Enthusiast
To be honest I rarely use it, but when I do... it's game changing!
Andr3dwar
Arsonist
9
Logistics Manager
you need to try to use it more often, then you will know how powerful it is  
Kinonez
Celebrated Contributor
9
War Room Enthusiast
Maybe I do! 
taylor
Executive
6
Strategic Account Executive
Vlookup has gotten me interviews I was nowhere near qualified to have
Kinonez
Celebrated Contributor
5
War Room Enthusiast
How so? This sounds like a story!
Mr.Pickles
Arsonist
10
Sr. Customer Success Manager
The multiple IF can ease many processes when finding values. But definitely, Vlookup is my fav.
Andr3dwar
Arsonist
10
Logistics Manager
I learned to use excel when I was still in school, at that time one of my first functions was an if function with 24 decisions
Mr.Pickles
Arsonist
8
Sr. Customer Success Manager
there you go!
MrPotter
Valued Contributor
8
Trainer
Pivot tables changed my life. Never will see data analytics the same. Conditional formatting is also pretty cool.
Lenca
Politicker
4
BDR
Oh yeah those are the bombs!
GreenSide
Politicker
7
Sales manager
PIVOT!
Covfefe4ClosersOnly
2
VP of Sales
This for sure
TheQueenofDiamonds
Politicker
2
Account Executive
Like Ross Geller? ...she ran to check what the hell pivot does 🤟
GreenSide
Politicker
1
Sales manager
Bingo
msp_sales
Opinionated
1
Full Cycle Sales
God my manager loves PivotTables....
paddy
WR Officer
7
Director of Business Development
Who the hell let IT in here!?!?
Lenca
Politicker
3
BDR
Hahahaha asking the real questions!
AlphaCharlie
Arsonist
6
Account executive
IF Statements for me!
Nairobi
Politicker
5
AE
I never thought about getting a certificate in Excel, but now that you mentioned it, it could be useful to have! Where are you getting yours?
Andr3dwar
Arsonist
8
Logistics Manager
it's very useful and I'm getting that certificate on a platform called Udemy, but I'm aiming to get certified directly with Microsoft
EH20
Politicker
4
Manager
VLOOKUP is the only acceptable answer!
FlowerPower
Opinionated
3
Trainer
IF statements are the best when working with budgets!
SlinginSoftware
Politicker
2
Account Executive
Vlookup, clear winner for me
taylor
Executive
2
Strategic Account Executive
Not a function, but pivot tables are life. Sprinkle in a dose of macro-writing, and you’re nearly unstoppable 😂
Hudsonsmom
Opinionated
1
Area Sales Manager
Vlookup 1000%. I try to teach it to everyone I work with
braintank
Politicker
1
Enterprise Account Executive
PIVOT TABLES!!!
hurtscuzimold
Opinionated
1
Dude abiding
Imagine a world without excel functions. I shudder at the thought lol
hauru.sales
Celebrated Contributor
1
Sales Enthusiast
VLOOKUP for sure 
Boutdamtime
Politicker
1
Client Executive
I’m gonna be honest I’m kinda retarded at excel
SADNES5
Politicker
1
down voters are marketing spies
=IRR 

=NPV

INSERT->PIVOT TABLE

DATA->SORT&FILTER->ADVANCED->UNIQUE RECORDS ONLY


If you use IRR and NPV to sell a deal to whomever you need, you can show positive cash flow after x date, and how much the deal will/can make both sides of the table. 

Try it out, let me know what you think...
MaximumRaizer
Politicker
1
Sales Manager
VLOOKUP
Blackwargreymon
Politicker
1
MDR
IF Statements
Clashingsoulsspell
Politicker
1
ISR
Pivot tables changed my life. Never will see data analytics the same. Conditional formatting is also pretty cool.
MR.StretchISR
Politicker
0
ISR
The multiple IF can ease many processes when finding values. But definitely, Vlookup is my fav.
Cyberjarre
Politicker
0
BDR
IF Statements and Countifs are soo helpful, Even though I use sum for everything!

Related posts

10

Using a CRM other than Salesforce in Technology Sales

Question
🔎
💽
🏙
11
Have you used an CRM other than sales
47% I have only worked primarily with Salesforce
14% I have worked with other home grown CRMS
40% I have worked with other 3rd party CRMS
43 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
🧢 Sales Management
16
Bravado is a community of trusted sales professionals endorsed by their customers.
Apple Store logo
Products
The War Room Jobs Salary Guide Tech Sales U
Company
About Us How It Works Blog Bug Bounty
Contact
Press Careers
© 2024 Bravado Inc. All rights reserved.
Privacy Policy Legal and Privacy Center Sales Jobs
If you are hired as a contract sales rep by a Bravado customer, we may ask you to prove access to the employee email account provided to you by that customer. This data will be shared with customers to track your sales productivity; customers can use this data to confirm you meet the minimum activity requirements to pay out your ramp stipend and commission.