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.

## Use the Pivot Table Report Filter for even better pivot tables

The Pivot Table Report Filter adds another dimension to your pivot tables - literally. Rather than all of your data being presented in a flat table, the Report Filter lets you create a pivot table report and then change the data being presented using one or more Report Filters.

1 comment

## How to manage Product Tabs in WooCommerce

This lesson will show you how to rename, reorder and hide the default Product tabs in WooCommerce. It also introduces some of the concepts involved in using the functions.php file in your WordPress theme to override WordPress and WooCommerce code.

## Get scheduled email reports from the new Google Analytics

Google Analytics allows you to email reports from your account. This enables you to share reports with people who don't have access to your Google Analytics account, including people who are only interested in specific reports from Google Analytics. You can control which format the reports are sent in, and the frequency with which they are emailed. This lesson shows you how to set up email reports from Google Analytics, as well as pointing out a couple of things you should be aware of when setting them up.

## Calculate the number of days between two dates using Excel

This lesson shows you how to use Excel to calculate the number of days between two dates. It also shows you how to exclude weekends and holidays from the total.

If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.

## Using SUMIF to add up cells in Excel that meet certain criteria

The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That's where the SUMIF function comes in handy, along with the more capable SUMIFS function.

## Show or hide the Site Name and Site Slogan in Drupal 8

This lesson explains how to show or hide branding elements on your Drupal 8 site, including your logo, the site name, and the site slogan. Drupal 8 handles this differently to earlier versions of Drupal.

1 comment

## Absolute and relative references in Excel

When you create a formula in Excel that refers to other cells in the worksheet, Excel will store the information about those cells as relative references. Relative references and their counterpart, absolute references, are one of the things that make spreadsheets such a powerful tool.