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.

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. 

0
Your rating: None

Count the number of characters in a cell in Excel

This lesson introduces the LEN() function, which allows you to calculate the number of characters in a cell. This formula is useful on its own, or can be combined with other text functions such as RIGHT(), LEFT(), MID() and FIND().

0
Your rating: None

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.

0
Your rating: None

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.

0
Your rating: None

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.

0
Your rating: None

Absolute and relative references in Excel

When you create a formula in Excel that refers to other cells in the worksheet, Excel will store the information about those cells as relative references. Relative references and their counterpart, absolute references, are one of the things that make spreadsheets such a powerful tool.

5
Your rating: None (1 vote)

Adding up numbers in Microsoft Word

If you're using Word to present a table of data that includes numbers, you can use Word's built in formulas to add up those numbers rather than manually calculate them each time they change. This can also eliminate the possibility of error - particularly important if you're producing a sales proposal or an important report.

3
Your rating: None (2 votes)

Reducing the Bounce Rate on your website

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.

5
Your rating: None (1 vote)

What is the Bounce Rate in Google Analytics?

Bounce Rate refers to the number of visitors who come to your site and then leave again without visiting any other pages on your website.

0
Your rating: None

Calculate a value in Excel that combines text and numbers

If you want to combine text with the results of a formula in a cell, you can use concatenation.

5
Your rating: None (1 vote)

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