Jupiter Solutions- feel the power of excel with us
GOAL: To pull digits from alphanumeric strings. If length and position of numeric data is fixed we can extract digits using built in functions of Excel e.g. LEFT, RIGHT and MID. Our goal is to develop a formula/ function by which we can pull digits from alphanumeric...read more
Number format used in India is different from the international style. It’s same up to “Ten thousand” but after that it’s totally different. Have a quick view here below: To know more about Indian number system please visit:...read more
Excel maintains 15 digits of internal precision; however, we may choose any format of our choice to display the number in the worksheet. Suppose, all the cells in my worksheet are formatted with “comma style”; i.e., it will display only two digits after decimal. Now,...read more
Just try to search out “Gantt Chart” on web once; you will get endless information. If I summarize the same – “Gantt Chart” is a type of bar chart devised by an American engineer and management consultant to represent timeline of different activities of a project....read more
A number of options are available for adding time in Excel. We may use built-in functions “TIME” or “SUM”, depending on how we have recorded the time in the worksheet. Excel allows us to capture “Hour”, “Minute” and “Second” in separate cells as well as in one too....read more
Let’s have some fun with excel. In today’s post I am presenting a game on excel viz. “Magical Mirror”. In fact, it’s a mind reader game; the mirror will show what you are thinking. In worksheet itself I have explained the playing rules. So, what you are waiting for?...read more
There is no defined rule to capture data in Excel worksheet; however, it’s always advisable to record details in tabular form and don’t leave blank cells in between. Some users don’t want to repeat the values as shown here in the zone column below: In such cases we...read more
There is no defined way for keeping data in excel. Excel users maintain data as desired or as they feel easier to handle. Some users keep data in one worksheet for a week while others for a month. Generally all these weekly or monthly data sheets have common formats...read more
Suppose, one day you have started excel as usual but your excel sheet column headers are appearing as 1, 2, 3 instead of A, B, C. Also when you select any cell, in name box excel displaying cell address as R1C1 instead of A1, where R stands for row and C stands for...read more
If we have to count only odd or even numbers from a data list in excel, we have a number of options available as discussed here: If possible add an extra column just beside the data list you want to count. Suppose data is in column “C” and you have entered a new...read more
Anything and Everything in Excel!
Are you scared stiff of any topic in excel?