Welcome to Fiveminutelessons.com. Get free online courses where you can learn more about Google Analytics, Microsoft Excel, and Microsoft Word, and be more productive in just five minutes.

Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.

## How to update or add new data to an existing Pivot Table in Excel

When you create a new Pivot Table, Excel either uses the source data you selected or automatically selects the data for you. But data changes often, which means you also need to be able to update your pivot tables to reflect the new or changed data. This lesson shows you how to update existing data, and add new data to an Excel pivot table.

## Set banding colors in Word 2010 table styles

Word 2010 offers Table Styles to allow you to apply a style to a table in your document.

One of the challenges that can stump you the first time around is setting the color styles for odd/even banding of tables or columns. This lesson describes how to set these on an existing or custom table style.

## Use COUNTIF to count the cells in a range that match certain values

Sometimes you need to count the number of cells in a spreadsheet that contain a value or set of values. The COUNTIF function allows you to do this by counting only those cells in the range that meet the criteria you set. This lesson explains how to use COUNTIF, and provides an example of how you can use it.

## Show or hide a menu item in Drupal 7 based on a user's location

This lesson provides a way in Drupal 7 to hide or show an individual menu item based on the location of each visitor. The use case for this example was to show a Shop menu item to visitors in New Zealand and Australia, and hide it for visitors from all other countries.

## Count the number of characters in a cell in Excel

This lesson introduces the LEN() function, which allows you to calculate the number of characters in a cell. This formula is useful on its own, or can be combined with other text functions such as RIGHT(), LEFT(), MID() and FIND().

## Use INDEX to lookup multiple values in a list

Excel's VLOOKUP function is excellent when you want to find a value in a table based on a lookup value. But if your table includes your lookup value multiple times, you'll find that VLOOKUP can't do it. This lesson shows you how to use the INDEX function (plus some other functions) to find all matching values in a list, and return a value from another column in the same row. It also looks at how to do this when you want to return all values which are a partial match (i.e. a wildcard search) to the values in your lookup table.

## Select all the blank cells within a range of cells

If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn't involve manually clicking on every one.

1 comment

## Convert a text value into a date in Excel

Sometimes you'll find yourself working with dates in an Excel spreadsheet that have been pasted or imported into Excel from another datasource. When that happens, Excel can treat those dates as text - in other words, they look like dates but don't behave like dates. For example you can't sort by date properly. This lesson looks at several ways you can convert a date which Excel is treating as text into a proper date value in Excel.