5 Reasons Why your Excel Formula is Not Calculating

When your Excel formulas are not calculating, or not updating, it can be very frustrating. Your formulas are the driving force for your spreadsheet.

There are 5 reasons for your Excel formula not calculating are many. In this tutorial we explain these scenarios.

Watch the Video

Continue reading

Create a Geographic Heat Map in Excel – FREE Add-in

In this blog post we create a geographic heat map in Excel using a cool free Excel add-in. This add-in is extremely easy to use, meaning you can have an awesome looking geographic heat map on your Excel report in minutes.

The image below shows the data being used for this example. I have a list of countries and a number of online training subscribers.

This data has been plotted on an image of a world map using a red to green colour scheme.

Create a geographic heat map in Excel
Continue reading

4 Ways to Group Times in Excel – PivotTables and Formulas

If your spreadsheet contains a list of times, it is useful to group them into intervals such as 30 minutes, hourly or every 6 hours.

Fortunately Excel provides a variety of methods to group time depending on what you need. In this blog post we look at 4 ways to group times using PivotTables and Excel formulas. Continue reading

5 Ways to Use the Immediate Window – Excel VBA

The Immediate Window in Excel VBA is a very useful tool to help us step through, check and debug our code. In this blog post we explore 5 ways you could use the Immediate Window.

It is called the Immediate Window because you can ask questions about your code, run statements and get immediate results. This can help us to understand what our macro is doing, and why and where it may be going wrong.

Watch the video tutorial below, or continue reading the full tutorial.

Continue reading

4 Excel MOD Function Examples – Excel Formula Tutorial

The MOD function of Excel is used to return the remainder after one number is divided by another. Simple, but there are some very useful examples of the MOD function.

In this blog post we explore 4 Excel MOD function examples. Hopefully this will help to see how versatile this function can be.

To start we better have a quick introduction to how to use the MOD function. It looks like this;

=MOD(number, divisor)

You need to provide it first with the number you want to divide, and then the number you want to divide it by (divisor).

You can see some basic examples of this below.

Basic MOD function examples

Ok, lets get on with some more impressive real-world MOD function examples. Continue reading

Highlight the Cells that Contain a Specific Word (and it Matches Case)

In this blog post we look at how to highlight the cells that contain a specific word. We will also ensure that the word in the cell matches the case of the word being looked for.

For this example we have a list of the Ballon d’or winners of all time. Column B contains 3 letters in uppercase (after the name) which identify the country that the player represented at the time of winning the award.

In cell E1 I have entered the 3 digits for a country. I would like to automatically change the colour of all the cells that contain the country written in E1.

Highlight cells containing specific text

There is a good chance that the 3 digits identifying a country could also occur in a players name. For example, the letters for France – FRA do occur in the name Franz Beckenbauer.

To prevent this happening we will match the case of the word we are searching for, as it is always written in upper case. Continue reading

4 Excel VLOOKUP Examples – Why You Should Use VLOOKUP Function

When learning the VLOOKUP function, one of the things people can struggle with is seeing why this function is so useful. In this blog post we look at 4 VLOOKUP examples.

The purpose of VLOOKUP is to look for a value and return some information about that value. Although quite specific in its role, this function can be used in some very clever and interesting ways. Continue reading

Using Wildcard Characters in Excel Formulas

Wildcard characters can be used in Excel to perform partial matches on text. This can be extremely useful as you can use them in filters, the find and replace tool and especially in formulas.

This blog post explores some examples of using wildcard characters in formulas to find, sum or count cells containing partial matches to what we are searching for.

If you prefer a video tutorial then check it out below, otherwise please continue for the written tutorial.

Continue reading

5 Groovy SUMPRODUCT Examples – Advanced Excel Formula Tutorials

In this blog post we look at 5 groovy examples of the SUMPRODUCT function. This is one of the great functions of Excel. A function that can turn you from being an Intermediate/Advanced Excel user to an Excel guru instantly.

The SUMPRODUCT function is powerful, versatile and expansive. It is the go to function when looking for an alternative to array formulas.

If you are a newbie – check out our SUMPRODUCT function guide to get an understanding of how it works.

Ok, are you ready to rock on with these 5 awesome SUMPRODUCT examples?

Let’s do this.

If you prefer to watch videos, check out this video covering the tutorials from this blog post.

Continue reading

5 Excel INDIRECT Function Examples

In this blog post we look at 5 examples of the INDIRECT function of Excel. This is a very misunderstood function, which can be incredibly useful and powerful.

Prefer to watch the video? The video tutorial below will demonstrate all 5 INDIRECT function examples.

Continue reading