Best Excel Tutorial

Excel Skills Simplified: Tutorials That Actually Work

territory map sample data

How To Create A Territory Map In Excel?

Typically, we can create territory maps when we wish to compare statistics visually across multiple geographical areas. For example, you might create one to compare births or tax revenue by state, city, or country.

After you have acquired and selected the data, Excel automatically generates the territory map and uses differing levels of shading to indicate the level of values by geographical areas in the data.

Read More

A Simple OFFSET Usage

How to Use OFFSET Function in Excel

In this tutorial, you will learn how to use the offset function.

The OFFSET is a function that would return the range of cells, using the specified numbers of both columns and rows along with the beginning of the range, as it has been specified by the users. This is because the users have the ability to specify a size of range that would be returned, which gives the user a strong opportunity to decide the range.

Read More