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.
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.
Sometimes you need to count the number of cells in a spreadsheet that contain a value or set of values. The COUNTIF function allows you to do this by counting only those cells in the range that meet the criteria you set. This lesson explains how to use COUNTIF, and provides an example of how you can use it.
Excel offers a number of ways to find rows that contain duplicate values. However, most of them focus on finding rows where the value in just one column is repeated. In this lesson, we look at how to use the COUNTIFS function to find rows where values in moree than one column is repeated. We then use the COUNTIFS function in combination with Excel's Conditional Formatting feature to highlight duplicate and even triplicate rows.
This lesson provides a way in Drupal 7 to hide or show an individual menu item based on the location of each visitor. The use case for this example was to show a Shop menu item to visitors in New Zealand and Australia, and hide it for visitors from all other countries.
Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you've entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.
Word 2010 offers Table Styles to allow you to apply a style to a table in your document.
One of the challenges that can stump you the first time around is setting the color styles for odd/even banding of tables or columns. This lesson describes how to set these on an existing or custom table style.
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.
Creating a Table of Contents, or TOC, for a document in Microsoft Word 2011 for Mac is not difficult, but it can be tricky to make it look just like you want it. This lesson takes you through the process of creating a dynamic table of contents that can be easily updated to reflect the content in your document.
This lesson shows you how to use Excel to calculate the number of days between two dates. It also shows you how to exclude weekends and holidays from the total.
This lesson shows you a way to capture the submission page when someone submits a Drupal 7 webform on your website. This is useful if you have a webform in a block on multiple pages, and you want to know which page someone was on when they submitted the page.