MS Excel for Data Analysis

📊 Excel Basics #30 – DATEDIF() & EDATE() Functions

When working with employee records, project timelines, subscriptions, loans, or customer data, you often need to calculate the time between dates or move a date forward or backward by a specific number of months.

Two useful functions are DATEDIF() and EDATE().

📌 1. DATEDIF() Function

DATEDIF() calculates the difference between two dates.

Syntax:

=DATEDIF(start_date,end_date,unit)

The unit determines what you want to calculate.

Common units:

• Y → Complete years

• M → Complete months

• D → Total days

• YM → Remaining months after complete years

• YD → Remaining days after complete years

• MD → Remaining days after complete months

📌 Example 1 – Calculate Complete Years

Suppose:

A2 = 01-Jan-2020

B2 = 19-Aug-2026

Formula:

=DATEDIF(A2,B2,"Y")

Result:

6

The employee has completed 6 full years.

📌 Example 2 – Calculate Complete Months

=DATEDIF(A2,B2,"M")

This returns the total number of complete months between the two dates.

📌 Example 3 – Calculate Total Days

=DATEDIF(A2,B2,"D")

This returns the total number of complete days between the dates.

📌 Example 4 – Display Years and Months

You can combine multiple DATEDIF() functions:

=DATEDIF(A2,B2,"Y")&" Years "&DATEDIF(A2,B2,"YM")&" Months"

Example result:

6 Years 7 Months

This is useful for calculating employee tenure or customer relationship duration.

📌 2. EDATE() Function

EDATE() returns a date that is a specified number of months before or after a starting date.

Syntax:

=EDATE(start_date,months)

📌 Example 1 – Add Months

If:

A2 = 19-Aug-2026

Formula:

=EDATE(A2,3)

Result:

19-Nov-2026

📌 Example 2 – Subtract Months

=EDATE(A2,-3)

This returns the date 3 months before the date in A2.

Result:

19-May-2026

📌 Real-World Example

Suppose a subscription starts on:

19-Aug-2026

and lasts for 12 months.

Formula:

=EDATE(A2,12)

Result:

19-Aug-2027

You can use this to calculate renewal dates.

📌 DATEDIF() vs EDATE()

DATEDIF() → Calculates the difference between dates.

EDATE() → Calculates a new date by adding/subtracting months.

Think:

👉 DATEDIF() → How long?

👉 EDATE() → What date after/before X months?

📌 Real-World Uses

• Calculate employee experience.

• Calculate customer tenure.

• Calculate project duration.

• Find subscription renewal dates.

• Calculate loan or contract dates.

• Track service anniversaries.

📌 Common Mistakes

❌ Putting the end date before the start date in DATEDIF().

❌ Using the wrong DATEDIF() unit.

❌ Forgetting that DATEDIF() returns complete units, not rounded values.

❌ Formatting an EDATE() result as a number instead of a date.

✅ Quick Tip

Remember:

DATEDIF() → Difference between two dates

EDATE() → Move a date by months

These functions are extremely useful when working with real-world business data.

Double Tap ❤️ For More

𝗪𝗢𝗥𝗞 𝗙𝗥𝗢𝗠 𝗛𝗢𝗠𝗘 𝗝𝗢𝗕 𝗢𝗣𝗣𝗢𝗥𝗧𝗨𝗡𝗜𝗧𝗬 😍

Company Name :- AI InsurTech Company

💼 𝗥𝗼𝗹𝗲: Backend Developer
💰 𝗦𝗮𝗹𝗮𝗿𝘆: ₹5 LPA
🏠 𝗪𝗼𝗿𝗸 𝗠𝗼𝗱𝗲: Work From Home
📍 𝗟𝗼𝗰𝗮𝘁𝗶𝗼𝗻: Hyderabad / Remote

🎓 𝗪𝗵𝗼 𝗖𝗮𝗻 𝗔𝗽𝗽𝗹𝘆?
✅ BTech/BE graduates
✅ Branches: CS, IT, AI, ML and Data-related streams
✅ Graduation Years: 2025 and 2026

