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.

## Select cells quickly and easily in Excel using the keyboard instead of the mouse

Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here's a quick technique for selecting a range of cells in Excel.

1 comment

## Use SUMIFS to sum cells that match multiple criteria in Excel

The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the value of sales of a specific product by a given sales person (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.

## Hide the page title in Drupal 8

Learn how to control the display of the page title on different pages of your Drupal 8 website.

## Copying formatting from one cell to another using Format Painter

If you have formatted a cell and want to use the same formatting for another cell or cells, you can easily copy the formatting from that cell to as many additional cells as you like.

## Use COUNTIFS to count cells that match multiple criteria

The COUNTIFS function in Excel counts the number of cells in a range that match a set of multiple criteria. COUNTIFS extends the COUNTIF function which only allows one criteria. It is similar to SUMIFS, which will find the sum of all cells that match a set of multiple criteria. This lesson shows you how to use COUNTIFS and provides some practical examples to help you understand how it works.

## How to bulk clean spam posts and comments from your WordPress website

This lesson will show you how to find, flag and remove spam content from your WordPress website. It uses a database search to identify content that contains spam words, and flags them for removal so you can remove them safely via the WordPress admin dashboard.

## Print an Excel 2010 spreadsheet with header rows at the top of every page

When printing in Excel 2010 for Windows, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page.