Steve Scott, Author at Spreadsheet Planet

SetFocus in Excel VBA – How to Use it?

User forms in Excel usually have a particular ‘tab order’ that automatically navigates you to a given control as and when you enter data. However, sometimes you might want to …

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 …

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 …

How to Break Links To External References in Excel?

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 …

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, …

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 …