🔗 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄 👇:-

https://pdlink.in/4xIfsE4

⚡ Apply early and share this opportunity with your friends!

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 😍

💫Kickstart Your Data Science Career

💫Join this Masterclass for an expert-led session on Data Science

Eligibility :- Students ,Freshers & Working Professionals

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4xOh5jA

(Only few slots left )

Date & Time :- 21st August 2026 & 7PM

🎓 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀

Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies for FREE! 🔥

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/4qn5q94

💫 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 :- https://pdlink.in/4zrkYNg

☁️ 𝗖𝗹𝗼𝘂𝗱 𝗖𝗼𝗺𝗽𝘂𝘁𝗶𝗻𝗴 :- https://pdlink.in/4wzy6Ny

🛡️ 𝗖𝘆𝗯𝗲𝗿 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 :- https://pdlink.in/4xMJNl5

🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!

📊 𝗪𝗮𝗻𝘁 𝘁𝗼 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗣𝗿𝗼 𝗶𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀? 🚀

Learning Excel, SQL and Power BI is only the beginning. To stand out as a Data Analyst, focus on practical experience, visibility and networking.

🔥 4 Ways to Level Up Your Data Analytics Career:

💡 Master the Skills → Build Projects → Create Your Portfolio → Get Noticed

🔗 𝗖𝗵𝗲𝗰𝗸 𝘁𝗵𝗲 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗚𝘂𝗶𝗱𝗲 👇

https://pdlink.in/4cIfLqn

🎯 Perfect for Students | Freshers | Data Analyst Aspirants | Career Switchers

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊🔥

𝗕𝘂𝗶𝗹𝗱 𝗝𝗼𝗯-𝗥𝗲𝗮𝗱𝘆 𝗦𝗸𝗶𝗹𝗹𝘀 & Learn the tools companies actually use and prepare for high-growth Data Analyst opportunities.

💼 60+ Hiring Drives Every Month
🤝 500+ Hiring Partners
👨‍🏫 1-on-1 Expert Mentorship
📝 Resume & Interview Preparation
🚀 Dedicated Placement Assistance

🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗖𝗮𝗿𝗲𝗲𝗿 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴👇:-

https://pdlink.in/45vk5ph

🎓 Perfect for Students | Freshers | Working Professionals | Career Switchers

📊 𝟱 𝗕𝗲𝘀𝘁 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗠𝗦 𝗘𝘅𝗰𝗲𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘

Excel is one of the most valuable workplace skills — start learning for FREE today!

✅ Beginner Friendly
✅ Learn at Your Own Pace
✅ Improve Excel & Data Analysis Skills
✅ Useful for Jobs & Interviews
✅ Completely FREE Resources

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/3UkOmoa

🎓 Perfect for Students | Freshers | Data Analyst Aspirants | Working Professionals

📊 Excel Basics #29 – TODAY(), NOW() & Basic Date Functions

Dates are extremely important in Excel, especially when working with sales, invoices, employee data, projects, and deadlines.

Excel provides built-in functions to work with the current date and time.

📌 1. TODAY() Function

"TODAY()" returns the current date.

Syntax:

=TODAY()

Example:

If today's date is 17-Aug-2026, the formula returns:

17-Aug-2026

The value automatically updates when Excel recalculates on a different day.

📌 2. NOW() Function

"NOW()" returns the current date and time.

Syntax:

=NOW()

Example:

17-Aug-2026 13:08

The exact displayed format depends on your cell formatting and system settings.

📌 TODAY() vs NOW()

"TODAY()" → Current date

"NOW()" → Current date + time

📌 3. Calculate Days Since a Date

Suppose an employee's joining date is in "A2".

Formula:

=TODAY()-A2

This returns the number of days between the joining date and today.

💡 Example:

Joining Date → "01-Jan-2026"

Formula:

=TODAY()-A2

Result → Number of days since joining.

📌 4. Check Whether a Date Has Passed

