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.

There are a variety of ways to add up the numbers found in two or more cells in Excel. This lesson shows you how to use the SUM function to add up cells, rows and columns of cells in Excel.

7 comments

This lesson shows you how to write formulas using INDEX and MATCH to let you perform lookups that VLOOKUP can't, and which run much faster on large lookup tables than VLOOKUP. This lesson explains how INDEX and MATCH work on their own, and then shows you how to write an INDEX MATCH formula that can look left as well as right, and performs much faster than VLOOKUP on large tables.

31 comments

If you want to learn Excel, this lesson covers ten important things that we think you need to know if you are going to use Excel effectively. Even if you've been using Excel for a while, check this lesson out to make sure you have the basics covered.

VLOOKUP allows you to look for a specified value in a column of data inside a table, and then fetch a value from another column in the same row. An example might be where you need to find the sales for a specific salesperson from within a monthly sales report. In this lesson you'll learn how to use VLOOKUP in your spreadsheets by walking you through several simple examples. The lesson will also highlight some shortcomings of VLOOKUP, plus a solution to those shortcomings.

24 comments

The COUNTIFS function in Excel counts the number of cells in a range that match a set of multiple criteria. COUNTIFS extends the COUNTIF function which only allows one criteria. It is similar to SUMIFS, which will find the sum of all cells that match a set of multiple criteria. This lesson shows you how to use COUNTIFS and provides some practical examples to help you understand how it works.

1 comment

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.

4 comments

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.

21 comments

When printing in Excel 2010 for Windows, 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.

12 comments

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.

10 comments

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.

3 comments

Pages