Excel Cell Format Not Changing
Sometimes, when dealing with Excel, we can get some inexplicable errors that we have to deal with. Some of these can be really…
Author: Harun Spahic
Calculate Normal Distribution Probability in Excel
There are a lot of statistical measures and terms that are used and can be calculated using Excel. One of these terms is…
Using Special Characters in Named Ranges in Excel
When working in Excel, there are a lot of ways to mark our data. Named ranges are used to assign a name to…
Mood’s Median Test in Excel
Although Excel has many built-in formulas that fall under many categories: statistical, mathematical, logical, and many more, there are some things that cannot…
Excel VLOOKUP and MID for Data Analysis
Excel formulas are made in a way that complicated things can seem easy. There is always an option to combine the formulas to…
Excel SUMIF with INDEX & MATCH
Although Excel formulas are powerful as a standalone option, their true power can be seen when combined. INDEX and MATCH are two formulas…
Move Column Using Excel VBA
As you are probably aware by now, anything that can be done in Excel, either automatically or manually, can be done through Visual…
Merge and Unmerge Cells using Excel VBA
Although Excel is a great tool for automating your work, Visual Basic for Applications (VBA) is even better tool to achieve this. All…
Excel R-squared Analyzing Linear Regression
Excel is a great tool for all kinds of analysis. It encompasses mathematical, statistical, financial, and many other formulas. One of the most…
Count Merged Cells in Excel
In Excel, you can combine all the existing formulas with the data that you have. However, there are some limitations for which we…