Suppose a project deadline is in "A2".

Formula:

=IF(A2<TODAY(),"Overdue","Not Overdue")

Excel checks whether the deadline is before today's date.

📌 5. Check Whether a Deadline Is Today

=IF(A2=TODAY(),"Due Today","Other")

This can be useful for task trackers and deadline reports.

📌 6. Extract Date Components

Excel also provides:

=DAY(A2) → Extracts the day

=MONTH(A2) → Extracts the month

=YEAR(A2) → Extracts the year

Example:

If "A2 = 17-Aug-2026"

=DAY(A2) → Result: 17

=MONTH(A2) → Result: 8

=YEAR(A2) → Result: 2026

📌 Real-World Example

Task Due Date Status

Report 15-Aug-2026 Overdue

Dashboard 17-Aug-2026 Due Today

Presentation 25-Aug-2026 Not Due

Formula in C2:

=IF(B2<TODAY(),"Overdue",IF(B2=TODAY(),"Due Today","Not Due"))

You can copy the formula down for all tasks.

📌 Common Mistakes

❌ Treating dates stored as text as real Excel dates.

❌ Forgetting that "NOW()" includes both date and time.

❌ Assuming "TODAY()" is a fixed value—it changes as the date changes.

Double Tap ❤️ For More

𝗙𝗥𝗘𝗘 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 𝗢𝗻 𝗟𝗮𝘁𝗲𝘀𝘁 𝗧𝗲𝗰𝗵𝗻𝗼𝗹𝗼𝗴𝗶𝗲𝘀 😍
- AI
- Data Analytics
- Data Science
- CloudComputing
- Cyber Security
​
💫Build a Future Ready Career in the AI Era
​
💫Learn the Skills, Hiring Trends, and Preparation Strategies That Matter
​
𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-
​
https://pdlink.in/45w4ztg
​
(Only few slots left )
​
Date & Time :- 18th August 2026 & 7PM

💻 𝗠𝗮𝘀𝘁𝗲𝗿 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 | 𝟱 𝗕𝗲𝘀𝘁 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗖𝗵𝗮𝗻𝗻𝗲𝗹𝘀 🚀

Want to learn SQL from scratch to advanced level without spending anything? These 5 YouTube channels offer tutorials, practical examples and problem-solving content.

🔥 Learn → Practice → Build Projects → Prepare for SQL Interviews

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4wCjU6x

📊 Perfect for Students | Freshers | Data Analyst Aspirants | SQL Beginners

📊 Excel Basics #28 – TRIM(), UPPER(), LOWER() & PROPER()

Raw data often contains extra spaces or inconsistent capitalization.

For example:

" rahul SHARMA "

This can create problems when filtering, matching, or analyzing data.

Excel provides several useful text-cleaning functions to fix these issues.

📌 1. TRIM() Function

"TRIM()" removes unnecessary spaces from text.

Syntax:

=TRIM(text)

Example:

=TRIM(" Rahul Sharma ")

Result:

Rahul Sharma

It removes leading/trailing spaces and reduces multiple spaces between words to a single space.

📌 2. UPPER() Function

"UPPER()" converts text to uppercase.

Example:

=UPPER("data analyst")

Result:

DATA ANALYST

Useful when you want consistent formatting for codes, categories, or headings.

📌 3. LOWER() Function

"LOWER()" converts text to lowercase.

Example:

=LOWER("RAHUL@GMAIL.COM")

Result:

rahul@gmail.com

This is especially useful when standardizing email addresses or other text fields.

📌 4. PROPER() Function

"PROPER()" capitalizes the first letter of each word.

Example:

=PROPER("rahul sharma")

Result:

Rahul Sharma

Useful for cleaning names, cities, departments, and other labels.

📌 Real-World Example

Suppose your raw data contains:

Raw Name
" rahul sharma"
"PRIYA PATEL"
"amit kumar"

Clean it using:

=PROPER(TRIM(A2))

Results:

Rahul Sharma

Priya Patel

Amit Kumar

