LEADERS
AUTHORS
OTHERS
USEFUL EXCEL FORMULAS 1
USEFUL EXCEL FORMULAS 2
100

“A rising tide lifts all the boats”

This saying is commonly attributed to John F. Kennedy, who used it to defend government spending and investment in the economy, suggesting that broad economic growth would help everyone, not just a select few.

100

“There are no bad teams, only bad leaders”

This quote by Jocko Willink reflects the core principle of Extreme Ownership — that leaders must take full responsibility for everything in their team or organization. If a team is underperforming, it’s not just about the individuals; it’s about how they’re being led.

100

“You have brains in your head. You have feet in your shoes. You can steer yourself any direction you choose.”

On Personal Responsibility & Courage:

— Oh, the Places You’ll Go! Dr. Seuss

A perfect reminder that great leaders begin by leading themselves — with choice, direction, and intention.

100

This formula helps you add up a range of cells.

SUM(A1:A9)

100

The formula searches the leftmost array column, retrieve specified column's value.

VLOOKUP(A2, B2:C10, 2, FALSE)

200

“In the midst of chaos, there is also opportunity.”

Sun Tzu – The Art of War

What it means:

  • Chaos often brings uncertainty, disruption, and risk.
  • But those very conditions can open doors for innovation, advantage, and unexpected success.

The ability to stay calm, observe clearly, and act decisively in turbulent times separates winners from the rest.

200

“Culture eats strategy for breakfast”

  • is famously attributed to Peter Drucker, a pioneer in modern management thinking

No matter how brilliant your strategy is — your business plan, goals, or tactics — it will fail without the right culture to support it.

  • Culture is what your people actually do, believe, and value day to day — not what’s written on posters.
  • Strategy is what you plan to do.
200

“Assume positive intent”

Assuming positive intent means choosing to believe that others' actions or words are motivated by good intentions, even if they come across as clumsy, frustrating, or unclear.


"When you assume negative intent, you're angry. If you take away that anger and assume positive intent, you will be amazed."

— Indra Nooyi, former CEO of PepsiCo

200

This formula adds up cells that meet a condition.

SUMIF(A1:A9,">50")

200

This formula counts the number of cells meeting a condition.

COUNTIF(A1:A9,">50")

300

“The price of greatness is responsibility.”

Winston Churchill

300

“You do not rise to the level of your goals you fall to the level of your systems”

  • is a powerful principle from James Clear’s book Atomic Habits.
300

“Everyone has a plan until they get punched in the mouth.”

— Mike Tyson

What it means:

  • It's a raw truth about adaptability: no matter how well you plan, reality hits — sometimes hard and unexpectedly.
  • In business, leadership, combat, or life, flexibility and resilience are just as important as preparation.
  • It echoes the idea that execution under pressure is what really tests your plan.
300

This formula finds the highest value in a range of cells.

MAX(A1:A10)

300
This formula joins text strings together.

CONCAT(A1," ",B1)

400

“The greatest shortcoming of the human race is our inability to understand the exponential function.”

On Impact and Urgency:


Albert A. Bartlett, physicist

400

“Mindset changes everything”

is a concise but deeply powerful idea — most famously explored in Dr. Carol Dweck’s book Mindset: The New Psychology of Success.

There are two primary types of mindsets:


1. Fixed Mindset

•    Belief: Abilities and intelligence are static.

•    Result: Avoids challenges, gives up easily, fears failure, sees effort as fruitless.


2. Growth Mindset

•    Belief: Abilities and intelligence can be developed through effort and learning.

•    Result: Embraces challenges, persists through setbacks, learns from criticism, inspired by others’ success.

400

“Seek first to understand, then to be understood.”

from Stephen Covey, author of The 7 Habits of Highly Effective People:

What it means:

  • Before trying to get your point across, focus on truly listening and understanding others.
  • This builds trust and opens the door for better communication and problem-solving.
  • It’s a key habit for empathy and effective relationships.
400

This formula performs a conditional test.

IF(A1>20,"High","Low")

400
This formula finds the position of a value in a range of cells.

MATCH(A1,B1:B9,0)

500

“Leadership is the art of getting someone else to do something you want done because he wants to do it.”

— Dwight D. Eisenhower

500

“Leading others effectively starts with leading yourself”

Clearing the Way: Combat Engineers in Kandahar

Book by Mark Gasparatto

500

“Your work is going to fill a large part of your life, and the only way to be truly satisfied is to do what you believe is great work. And the only way to do great work is to love what you do.”

— Steve Jobs, Stanford Commencement Address, 2005

500

The formula returns the current date and time.

NOW()

500

This function removes all spaces from a text string except single spaces between words.

TRIM(text)