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 …
Steve Scott
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 …
How to Create a Waterfall Chart in Excel?
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 …
How to Create Win/Loss Sparklines Chart in Excel?
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 …
How to Group by Months in Excel Pivot Table?
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, …
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 …
Extract Last Name in Excel
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 …
Find the Closest Match in Excel (Nearest Value)
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 …
How to Delete Chart in Excel? (Manual & VBA)
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 …
Count the Number of Yes in Excel (Using COUNTIF)
Excel is quite commonly used in processing survey data and results. In many cases, these surveys are used to collect user responses as Yes or No. and then as part …
How to Concatenate with Line Breaks in Excel?
In Excel, you might come across situations where you need to combine strings into a single cell, but you want to display them in separate lines. For example, you might …
Can’t Type In Excel – How to Fix!
This is going to be a trouble-shooting tutorial where we are going to focus on what to do if you can’t type into a cell in Excel (i.e., you type …