Here, "TRIM()" removes unnecessary spaces and "PROPER()" standardizes capitalization.

📌 Combining Functions

You can combine these functions to clean data more effectively.

Example:

=UPPER(TRIM(A2))

This removes unnecessary spaces and converts the result to uppercase.

If:

"A2 = " power bi ""

Result:

POWER BI

📌 Real-World Uses

• Clean imported datasets.
• Standardize employee names.
• Clean customer information.
• Standardize email addresses.
• Prepare data before using lookup functions.
• Fix inconsistent categories.

📌 Important Tip

"TRIM()" removes regular spaces, but some data copied from websites or external systems may contain non-breaking spaces that "TRIM()" alone doesn't remove.

For such cases, you can use:

=TRIM(SUBSTITUTE(A2,CHAR(160)," "))

✅ Quick Tip

"TRIM()" → Remove extra spaces

"UPPER()" → Convert to UPPERCASE

"LOWER()" → Convert to lowercase

"PROPER()" → Capitalize Each Word

Double Tap ❤️ For More

🚀 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲 & 𝗖𝗼𝗻𝗳𝗶𝗱𝗲𝗻𝗰𝗲 🎓🔥

Make your resume stand out and feel more confident during your job search.

🚀 Build confidence and a career-focused mindset

✅ 100% FREE
✅ Beginner Friendly
✅ Improve Your Resume
✅ Develop Career-Ready Skills
✅ Great for Students, Freshers & Professionals

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4gce062

🔥 Don't just apply for jobs — build the skills and confidence to stand out!

📊 Excel Basics #27 – CONCAT() & TEXTJOIN() Functions

Sometimes your data is split across multiple columns, but you need to combine it into a single value.

For example:

First Name + Last Name → Full Name

City + State → Location

Product Code + Year → Complete Code

That's where CONCAT() and TEXTJOIN() are useful.

📌 1. CONCAT() Function

CONCAT() combines text from multiple cells or text values into one string.

Syntax:

=CONCAT(text1, [text2], ...)

Example:

First Name Last Name

Rahul Sharma

Formula:

=CONCAT(A2," ",B2)

Result:

Rahul Sharma

The " " adds a space between the two names.

📌 Example – Combine Product Information

Product Code Year

Laptop LAP 2026

Formula:

=CONCAT(A2,"-",B2,"-",C2)

Result:

Laptop-LAP-2026

📌 2. TEXTJOIN() Function

TEXTJOIN() combines multiple text values and allows you to specify a delimiter between them.

Syntax:

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

Example:

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

If the cells contain:

• SQL

• Python

• Excel

• Power BI

Result:

SQL, Python, Excel, Power BI

📌 What Does TRUE Mean?

The second argument controls whether empty cells should be ignored.

TRUE → Ignore empty cells

FALSE → Include empty cells

Example:

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

This is particularly useful when some cells may be blank.

📌 CONCAT() vs TEXTJOIN()

CONCAT():

• Combines text.

• Does not provide a delimiter argument.

• Useful when you want precise control over separators.

TEXTJOIN():

• Combines multiple values.

• Allows you to specify a delimiter.

• Can automatically ignore empty cells.

• Great for combining lists.

📌 Real-World Example

Suppose you have:

First Name Last Name City

Rahul Sharma Pune

Create a complete profile:

=TEXTJOIN(" - ",TRUE,A2:C2)

Result:

Rahul Sharma - Pune

📌 Common Mistakes

❌ Forgetting to add a delimiter when needed.

❌ Using FALSE when blank cells should be ignored.

❌ Adding unnecessary spaces inside the formula.

📌 Real-World Uses

• Combine first and last names.

• Create unique IDs.

• Combine address components.

• Build product codes.

• Create comma-separated lists.

• Prepare data for reports and dashboards.

✅ Quick Tip

Remember:

CONCAT() → Combine text

TEXTJOIN() → Combine text + choose a separator + ignore blanks

