Excel with Ease

13/01/2020

Hello Friends!!!

Today's post is just similar to my last post of Column Function. Hope you get something unique in that post. So here I am talking about the ROW Function of MS Excel which which is used to get the absolute position of any row with reference..

Here under is the link of the post which will help you a lot. Hope you also notice something new and unique in this blog.



https://www.excelwithease.com/2020/01/row.html

How to use ROW Function in MS Excel | Excel with Ease | Free Training

07/01/2020

Hello Friends!!!

Wish you a very Happy New Year!!!

Hope this year you may lead with your dreams and got what you want!!!

This year we in this Page will start with new and exiting view of excel with some unique feature by which developing algorithm and use of function become easy.

So friends with New Level of energy Me Ankit Kalra presenting the Column Function of MS Excel with some useful tips which you can tabulate for future use.

Here is a link of the same please visit the link below and if you find it useful please share with your friends and collegues:


https://www.excelwithease.com/2020/01/column.html

How to use COLUMN Function in MS Excel | Excel with Ease | Free Training

24/03/2018

Hey Guys!!!🙋‍♂️🙋‍♂️🙋‍♂️

In my previous post we talk about first and unique value but have you think about Last and unique one!!!😕😕😕

If yes than lets move on for some more question I have for you just read these and find answer for your questions arises like:-
👉👉Can Last and unique data number in a data table is find able??👉👉Can we find the same with formulas??👉👉Can it be automate and easy to implement?
🕵️‍♀️🕵️‍♀️👁️After today's post you have the answer "YES" for all the above questions. So lets go and follow the Link below:-
http://www.excelwithease.com/2018/03/last-and-unique-value.html

Follow us for more exciting and easy to understand ways to grab power of excel at...
https://www.facebook.com/excelwithease/

or join our group to get solution for your problems at https://www.facebook.com/groups/722317201305856

Cheers
Ankit Kalra
For Excelwithease

How to find Last and unique value in a set of data in MS Excel using Formulas / Functions?How to use countif with if function?

22/03/2018

💗💗💗🌹🌹🌹Thanks a Lot🌹🌹💗💗💗

This is all your support with which we reach at our first milestone of on .

A personalise solution to overcome problems related to heavy data management in excel.

17/03/2018

Hey Guys!!!🙋‍♂️🙋‍♂️🙋‍♂️

My today's post is the extended version of my last post and hope you remember that i.e. to find First and Unique Value in data.

Before going to further I would like you to think about following points:-
👉👉Have you ever try to use or or or in your data to get value for some items?👉👉If yes have you required to delete the result produced by these formulas in your data table to remove duplicate?👉👉 If yes then how do you remove these values?👉👉IS you answer manually?👉👉👉If yes then there is a perfect solution for you just follow the link and see how it is being done by formulas alone:-
http://www.excelwithease.com/2018/03/sum-for-first-and-unique-value.html

Follow us for more exciting and easy to understand ways to grab power of excel at...
https://www.facebook.com/excelwithease/

or join our group to get solution for your problems at https://www.facebook.com/groups/722317201305856

Cheers
Ankit Kalra
For Excelwithease

How to find sum for first and unique value in a set of data in MS Excel using Formulas / Functions? How to get total for unique value in set of data using formulas / Functions in MS Excel ?

10/03/2018

Hey Guys!!!

Have you ever require to get filter first and unique values from a data ? If yes what would you like to do then ? Do you do it manually ?
But if it is in whole data and regular job then what would you do?

Follow the link and see how you can find first and unique value from a data table using simple formulas:-
http://www.excelwithease.com/2018/03/first-and-unique-value.html

Follow us for more exciting and easy to understand ways to grab power of excel at... https://www.facebook.com/excelwithease/
or join our group to get solution for your problems at https://www.facebook.com/groups/722317201305856

Cheers
Ankit Kalra
For Excelwithease

How to identify first and unique value in MS Excel using Formulas?

24/02/2018

Hey Guys!!!

Perhaps some time you find that you have to break name into Prefix, First Name, Middle Name and Last Name or you have to combine all these to get Name.If it is one time then you can do it manually. But if it is in whole data then what would you do?

follow the link see how it has been done:-
http://www.excelwithease.com/2018/02/break-and-combine-names.html

Follow us for more update on power of excel at... https://www.facebook.com/excelwithease/
or join our group at https://www.facebook.com/groups/722317201305856

Cheers
Ankit Kalra
For Excelwithease

###xx

06/02/2018

Hi guys !!!
Today I have a typical example of date format change from 06/02/2018 to 6th February, 2018 in excel without using any macro or can app. It is just with few formulas.

Follow us for more update on power of excel at... https://www.facebook.com/excelwithease/
or join our group at https://www.facebook.com/groups/722317201305856/

Cheers
Ankit Kalra
For Excelwithease

05/01/2018

Here is a solution for a typical problem or requirement in an easiest way:
for more follow us at https://www.facebook.com/excelwithease/
or join our group at https://www.facebook.com/groups/722317201305856/

31/12/2017

Hi Guys!!!

Today I bring our last tutorial of the year which is on function DATEVALUE. In this article we try to give an overview of the use and mark the basic problem which cause the reason to error on use of this function. Just go through the tutorial at
http://www.excelwithease.com/2017/12/datevalue.html

13/12/2017

Hi Guys!!!

Today, we bring a tutorial on a logical function "AND". This function is very useful when we have to take decision when all the arguments will satisfy. If you like the tutorial then please like / share and follow:-
http://www.excelwithease.com/2017/12/and.html

