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

Shortcut for adding big data or Columns in MS excel

1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 0

VBA Function - RIGHT

RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik Dale

0 0

For the Best Training You Need the Best Trainer

Microsoft Excel Beginner, Intermediate and Advanced course will provide a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level to learners. Microsoft...

Prasad

0 0

Hidden Gems of MS Excel - Reapply Filter

Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma

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

Excel formulas in advance level?

39 Answers

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

5 Answers

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

9 Answers

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

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