Excel Tips - Tip 8 (Converting Numbers into Words)

Hello,

I hope you are finding these emails to be useful. Thanks a lot for your feedback.

Here is a Tip for Today. Hope this help you.

Using formulae “amtinwords()” is very easy and effective.

Amount	Formulae	Output	Remarks
123456	=amtinwords(B19)	Rupees One Lakh Twenty Three Thousand Four Hundred Fifty Six Only	Convert the number into Words

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel enthusiast

+91-9045773456

Excel Tips - Tip 7 (Using IFERROR() formulae)

Hello,

I hope you are finding these emails to be useful. Thanks a lot for your feedback. :)

Here is a Tip for Today.

Have you ever faced problem in handling errors in MS excel, (example : where you have to use IF() formula with the condition as a Vlookup() output.)

Here is how you can handle the errors in MS Excel using IFERROR() formula.

Note : Error evaluated by IFERROR:#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456

Excel Tips - Tip 6 (Using SUMIF formulae)

After all the appreciation and positive feedback, I am pleased to continue my tips.

Here is the Sixth tip for you. Hope this help you.

Using SUMIF Formulae is very easy and effective.

SUMIF() & SUMIFS()

How it help us :

Add all Values in range with a specific criteria or Multiple Criteria

How to use it :

=SUMIF(Range,crietria,[sum_range])

=SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2],...)

Here are some Examples for the same.

Points to remember while using SUMIF()

1. SUMIF() adds values based on a single criteria and SUMIFS()adds values based on a Multiple criteria.
2. If sum_range argument is omitted, Excel uses the criteria range (range) as the sum range as default.
3. Criteria could be a number, expression, cell reference, text, or a formula
4. Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes i.e. (“”)

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456

Excel Tips - Tip 5 (Using CONCATENATE)

Hello,

Hope my excel tips are helping you out.

Here is the Fifth tip for you. Hope this help you.

When we have to merge the text of different cell in one single cell, then we use the shortcut  CONCATENATE.

With this formulae we can join text of different Cells.

Here are some Examples for the same.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel enthusiast

+91-9045773456

Excel Tips - Tip 4 (Change Text using Formulae)

Hello,

Hope my excel tips are helping you out.

Here is the Fourth tip for you. Hope this help you.

To make a report, Text is very Important. So here a tip to change your text according to your need.

·         LOWER( ) - Converts all uppercase letters in a text string to lowercase.

·         UPPER( ) - Converts all lowercase letters in a text string to uppercase.

·         PROPER( ) - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. In other words, it converts the string into sentence case.

·         TRIM() -  It help to delete unwanted spaces between a sentence.

·         LEFT() -  It helps to select the text from Left

·         RIGHT() - It helps to select the text from Right

·         MID() – It helps to Select the text from middle

Here are some Examples for the same.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

+91-9045773456

Excel Tips - Tip 3 (Converting Text from row to column or Vice-versa)

Hello,

Hope my excel tips are helping you out.

Here is the third tip for you. Hope this help you.

Using formulae (Alt+E+S+E) is very easy and effective.

Converting Text

(Transpose means -  Converting Text from row to column or Vice-versa)

How to use it :

Step 1- Select the Text which you want to Transpose

Step 2- Use Ctrl+C of the desired Row/columns

Step 3- Go to the desired cell where you want the data

Step 4- Use Alt+E+S+E and press Enter

The Text has been converted

Here are some Examples for the same.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

+91-9045773456

Excel Tips - Tip 2 (Using IS formula)

Hello,

Thanks for the appreciation you have given to me on my first excel tips.

Here is the Second day Tip for you. Hope this help you.

Using IS Formulae is very easy and effective.

IS Formulae Family

ISBLANK() ; ISERROR() ; ISNA() ; ISNUMBER() ; ISEVEN() ; ISODD() ; ISTEXT() ; ISNONTEXT()

How it help us :

Check the specified values and give us TRUE or FALSE depending on Outcome

How to use it :

= ISBLANK() ; ISERROR() ; ISNA() ; ISNUMBER() ; ISEVEN() ; ISODD() ; ISTEXT() ; ISNONTEXT()

Here are some Examples for the same.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

+91-9045773456

MS Excel Tips: Tip No. 1 (toggle between open spread sheets)

MS Excel Tips: Tip No. 1 (toggle between open spread sheets): It very frustrating when you have multiple applications open (such as Excel, PowerPoint, Word, Chrome, and IE) and you want to switch betw...

Tip No. 1 (toggle between open spread sheets)

It very frustrating when you have multiple applications open (such as Excel, PowerPoint, Word, Chrome, and IE) and you want to switch between excel spread sheets only. No matter how efficient you are, this can get on to your nerves in a few minutes. In this tip, let me show you how to be more efficient

Use Control + Tab to toggle between open spread sheets only (Keep the Control button pressed while you press Tab button to switch)

That’s it! It is simple and will save you a lot of time

Note: While most of the people are addicted to Alt + Tab, the drawback is that it does NOT differentiate between different applications. So if you have 2 excel workbooks open along with a Chrome/FireFox/IE browser window, it will toggle one by one through each of these. Control + Tab will toggle between open excel workbooks only.

Bonus Tip : This technique works with any Microsoft application, including Power Point and Word

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Thanks & Regards

CA Mohit Bansal

+91-9045773456