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

VBA Function - INSTR

INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Karthik Dale

0 0

Excel Keyboard Shortcuts Daily Usefull Keys

Excel KeyBoard Shortcuts Daily Usefull keys: CLTR A-Z Shift SELECT.ETC ALT All Tool Keys CLTR A Select All Shift+F11 Add New Sheet CLTR C Copy ALT...

Ninety-nine Excel Academy

0 0

Learn in Excel To Create a LIST in One Minute

Sanjay Singh

7 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

Dget-Extract From A Database A Single Record That Matches The Condition We Specify

Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...

Daniel I

1 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

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

19 Answers

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

8 Answers

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

12 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

What is shortcut to rename the spreadsheet name?

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