How to Remove Scientific Notation in Excel
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 …
Formulas
How to Calculate Tiered Commission in Excel (Using IF/VLOOKUP)
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 …
How to Get the Cell Address Instead Of Value In Excel?
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 …
How to Subtract Percentage in Excel (Decrease Value by Percentage)?
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 …
Formula Bar in Excel – Show/Hide Formula Bar!
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 …
How to Remove Space before Text in Excel
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 …
Get Unique Values from a Column in Excel
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 …
Weighted Average Formula In Excel (Examples)
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 …
How to Separate Names in Excel
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 Formula in Excel
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 …
How to Calculate Percentage Difference in Excel (Formulas)
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 …
SPILL Error in Excel – How to Fix?
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 …