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.

 If you have an ecommerce website, you can enable ecommerce tracking in Google Analytics. This gives you detailed (but aggregate) information about sales you make through your online store. Once you have that, you can then track back and examine the analytics data for visits with sales vs visits without sales.

There are two steps to enabling ecommerce tracking in Google Analytics.

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.

1 comment

This lesson shows you a way to calculate the number of times a single character occurs in a cell in Excel, and provides a real-life example where I needed to split a column of cells containing part numbers into individual components for each part number.

3 comments

Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.

2 comments

If you are using Google Adwords to drive traffic to your site, you absolutely should link your Google Adwords account with your Google Analytics account. If you don't, you are missing out on a lot of important analytics data, as well the opportunity to truly measure the ROI on your Google Adwords campaigns.

5 comments

When printing in Excel, 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 in Microsoft Excel 2011 for Mac. You will also learn how to print header columns on the left of every page in your printout.

2 comments

This lesson shows you how to group data in your pivot table by date. You can group by day, week, month, quarter or year. If your date fields include a time value, you can also group by seconds, minutes or hours. You'll also learn how to collapse and expand data groups in your pivot table so you can quickly see a summary of your data.

6 comments

If you have a spreadsheet with time values that have been added to the spreadsheet as text values, you need the TIMEVALUE function. This will allow you to convert the text values into valid time values. A common scenario where this might be useful is when you've been provided data to import into Excel, and the times in the imported data are not recognised by Excel as valid times.

10 comments

There are many scenarios where you may need to use the current date and time in your spreadsheets. You may simply need to display the current date in a spreadsheet report. Or, you may need to perform a calculation that uses the current date or time. This lesson shows you how to enter a formula into a cell in Excel that outputs the current date and/or time, and updates automatically as time passes.

11 comments

When you're working in a web team, it can be useful for everyone in the team to have access to Google Analytics for the website(s) you're working on. This lesson shows you how to configure Google Analytics so that multiple users can access one or more profiles in your account, and shows you a quick way to allow a user to access multiple profiles in the same Google Analytics account.

1 comment

Pages