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.

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.

2 comments

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.

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.

Excel offers a number of ways to find rows that contain duplicate values. However, most of them focus on finding rows where the value in just one column is repeated. In this lesson, we look at how to use the COUNTIFS function to find rows where values in moree than one column is repeated. We then use the COUNTIFS function in combination with Excel's Conditional Formatting feature to highlight duplicate and even triplicate rows.

19 comments

Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.

You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.

19 comments

 When you create a large table in Microsoft Word that spans multiple pages, you'll find on the second and subsequent pages that the table headings don't repeat. In this lesson you'll learn how to configure one or more rows of your table to repeat at the top of the page for every page on which your table appears. This lesson applies to tables in Microsoft Word 2010 for Windows and Word 2011 for Mac (as well as Word 2007 for Windows). 

23 comments

Learn how to set up CiviCRM cron jobs in cPanel in Drupal.

1 comment

If you're using the Autofilter feature, you're probably wondering how to perform calculations on only those values that are being displayed by the filter. The SUBTOTAL() function is the answer.

3 comments

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

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.

4 comments

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.

13 comments

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.

2 comments

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.

12 comments

Pages