While Excel is built to work with large numbers, when you enter a number that has more than 11 digits, you would notice that these are converted into scientific notation …
Tiered commissions are quite common for people who do sales. Tiered commissions provide an incentive for salespeople to boost their sales figures in order to earn more commission. This, in …
In Excel, we often use formulas like INDEX/MATCH, VLOOKUP, and XLOOKUP to match the lookup value but in some scenarios, we came across a situation in which we lookup for …
Most Excel users, who work with numbers, also have to deal with percentages in Excel. One of the everyday tasks is to subtract percentage values in Excel. A common example …
In this Excel tutorial, I will tell you everything you need to know about the Formula bar in Excel. A lot of Excel users use the formula bar, and it …
One thing that often irritates a lot of Excel users is when you have spaces before the text in a cell. While it may look harmless, these could be quite …
Unique values are those that appear on a list just once. When working with data in Excel, you will often come across datasets that have duplicates in the column and …
You might come across some data distributions where different quantities carry different levels of importance (or weightage). A standard average is not really a good representation of such distributions, since …
Performing operations on names like search, sort, filter, etc. is usually easier when full names are separated into separate columns. In fact, separating names is such a frequently performed data …
Compound interest is a concept heavily used by the banking and finance industry. If you’re investing or saving money in a bank, Compound Interest is the magical formula that is …
The term ‘percentage difference’ is often misunderstood. A lot of people get mixed up between the terms ‘percentage difference’ and ‘percentage change’. Both are completely different concepts and have completely …
If you’re using Excel 365 or newer versions, you might have come across the SPILL error. This is a new error code that you will find in addition to the …