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 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.

## 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.

## 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.

## Use Conditional Formatting to shade alternate rows in Excel

If you are working with large tables of data in Excel, you can make your spreadsheet easier to read by formatting alternate rows to be shaded a different colour. There are a number of ways you can achieve this. This lesson shows you a quick and easy way to do it on Excel 2011 for Mac.

## 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.

## Manage user accounts at the command line in Linux

This lesson covers various aspects of managing users at the command line in Linux.

## Using logical operators and functions in Excel

This lesson explains how to use Excel's logical operators and logical functions (AND, OR, NOT). These boolean operators can be used in a number of ways, either on their own, or to complement other Excel functions. In many cases, you can even use one of these functions instead of a more complicated function. For example, it is often easy to rewrite an IF statement using either AND or OR. This lesson includes examples of how to do this.

## How to display one random item from a multiple-select relationship field in Pods

This lesson covers a specific scenario with the Pods framework in WordPress where you have two custom post types linked by a multiple-select Relationship field with multiple values. This example describes a Service post type and a Testimonial post type, where you can have multiple Testimonials linked to one Service, and you want to display just one of those testimonials at random each time the Service page is loaded.