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

Did you know about Shortcuts of Excel

Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create Ctrl+Shift+F6 Previous Window Window, ... Ctrl+Shift+F12 Print File,...

Sain Learning Centre

0 0

Datedif() Function

Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Saburudeen MA

0 0

Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)

Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Ankur Sharma

2 0

Conditional Formatting In Excel - Part 1

Pratap Narula

0 0

Excel-Select All Data/Columns/Rows with One Click

You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, all data/Columns/Rows will be selected in seconds.

Antony

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

Can a person learn advanced level MS Excel through YouTube videos?

7 Answers

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

5 Answers

Dear sir,how to convert number to text in excel by formula?

8 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.