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.
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.
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.
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.
A high bounce rate on a website indicates that your visitors are not engaging once they arrive on your website. That means your website isn't as effective as it could be. Find out here how to reduce your bounce rate.
The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the value of sales of a specific product by a given sales person (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.
This lesson shows you how to create a Table of Contents (TOC) in Microsoft Word. It takes you through the two-step process of creating a table of contents in your document, and also shows you how to automatically update the TOC to reflect the content in your document as it changes.
It can sometimes be useful to know the address of a cell in a worksheet, so you can use that address in a formula. In this lesson, we'll look at how to use the ADDRESS function to find out the address of a cell. We'll then use the ADDRESS function in an example to demonstrate how useful it can be.
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here's a quick technique for selecting a range of cells in Excel.
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.