💡 For modern Excel, TEXTJOIN() is especially useful when you need to combine an entire range rather than manually joining each cell.

Double Tap ❤️ For More

📊 𝗕𝘂𝗶𝗹𝗱 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼 | 𝟱 𝗛𝗮𝗻𝗱𝘀-𝗢𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 🚀

Learning Data Analytics? Don't stop with tutorials — build real projects that you can showcase on your resume and portfolio! 💻

🔥 Practice with 5 Hands-On Projects covering:

🗄️ SQL
📊 Excel
📈 Tableau
📉 Power BI

🔗𝗟𝗶𝗻𝗸 👇:- 

https://pdlink.in/45LLDH7

🎓 Perfect for Students | Freshers | Data Analyst Aspirants | Beginners

📊 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 🚀

Want to start a career in Data Analytics & Business Intelligence? Learn Power BI through Microsoft learning modules and build practical, job-relevant analytics skills.

🎯 Perfect for Students | Freshers | Data Analyst Aspirants | Working Professionals

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4zhGTX6

🔥 Start learning Power BI and turn raw data into powerful business insights!

𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 😍

Build real AI products - not just prompts

🎯 Program Highlights:-

🚀 15+ AI Projects
👨‍🏫 Live Online Classes + 1-on-1 Mentorship
💼 End-to-End Placement Support
🤝 500+ Partner Companies
🎓 2000+ Students Placed
💰 Average Salary: ₹7.4 LPA
🏆 Highest Salary: ₹41 LPA

🔗 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼 𝗖𝗹𝗮𝘀𝘀:-

https://pdlink.in/4fWJVID

🔥 Learn AI → Build Real Projects → Create Your Portfolio → Become Job Ready

📊 Excel Basics #26 – LEN(), FIND() & SEARCH() Functions

When working with real-world data, text is often messy.

You may need to count characters, find specific words, or locate symbols inside text.

That's where LEN(), FIND(), and SEARCH() become useful.

📌 1. LEN() Function

LEN() counts the number of characters in a text string.

Syntax:

=LEN(text)

Example:

=LEN("Excel") → Result: 5

Spaces are also counted.

=LEN("Data Analyst") → Result: 12

📌 2. FIND() Function

FIND() returns the position of one text string inside another.

Syntax:

=FIND(find_text, within_text, [start_num])

Example:

=FIND("@","rahul@gmail.com") → Result: 6

The "@" symbol appears at position 6.

⚠️ FIND() is case-sensitive.

=FIND("A","Data") finds uppercase "A". Searching for lowercase "a" gives a different result.

📌 3. SEARCH() Function

SEARCH() also finds the position of text inside another text string.

Syntax:

=SEARCH(find_text, within_text, [start_num])

Example:

=SEARCH("analyst","Data Analyst") → Result: 6

Unlike FIND(), SEARCH() is not case-sensitive.

So =SEARCH("ANALYST","Data Analyst") also returns: 6

📌 FIND() vs SEARCH()

FIND():

• Case-sensitive

• Does not support wildcards

• Useful when exact capitalization matters

SEARCH():

• Not case-sensitive

• Supports wildcards such as ** and ?

• Useful for flexible text searches

📌 Real-World Example

Suppose: A2 = "rahul.sharma@gmail.com"

Find the position of "@":

=FIND("@",A2) → Result: 13

Count the total characters:

=LEN(A2)

Use with LEFT(), RIGHT(), or MID() to extract parts.

To extract everything before "@":

=LEFT(A2,FIND("@",A2)-1) → Result: rahul.sharma

📌 Common Mistake

If FIND() or SEARCH() cannot find the text, Excel returns: #VALUE!

Handle it using:

=IFERROR(SEARCH("@",A2),"Not Found")

📌 Real-World Uses

• Find "@" in email addresses

• Locate hyphens or separators in IDs

• Count characters in customer names

• Extract usernames from email addresses

• Clean and transform raw datasets

• Identify whether specific text exists within a cell

Remember:

LEN() → How many characters?

FIND() → Where is it? Case-sensitive

