Fiveminutelessons.com - Free Online courses

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.

Count empty cells in Excel

COUNTBLANK allows you to count the number of 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.

Use SUMIF with multiple criteria in Excel

The SUMIF function allows you to add up the values in a range of cells in Excel that meet a certain criteria. However, in some cases the SUMIF function isn't quite enough, and you need the SUMIFS function instead. This lesson explains how to use SUMIFS.

Using SUMIF to add up cells in Excel that meet certain criteria

The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That's where the SUMIF function comes in handy, along with the more capable SUMIFS function.

Find the minimum or maximum value in a range of cells in Excel

 Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells. They are simple functions that go by the names of MIN() and MAX(). This lesson shows you how to use them. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides. 

Using multiple IF statements in Excel

The IF() function in Excel allows you to evaluate a situation which has two possible outcomes (e.g. sales are greater than $1000) and calculate a different value for each outcome. However, sometimes you need to work with situations where there are more than two possible outcomes. That's where multiple, or nested, IF functions come in handy. In this tutorial we'll cover how to use nested IF functions to calculate sales commission for a team of sales people, given a range of different commission rates.

Using the IF statement in Excel

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.

How to use the VLOOKUP function in Excel

VLOOKUP is one of the most useful functions in Excel. In fact, the world can be separated into two groups of people - those who know how wonderful VLOOKUP is, and those who haven't discovered it yet. This VLOOKUP tutorial will help you join the ranks of the enlightened.

Working with data ranges in Excel

Excel is a powerful tool for manipulating large amounts of data. Make sure you know the rules Excel uses when setting up a data spreadsheet.

Calculate the sum of a column of numbers in Excel

On this lesson, we'll cover one of the most basic features of Excel - its ability to add up a column or row of numbers using the SUM() function.

About Us

Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. including Google Analytics, Microsoft Word and Microsoft Excel.

Everything here is free for you to use while on the site. If you like something, why not link to it or support our sponsors. You can even become a sponsor.

To find out more, why not get in touch?

Commercial Services

As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:

  • Private labelling
  • Courseware development
  • e-learning development
  • Corporate subscriptions
  • Learning consultancy services
  • Documentation and user guide development
  • Development of innovative corporate learning environments

Contact us now to find out more about our learning consultancy and courseware development services

Syndicate content