Short and Clear Excel

📌 Excel Topic of the Day: TEXTSPLIT Function

Want to split one text value into multiple cells automatically?

The TEXTSPLIT function separates text using a delimiter such as a space, comma, hyphen, or pipe.

✅ Split full names into First Name and Last Name
✅ Separate product codes and IDs
✅ Split text into columns or rows
✅ Ignore empty values when needed
✅ Very useful for data cleaning and preparation

Syntax:
=TEXTSPLIT(text,col_delimiter,[row_delimiter])

Example:
If A2 contains:

Rahul Sharma

Use:

=TEXTSPLIT(A2," ")

Result → Rahul | Sharma

💡 Pro Tip: Make sure the cells next to your formula are empty because TEXTSPLIT returns a spilled array across multiple cells.

A simple function that can save a lot of manual data-cleaning time. 💚

Short and Clear Excel

12 hours ago |[YT] | 71

Short and Clear Excel

📌 Excel Topic of the Day: UNIQUE Function

Want to create a clean list without duplicates in Excel?

The UNIQUE function automatically returns distinct values from a range and spills the results into separate cells.

✅ Remove duplicates dynamically
✅ Create unique product, customer, or region lists
✅ Works with text, numbers, and dates
✅ Great for reports, dropdowns, and summaries
✅ Can also return values that appear only once

Syntax:
=UNIQUE(array,[by_col],[exactly_once])

Example:
=UNIQUE(A2:A8)

This returns only the unique product names from the selected range.

💡 Pro Tip: Want only values that appear exactly once?

=UNIQUE(A2:A8,,TRUE)

Save this note and practice it in Excel today! 💚

Short and Clear Excel

2 days ago |[YT] | 130

Short and Clear Excel

Which Excel feature allows you to restrict what users can enter in a cell, such as allowing only dates, whole numbers, or values from a list?

3 days ago |[YT] | 18

Short and Clear Excel

📌 Excel New Feature: Lists in Cells + HAS, HASANY & HASALL

Excel’s new Lists in Cells feature allows a single cell to hold multiple values as a structured list.

And with the new HAS functions, you can quickly check what exists inside that list.

✅ HAS → checks whether one value exists
✅ HASANY → checks whether at least one value exists
✅ HASALL → checks whether all required values exist

Examples:

=HAS(B2,"Power BI")
Returns TRUE if Power BI exists in the list.

=HASANY(B3,{"SQL","Tableau"})
Returns TRUE if either SQL or Tableau exists.

=HASALL(B4,{"Power BI","SQL"})
Returns TRUE only if both values exist.

💡 Very useful for skills, tags, selected products, categories, availability, and other multi-value data.

⚠️ This is a new preview feature, so availability depends on your Excel build/version.

Short and Clear Excel

3 days ago |[YT] | 121

Short and Clear Excel

📌 Excel Topic of the Day: COUNTIFS Function

Want to count records based on multiple conditions in Excel?

The COUNTIFS function counts only those rows where all specified criteria are met.

✅ Count sales by Region + Product
✅ Count employees by Department + Status
✅ Works with text, numbers, dates, and cell references
✅ Very useful for reports, dashboards, and analysis

Syntax:
=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,...)

Example:
=COUNTIFS(B2:B7,"East",C2:C7,"Laptop")

This counts how many Laptop sales records belong to the East region.

Result → 3

💡 Pro Tip: COUNTIFS uses AND logic, which means every condition must be TRUE for a row to be counted.

Also, all criteria ranges should be the same size.

Save this note and practice it in Excel today! 💚

Short and Clear Excel

4 days ago |[YT] | 122

Short and Clear Excel

📌 Excel Topic of the Day: SUMIFS Function

Want to calculate totals based on multiple conditions in Excel?

The SUMIFS function adds values only when all specified conditions are met.

✅ Sum sales by Region + Product
✅ Calculate expenses by Department + Month
✅ Works with text, numbers, dates, and cell references
✅ Perfect for reports, summaries, and dashboards

Syntax:
=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)

Example:
=SUMIFS(D2:D7,B2:B7,"East",C2:C7,"Laptop")

This adds only the sales where:

Region = East
Product = Laptop

Result → 83,000

💡 Pro Tip: SUMIFS uses AND logic, so every condition must be true for a row to be included.

Also make sure all criteria ranges are the same size as the sum range.

Save this note and practice it in Excel today! 💚

Short and Clear Excel

5 days ago |[YT] | 149

Short and Clear Excel

New Course starts from 20th Oct 2026🚀

If anyone is interested DM me on whatsapp +91-9876680746

5 days ago |[YT] | 37

Short and Clear Excel

Some nights, work doesn’t really feel like work.

You sit in front of the screen, create one more lesson, answer one more doubt, record one more video, and try to make something a little clearer for someone else.

And then you look at the wall…

and see that YouTube Silver Play Button.

It reminds you that this community was not built in one day.

It took years of learning, teaching, experimenting, making mistakes, answering questions, and showing up even when very few people were watching.

That award is not just about a subscriber milestone for me.

It reminds me why I started.

To make Excel, Power BI and AI easier to understand.

To help someone solve a problem at work.

To help a student become more confident.

To help a professional learn one skill that can make their job easier or open a new opportunity.

And that feeling gives me energy to keep going.

Create more.
Learn more.
Teach more.
Help more.

Because the real satisfaction is not only in growing a channel or a business.

It is in knowing that something you created may have helped someone move forward in their career.

That is the part I value the most.

Some nights are long.

But when the work has purpose, you go to sleep feeling happy that you did something useful.

And the next day, you start again. ❤️

#Learning #Teaching #CareerGrowth #excel #powerbi

Skip the Carousel

1 2

6 days ago |[YT] | 58

Short and Clear Excel

📌 Excel Topic of the Day: TEXTJOIN Function

Want to combine text from multiple cells into one clean result?

The TEXTJOIN function lets you join values using a delimiter like a comma, space, dash, or even a line break.

✅ Combine names into one full name
✅ Join product lists in a single cell
✅ Ignore blank cells automatically
✅ Create multi-line addresses
✅ Great for reports and dashboards

Syntax:
=TEXTJOIN(delimiter,ignore_empty,text1,[text2],...)

Example:
=TEXTJOIN(", ",TRUE,A2:A5)

Result → Laptop, Mouse, Keyboard, Monitor

💡 Pro Tip: Want each value on a new line?

=TEXTJOIN(CHAR(10),TRUE,A2:A5)

Then turn on Wrap Text to display the line breaks properly.

Save this note and practice it in Excel today! 💚

Short and Clear Excel

1 week ago |[YT] | 159

Short and Clear Excel

Create your Own Custom Formulas in Excel

1 week ago |[YT] | 3