If you have formatted a cell and want to use the same formatting for another cell or cells, you can easily copy the formatting from that cell to as many additional cells as you like.
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.
Content Marketing is one of the best long-term strategies for sustainably increasing your website traffic. As Google gets better at separating good quality content from bad , and penalising sites that don't follow its quality guidelines (Google Panda and Penguin), it has become ever more important to ensure that the content on your website is of good quality. This lesson will show you how to use Google Analytics to analyse which pages people are landing on, which keywords they used in the search that brought them to your website, and how to generate actionable insights that can help you improve your content and increase your traffic.
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.
The WORKDAY.INTL() function extends the WORKDAY() function so that you can specify which days are weekend days when adding days to dates. This lesson shows you how to use it.
If you need a free option to create a PDF of a Microsoft Office document, your options will depend on which version of Microsoft Office you are using.
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.
The MATCH() function allows you to find the position of a value in a list. For example, in a list of weekdays starting with Monday, MATCH() would return a value of 3 for Wednesday. This lesson explains how to use the MATCH() function in Microsoft Excel, explains where you might use it, and provides a real world example of the MATCH() function in action.
This lesson explains how to use Autosum. Autosum is a powerful feature that can save you time if you need to add up cells or columns of data. It is often faster than creating a formula by hand, especially when you have a large amount of data to add up. In this lesson you'll learn how to use Autosum, and some of its limitations.
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.
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.