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.
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.
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.
One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it's easy, and you don't need to wait as long as I did.
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.
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.
In this lesson, we look at a specific example where you have a table of sales data, and you need to find out the name of the person who had the highest sales for the month. It's one of those things that seems like it should be easy until you actually try to do it. The solutions we present here are not the only way of achieving this, but the do have the advantage of solving the problem with a single formula. The methods here could also be used for a variety of other applications as well.