Welcome to Five Minute Lessons

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.

Learn More about Hide the page title in Drupal 8

How to use Autosum in Excel

This lesson explains how to use Autosum. Autosum is a powerful feature that can save you time if you need to add up cells or columns of data. It is often faster than creating a formula by hand, especially when you have a large amount of data to add up. In this lesson you’ll learn how to use Autosum, and some of its limitations.

Learn More about How to use Autosum in Excel

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.

Learn More about Show or hide a menu item in Drupal 7 based on a user’s location

Capture the submission page URL when a Drupal 7 webform is submitted

This lesson shows you a way to capture the submission page when someone submits a Drupal 7 webform on your website. This is useful if you have a webform in a block on multiple pages, and you want to know which page someone was on when they submitted the page.

Learn More about Capture the submission page URL when a Drupal 7 webform is submitted

How to use the XLOOKUP function

XLOOKUP is a new function for Excel that will replace VLOOKUP for most Excel users. In this lesson, we look at how XLOOKUP works and provide some practical examples of how to use it. In one function, XLOOKUP provides the same features that VLOOKUP and HLOOKUP offer separately, and is more powerful and easier to use. XLOOKUP also removes the need to use the INDEX/MATCH combination that allows you to work around some of VLOOKUP’s shortcomings.

Learn More about How to use the XLOOKUP function

Three Things You’re Probably Doing Wrong in Mailchimp

Mailchimp is a hugely popular email marketing platform, and for good reason. It’s easy to use, and is free if your list is under 2000 subscribers. Yet a lot of people aren’t using it effectively. Here are three things you might be doing wrong.

Learn More about Three Things You’re Probably Doing Wrong in Mailchimp

How to create and send an email campaign in Mailchimp

This lesson provides a detailed step-by-step guide to creating an email campaign in Mailchimp. It focuses on creating a Regular campaign and shows you the steps you need to take, and the best practices you should use, all the way through to actually sending your email campaign.

Learn More about How to create and send an email campaign in Mailchimp

How to merge two Audiences in Mailchimp

In this lesson, you’ll learn how to merge (or combine, as Mailchimp calls it) two audiences (lists) into one. We’ll cover two methods for doing this, and identify which method we recommend. We will also discuss what happens when you merge two audiences.

Learn More about How to merge two Audiences in Mailchimp

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.

Learn More about How to manage Product Tabs in WooCommerce

Add working days to a date in Excel with non-standard weekend days

The WORKDAY.INTL() function extends the WORKDAY() function so that you can specify which days are weekend days when adding days to dates. This lesson shows you how to use it.

Learn More about Add working days to a date in Excel with non-standard weekend days

Additional Info

Search Suggestions

      Join our mailing list

      Mailing List
      presentation-icon

      Sample Graphic for other Call To Action Purposes

      Sample Graphic for other Call To Action Purposes

      Scroll to Top