SEARCH() → Where is it? Not case-sensitive

These functions become even more powerful when combined with LEFT(), RIGHT(), MID(), and IFERROR().

Double Tap ❤️ For More

🇮🇳 𝗙𝗥𝗘𝗘 𝗚𝗼𝘃𝗲𝗿𝗻𝗺𝗲𝗻𝘁-𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🎓

Upgrade your skills with *SWAYAM*, an initiative by the Government of India!

✅ Learn from leading institutes and expert educators
✅ Courses in AI, Programming, Data Science, Business & more
✅ Suitable for students, freshers and professionals
✅ Learn online at your own pace
✅ Strengthen your résumé with valuable certifications

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:- 

https://pdlink.in/4gc1MKx

📢 Share this opportunity with your friends and classmates!

🚀 DATA ANALYTICS + AI: YOUR NEXT CAREER MOVE!

Data is everywhere. The right skills can put you ahead.
Join the PW Skills Data Analytics With AI Course and learn Excel, SQL, Python, Power BI & AI tools through live sessions and real-world projects.

✨ What you get:
✅ Industry-relevant Data Analytics skills
✅ AI-powered learning
✅ Microsoft collaboration
✅ Hands-on projects
✅ Job assistance*
✅ Live classes in Hinglish

📅 Starts: 14th August 2026
⏳ Duration: 5 Months
🔥 Ready to become a future-ready Data Analyst?
👉
Enroll Now & Start Your Upskilling Journey!
https://lp.pwskills.com/data-analytics-with-gen-ai-online-course?utm_source=telegram&utm_medium=influencer&utm_campaign=deepakDAonline

📊 Excel Basics #25 – Text Functions: LEFT(), RIGHT() & MID()

Text functions are extremely useful when working with names, IDs, codes, email addresses, and other text-based data.

Three important functions to learn are:

👉 LEFT()

👉 RIGHT()

👉 MID()

📌 1. LEFT() Function

LEFT() extracts a specified number of characters from the beginning (left side) of a text string.

Syntax:

=LEFT(text, [num_chars])

Example:

=LEFT("EXCEL2026",5)

Result: EXCEL

Another example:

If A2 = "EMP-10245"

=LEFT(A2,3)

Result: EMP

📌 2. RIGHT() Function

RIGHT() extracts a specified number of characters from the end (right side) of a text string.

Syntax:

=RIGHT(text, [num_chars])

Example:

=RIGHT("EXCEL2026",4)

Result: 2026

If: A2 = "EMP-10245"

=RIGHT(A2,5)

Result: 10245

📌 3. MID() Function

MID() extracts characters from the middle of a text string, starting at a specified position.

Syntax:

=MID(text, start_num, num_chars)

Example:

=MID("EMP-10245",5,5)

Result: 10245

Here:

• 5 → Starting position

• 5 → Number of characters to extract

📌 Real-World Example

Suppose you have Employee IDs:

Employee ID

EMP-10245

EMP-10321

EMP-10456

Extract the prefix:

=LEFT(A2,3)

Result: EMP

Extract the employee number:

=RIGHT(A2,5)

Result: 10245

📌 Another Example – Product Codes

Suppose: A2 = "IND-LAP-2026"

Country code:

=LEFT(A2,3)

Result: IND

Product code:

=MID(A2,5,3)

Result: LAP

Year:

=RIGHT(A2,4)

Result: 2026

📌 Common Mistakes

❌ Using the wrong character position in MID()

❌ Forgetting that spaces count as characters

❌ Extracting a fixed number of characters when the text length varies

📌 Real-World Uses

• Extract employee IDs

• Separate product codes

• Extract country or department codes

• Clean customer data

• Process invoice numbers

• Prepare data for analysis

✅ Quick Tip

LEFT() → Extract from the left ⬅️

RIGHT() → Extract from the right ➡️

MID() → Extract from the middle 🎯

These functions are especially useful when cleaning and transforming raw data before analysis.

Double Tap ❤️ For More