Jupiter Solutions- feel the power of excel with us
Style – an Excel feature I am covering in this post is one of the most underutilized feature of Excel. You might be thinking this feature is not so popular because, it’s not useful or this feature is very hard to learn but it’s not true. Excel is...read more
In one of my post, I explained why in some cases it’s better to use INDEX with MATCH then VLOOKUP (link). However, with the formulas shared/explained you can pick the value against first match only, what if you want to pick values for second, third or nth match. A...read more
Have you heard about numerologists? Numerologists study influence of numbers in your life. One such number is sum of digits of your date of birth. Today we will see how we can add digits of a number. The trick is to break the number in individual digits and add them....read more
VLOOKUP is the most widely used built-in function of Lookup & Reference group in excel. We use VLOOKUP to pick data from a table array after matching a field in the first column. Syntax for VLOOKUP is The limitation of VLOOKUP is, value you are trying to match...read more
Sometime we may require to calculate the date for a particular weekday of a month. Today, we would learn to calculate the same using excel I decided to cover this topic in my blog when a reader asked me that whether it is possible to calculate the date of first Sunday...read more
Microsoft Excel is a versatile and user-friendly application, most of the time, you find more than one solution to resolve a problem In one of my post, I covered trick to convert cardinal number and date to ordinal (link) with the help of formulas. You can achieve the...read more
Banks and Financial Institutions always sanction the loans based on a defined set of rules, which involves paying capacity, value of property mortgaged, age of payee, etc., inter-alia. So, while doing any financial planning, we should calculate loan amount based on...read more
There are a number of built-in functions available in excel for counting; e.g., COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS; etc., but there is no function available to count only the unique items (like in a series 1,2,3,1,4,5,2,4 – 1,2,3,4,5 are unique). However, we...read more
We make our Investments with a hope that these will generate income for us, and will appreciate in future. So, naturally before taking any decision about investments, we would like to know the risk factors associated and their maturity value; i.e., how much we will...read more
“DATE” is written in different formats in different countries, and sometime even written differently in different parts of a country. You can maintain/change the date format as you wish by changes made in the “Region and Language” settings of your windows operating...read more
Anything and Everything in Excel!
Are you scared stiff of any topic in excel?