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 …
Often when you inherit Excel files from other people, they can have links to other external Excel files and ranges. Many times, you don’t need to keep these links to …
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 …
Waterfall Charts are a popular mode of visualization, especially when it comes to analyzing and understanding change. They are known by different names like McKinsey Charts, Cascade Charts, and even …
Charts are always a great tool to visualize data. However, sometimes instead of a full-blown chart, you might prefer smaller charts that are more dedicated to a smaller subset of …
One of the most important applications of Pivot tables is summarizing your data. You can use Pivot tables to summarize data by a number of factors, including by month, day, …
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 …
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list. For example, we …
There are enough functions in Excel to help you if you need to find an exact match for a value from a list. However, if you’re looking to find the …
Charts are an excellent visualization tool, which is why we often end up having one too many in our worksheets. Sometimes we might even end up having multiple copies of …