true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Today WE LEARN a excel formula like UPPER FUNCTION

Saurabh Sharma

16/09/2019 0 0

Here we are using upper case formula, these formula are used in advanced excel.

A	B	C
1	Hansraj	HANSRAJ	=upper(TEXT) =UPPER(B1)
2	lakir	LAKIR	=UPPER(B2)
3	Seema	SEEMA	=UPPER(B3)
4	Mansi	MANSI	=UPPER(B4)
5	jyoti	JYOTI	=UPPER(B5)
6	mahima	MAHIMA	=UPPER(B6)
7	shashi	SHASHI	=UPPER(B7)

0 Like 0 Dislike

Follow 1

Other Lessons for You

Use of Indirect Function

I would like to share my experience of how Indirect formula helped me in my recent project. I was working with some report which was connected to a large database in excel, so whatever changes I made to...

Kaustubh Chavan

0 0

Create a Grading in Excel using Formulas (All versions)

Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

0 0

Pivot table - Transform numbers in calculated field

How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Phanitha P.

0 0

Shortcut of Excel for Selection

Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...

Shashank Maheshwari

1 0

Advanced Excel - Excel What-If Analysis Goal Seek !

Amey Vidvans

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

What is the use of Data validation commond. can you demonstare the example in common life?

5 Answers

How many days it will take to complete advance excel course?

12 Answers

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting...

19 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

Excel formulas in advance level?

39 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.