07/12/2017

Today we have tutorial on Logical function "OR" which very important when we have to decide out of many conditions at least any one is true so that we can take our decision based upon it. So let's have look on the function "OR" in the following tutorial
http://www.excelwithease.com/2017/12/or.html

04/12/2017

Hi guys!!!
Today i brought you a tutorial on "CHOOSE" command of MS Excel. This command is really do the awesome job when we have to decide the change of range based on any condition. Just go through the tutorial and find interesting facts about this functions also....
http://www.excelwithease.com/2017/12/choose.html

How to use CHOOSE Function in MS Excel | Excel with Ease | Training

24/11/2017

Hey Guys !!!
Today! we brought our second tutorial in continuation of our recently launch series of VBA macros under the banner of "VBA Macros for Smart working". In our second tutorial we have trigger a very common requirement of merging different worksheets having same data column into one worksheets. Just go through the following tutorial.
http://www.excelwithease.com/2017/11/vba-for-merging-worksheets.html
Follow us for more updates

VBA tool for merging different worksheets of a workbook.

21/11/2017

Hey Guys !!!
We are happy to announce a series of VBA macros under the banner of "VBA Macros for Smart working". And brought a our first tutorial in which we have trigger a very common requirement of merging different workbooks with different worksheets into one workbook. Just go through the following tutorial and follow us for more updates:-
http://www.excelwithease.com/2017/11/vba-for-merging-workbooks.html

VBA tool for merging different worksheet of a different workbook in one workbook.

26/10/2017

Hi Guys!!!

Today we come with a very common function that is used for finding the position of the value in an array...just have look on it
http://www.excelwithease.com/2017/10/match.html

How to use Match Function in MS Excel | Excel with Ease | Training

18/10/2017

Hi guys...
Are you aware of MS Excel with all the basic functions n formulas....??? No...
Then here is a basic tutorial on MS Excel....
Learn in the comfort of your house....

http://www.excelwithease.com/p/index.html

###xx

10/10/2017

Hi Guys!!!

Welcome once again...Today we have bring a tutorial on the index function which can be used in number of ways .....Just read this tutorial...
http://www.excelwithease.com/2017/10/index.html

###xx

03/10/2017

Hi Guys!!!

Have you ever need to count the number of cell from a table or column or an array which satisfy a criteria???---Yes
Then how will you count them ...is manually by filtering???---Yes
Then you should read this article which will help you to count the number of cell with in a minute....Just read this article......
http://www.excelwithease.com/2017/09/countif.html

###xx

02/10/2017

Hi Guys!!!

Have you ever need to count the number of cell from a table or column or an array which include error or text fields also???---Yes
Then how will you count them ...is manually???---Yes
Then you should read this article which will help you to count the number of cell with in a minute....Just read this article......
http://www.excelwithease.com/2017/09/count.html

###xx

24/09/2017

Hi Guys!!!

Today I came with the tutorial of SUMIF Function. This tutorial will help you to understand this function very easily....

http://www.excelwithease.com/2017/09/sumif.html

###xx

24/09/2017

Hi Guys !!!

have you face the problem to multiply the two column and then add the result of those values ????
Yes!!! Okay and have listen about the "SUMPRODUCT" Function in excel.....
No.... then this article will help you a lot for your problem....

http://www.excelwithease.com/2017/09/sumproduct.html

###xx

10/09/2017

How to use Function HYPERLINK in Excel ....
Please read the following article.......
http://www.excelwithease.com/2017/09/hyperlink.html

###xx

14/08/2017

Hey guys Its time to register for the e-book "Be Smart"-with excel...

You can purchase this book directly from excelwithease.com only after registration....

This is limited edition book and only first 100 genuine registeration can purchase this book with 100% discount and next 100 can purchase with 80% discount on the release date......

So fast register today.....

https://docs.google.com/forms/d/e/1FAIpQLSdcX42BixxS4npBG_mn9cGBzbc-VwYGTfckU13fCvT4S7kZJg/viewform?usp=pp_url&entry.2005620554&entry.455598810&entry.1065046570&entry.1166974658&entry.839337160

Advanced request form for the E-book which is being distributed for free to first 100 persons on 28-09-2017.

21/07/2017

Hi Guys !!!

Do you know there is a single formula which can be used for getting maximum / minimum / larger / smaller / average / count /summ / product like 16 funtions even if your data contains error ?
Yes Guys!!! this is true......
read the following article which tells about this awesome funtion......
http://www.excelwithease.com/2017/07/aggregate.html

###xx

07/06/2017

Hey Guys now you can learn MS Excel by our video Tutorial series.........
Share and subscribe our You tube channel if you like and learn from tutorial.........
https://youtu.be/k1QUNNN2T64

This is official Broadcast for excelwithease.com. This is video training for MS Excel.

06/06/2017

http://www.excelwithease.com/p/chapter-i.html

23/05/2017

Hey Guys!!!
Our excelwithease team has launches FREELANCING SERVICES. For Detail information visit
http://www.excelwithease.com/p/freelancing-services.html

12/04/2017

Hi Guys!!!!!!

Now its easy updates about excel in your email. Just Subscribe on the following link
https://feedburner.google.com/fb/a/mailverify?uri=ExcelWithEase&loc=en_US
and verify your email by clicking the link that you received in your email account after subscription.

…will receive a verification message once you submit this form. FeedBurner activates your subscription to “EXCEL WITH EASE” once you respond to this verification message.

28/03/2017

###xx