Create a **five star rating system in Excel using Conditional Formatting**. This can be a useful way of visualising ratings like you see on eBay and Amazon.

# Category Archives: Intermediate

# Excel Char Function with Examples

The **CHAR function of Excel** returns a character specified by a code, from the character set of your computer.

In this blog post we look at why you might want to use the CHAR function, and some examples of it in action in Excel.

The CHAR function is typically used to insert, or to find, a character which you ordinarily cannot type from your keyboard.

To use it you will need to find out what the code is for the character you want to use.

You can search online for a full list of these character sets so that you know each code (or at least the one you need at the given time). These character sets differ between the Windows and Mac computers, and are also dependent upon the language used. 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.

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

# 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.

Ok, lets get on with some more impressive **real-world MOD function examples**. 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.

# 4 Amazing Tips for the CONCATENATE Function

The most commonly used text function of Excel is CONCATENATE. This brilliant function join text together into one cell. This is typically a combination of written text, and text that is contained with cells on the spreadsheet.

The example below is a typical example of CONCATENATE. In this example, it is being used to join the first name and last name and insert a space in between. The formula below is written in cell C2.

=CONCATENATE(A2,” “,B2)

This blog post uncovers **4 amazing tips to take your CONCATENATE functions to the next level**. Continue reading

# The WEEKDAY Function in Excel – Two Examples

Excel has many wonderful date and time functions. These functions are some of the most popular in Excel.

**One that drifts under the radar a little is the WEEKDAY function**. This function will return a number that identifies the day of the week of a date.

This can be very useful. This blog post will look at two examples of what the WEEKDAY function can do for you. Continue reading

# Excel Formula for Elapsed Time in Days, Hours and Minutes

Having to calculate date and time difference in Excel is a common task. Unfortunately, depending on your requirements it is also not always a simple one.

Take this example where column A contains a start date and time, and column B an end date and time. We wish to **calculate the elapsed time in days, hours and minutes** e.g. 11 days 4 hours 9 minutes.

There are multiple ways of calculating date and time difference in Excel. In this scenario we will need to get a little clever.

As you may well know, date and time values are stored as numbers in Excel. For example, the 05/01/2017 10:10 is stored as 42740.42.

Therefore, if I write the formula as =B2-A2, then the result is returned as 2.993056.

To return a result that makes sense to us, we will tackle the date and time parts of the cell separately. Continue reading