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.

## Moving and resizing charts in Excel 2010

When creating a chart in Excel, Excel will default to inserting your new chart on the same worksheet that contains the data you created it from. This lesson shows you various options for moving or resizing your chart so it looks how you want it to, where you want it to be.

## How to reduce the budget on a boosted post in Facebook

If you boost a post in Facebook, it's easy to add extra budget to the boosted post, but there is no obvious way to reduce the budget on that post. This lesson provides a quick and simple solution.

1 comment

## Calculate a running total of a column of cells in Excel

If you have a column of numbers and you want to calculate a running total of the numbers alongside, you can use the SUM() formula combined with a clever use of absolute and relative references.

## How to enter basic formulas and calculations in Excel

If you're getting started with Excel, creating formulas is one of the first things you should learn. In this lesson you'll learn how to create simple formulas and calculations in Excel.

## Configuring Ecommerce tracking in Google Analytics

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.

## Count the occurrences of a single character in a cell in Excel

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.

## How to use the IF function in Excel to calculate values based on different criteria

The IF statement is a simple function in Excel that is one of the building blocks you need when you are working with large spreadsheets. You may not know you need it yet, but once you know how to use it, you won't want to live without it.

## Use SUMIFS to calculate a running total between two dates

This lesson shows you how to calculate a running total between two dates in a column of data. An example might be calculating the total sales for the last 30 days up to today. Each row in the spreadsheet will calculate a new total based on the date in that row, counting back a specified number of days.

## Use concatenation to combine text and numbers in Excel formulas

If you want to combine text with the results of a formula in a cell, you can use concatenation. Suppose you have calculated the total of a range of cells using a formula in cell D2. Now, you want to have cell A2 display the text "Today's sales are \$12,000", where \$12,000 is the value calculated in D2. As the value in D2 changes, you want the value in A2 to update automatically.

1 comment

## 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.