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.

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.

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.

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.

Use COUNTBLANK to count empty or blank cells in a range in Excel

COUNTBLANK allows you to count the number of empty or blank cells in a range in Excel. This lesson shows you how to use COUNTBLANK, and also shares a couple of things to watch out for when you use COUNTBLANK in an Excel formula.

How to lookup the name of the highest selling sales person in the month

In this lesson, we look at a specific example where you have a table of sales data, and you need to find out the name of the person who had the highest sales for the month. It's one of those things that seems like it should be easy until you actually try to do it. The solutions we present here are not the only way of achieving this, but the do have the advantage of solving the problem with a single formula. The methods here could also be used for a variety of other applications as well.

Use the keyboard to move between worksheets in a workbook

One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it's easy, and you don't need to wait as long as I did.

Create a PDF from Word, Excel, PowerPoint or any Microsoft Office document

If you need a free option to create a PDF of a Microsoft Office document, your options will depend on which version of Microsoft Office you are using.

Use the MATCH function in Excel to find the position of a value in a list

The MATCH() function allows you to find the position of a value in a list. For example, in a list of weekdays starting with Monday, MATCH() would return a value of 3 for Wednesday. This lesson explains how to use the MATCH() function in Microsoft Excel, explains where you might use it, and provides a real world example of the MATCH() function in action.