Benable — create shareable lists of things you recommend!

E.g., products you love, local businesses, travel recs - you can add anything to a Benable list!

Discover

💻 Excel Functions I Actually Use in Real Life

22 items

Shunyo Osho

Not just formulas for exams — tools that quietly save my time every week.
I don’t use Excel for complicated corporate dashboards. I use it for budgeting, tracking, planning, and simplifying life. These are the functions I genuinely return to — the ones that make daily tasks easier and cleaner.
I teach Excel in a simple, practical way — especially for beginners and students who feel overwhelmed. If you’d like guidance, you’re welcome to message me.

Map

Sections

📈 SECTION 1 — Functions That Help Me Calculate Faster

🔎 SECTION 2 — Functions That Help Me Think Smarter

🧮 SECTION 3 — Functions That Make Data Cleaner

📈 SECTION 1 — Functions That Help Me Calculate Faster

For money, marks, totals, and quick clarity.

The most basic — but I use it constantly for totals and expenses.

SUM function

Helps me quickly understand trends — whether marks, spending, or performance.

AVERAGE function

Tells me how many entries I’m actually dealing with.

COUNT function

Useful when I want to count non-empty cells.

COUNTA function

Shows me the highest value instantly.

MAX function

Just as useful for spotting the lowest number.

Excel MIN Function

🔎 SECTION 2 — Functions That Help Me Think Smarter

When I need logic, filtering, or decision-making.

I use this when I want Excel to make small decisions for me.

IF function

Keeps sheets clean and professional.

IFERROR function

Saves time when looking for related data for a specific Value (Vertically in Columns)

VLOOKUP function

Saves time when looking for related data for a specific Value (Horizontally in Rows)

HLOOKUP function

More powerful than VLOOKUP and HLOOKUP — and more flexible.

XLOOKUP function

Lets me see only the data I care about.

FILTER function

Counting based on Condition. It helps me to get exact count for the specified criteria.

COUNTIF function in Microsoft Excel

This function Lets me get the value of my choice like first, second, third etc. out of many choices.

CHOOSE function

Sumif() function adds selective values that meet specific condition.

SUMIF function

🧮 SECTION 3 — Functions That Make Data Cleaner

Small tools that make big differences.

Combines names, text, or codes easily.

CONCAT function

Extracts first few characters — very useful in coding data or extracting Some Characters from the Left

LEFT function

Extracts last few characters — very useful in coding data or extracting Some Characters from the right. Helps when dealing with IDs or phone numbers.

RIGHT function

I use this to check text length or clean formatting.

LEN function

Automatically inserts current date — very useful for trackers.

TODAY function

Automatically inserts current date with time — very useful for trackers.

NOW function

Helps when you want the number of empty cells in a range of cells

COUNTBLANK function