DATA ANALYSIS MADE EASY
Відкрити в Telegram
8 761
Підписники
-324 години
-187 днів
-6030 день
Архів дописів
PROPER(), UPPER(), and LOWER() functions in EXCEL🔥
1. PROPER Function:
The PROPER function converts the first letter of each word in a text string to uppercase and converts the remaining letters to lowercase.
It's commonly used to format names, addresses, or any other text where proper capitalization is required.
Example:
Suppose cell A1 contains the text "hello world." To apply the PROPER function, you can use the following formula in another cell:
=PROPER(A1)
The result will be "Hello World."
2. UPPER Function:
The UPPER function converts all letters in a text string to uppercase.
It's useful when you want to convert an entire text string to uppercase, regardless of the original case.
Example:
Let's assume cell A1 contains the text "hello world." To convert it to uppercase using the UPPER function, you can use the following formula in another cell:
=UPPER(A1)
The result will be "HELLO WORLD."
3. LOWER Function:
The LOWER function converts all letters in a text string to lowercase.
It's useful when you want to convert an entire text string to lowercase, regardless of the original case.
Example:
Consider cell A1 with the text "Hello World." To convert it to lowercase using the LOWER function, you can use the following formula in another cell:
=LOWER(A1)
The result will be "hello world."
the amount of locking in and consistency it takes to master a skill is crazy.
Start applying the things you learn.
Learning without applying is intellectual entertainment.
You’re fooling yourself if you think reading, watching tutorials, or stacking certificates makes you skilled. It doesn’t.
Nobody cares how many courses you’ve finished, if you can’t do the work and deliver results.
The market pays for execution, not consumption.
Every day you delay applying what you’ve learned, you’re widening the gap between knowledge and skill. That gap is where procrastinators rot.
So if you’ve been learning SQL, Power BI, or Python, and you’re not building projects, solving problems, or sharing what you’ve done — you’re not learning, you’re hoarding.
Stop clapping for yourself in silence.
Apply it.
Show your work. Fail publicly if you must, but move from theory to practice
That’s the only way you’ll ever grow.
COUNTIF FUNCTION IN EXCEL from DATA ANALYSIS MADE EASY
The COUNTIF function is a built-in function in Excel that is used to count the number of cells in a range that meet a specific criteria.
The syntax of the COUNTIF function is as follows:
=COUNTIF(range, criteria)
where "range" refers to the range of cells that you want to count, and "criteria" refers to the condition or criteria that you want to apply to the cells.
Here are three examples of using the COUNTIF function:
Example 1: Counting cells that meet a specific condition
Suppose you have a range of cells (A1:A10) that contains the grades of students in a class, and you want to count the number of students who scored above 80.
You can use the COUNTIF function as follows:
=COUNTIF(A1:A10,">80")
This formula will count the number of cells in the range A1:A10 that are greater than 80.
Example 2: Counting cells that contain a specific text string
Suppose you have a range of cells (A1:A10) that contains a list of countries, and you want to count the number of cells that contain the word "USA". You can use the COUNTIF function as follows:
=COUNTIF(A1:A10,"USA")
This formula will count the number of cells in the range A1:A10 that contain the text string "USA".
Leave a ❤️, if this helps.
Take advice from practitioners not theorists.
Let those who have proof of work show you how it is done.
Not those who say they know it❗️
The miracle you’re looking for is in the work you’re avoiding.
The confidence you want, is in mastering a skill.
The money you want is in the value you don’t want to provide.
The good life you crave is in taking a big risk.
The MIRACLE is in ACTION you don’t want to take❤️
Would you recommend this FREE telegram channel to a friend?
If yes drop a ❤️ and share this link with them today: https://t.me/DATAANALYSISMADEEASY
The Bamboo Tree Analogy:
When you plant a bamboo seed, for years nothing breaks the ground.
You water it daily, but all you see is bare soil.
Then, one day, it shoots up and grows several feet in just weeks.
Learning a skill is the same.
Every hour you spend practicing, even if you feel stuck, is watering your bamboo.
The growth is invisible at first, but when it shows, it’s explosive🔥
Happy Sunday❤️
If you try to break a large stone in two with a hammer, it'll look like nothing is happening for the first few dozen (or the first few hundred) swings.
Then, suddenly, it'll crack. It looked like nothing was happening before that crack, but on an imperceptible level, you were making progress.
The same thing happens when making progress in life. You swing and swing and swing and swing, and nothing happens.
Then you get that crack, and you know winning is inevitable.
Don't stop swinging because there hasn't been a crack yet. Things are happening that you can't see.
Pick up your hammer.
You don't grow a plant by dumping a bucket of water and a full pack of nutrients on it.
You grow it by giving it a little bit of each consistently over a long period of time.
Goals are the same way.
An intense burst can be useful, but the magic happens when you stack a bunch of medium doses of work on top of each other for years in a row.
So, stay patient.
Time and consistency will get you where you want to go❤️
The Law of Options:
The more choices you have, the less certain you become.
Clarity doesn’t come from fewer options
It comes from focus.
Competition disappears the moment you stop copying and start doubling down on what feels natural to you.
You don’t have to learn to code because others are doing it.
You don’t have to be a content creator if it doesn’t feel natural to you.
You don’t have to be an entrepreneur if it’s not your thing.
You also shouldn’t be sitting in the office if you feel exhausted everyday just by seeing different faces
There are thousands things you’re good at. find a one and double down on it.
Your edge is the thing you do with ease.
Focus on it, and you’ll stand out without forcing it.
Focus on making progress, not perfection.Every good thing takes time. You can't rush things. Growth is not linear, but a journey; one filled with challenges and opportunities to push to your destination. No one can do it for you, it's your journey. And there will be days you'll want to give up, but you have to keep going. There are no shortcuts to getting there, so you have to embrace the process. Think progress, not perfec-tion. Allow yourself to grow in the process. Make room for failure too. Just do your daily practice and cultivate a kind heart. Bet on hard work. Abandon impatience. The results will come down when they're ready. Remember obsession and consistency over anything else❤️
The more skills you have, the less you’ll worry about money.
Money follow skills/values.
The focus should never be about how much you can make.
But on how much you can learn so deeply, so consistently that you will be so hard to ignore
Money follows values and values are created by mastering a skill
Skill first. Money second❤️
