This lesson shows you a formula to convert a month name into its corresponding number (i.e. Jan = 1, Feb =2, etc).
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.
Autofilter is one of the most powerful features of Excel if you need to work with data in tabulated (table) format. It lets you treat a range of cells as a table and then filter out certain rows based on different criteria. It is very powerful if you need to "mine" data in a list and find out specific information about the data in that list. This tutorial covers how to set up a data table in Excel to use with Autofilter, and also shows you how to enable Autofilter and use it for basic filtering. This lesson is applicable for all versions of Excel (including Excel for Mac) although the visual presentation of the options may change from version to version.
This lesson shows you now to extract text from a cell in Excel. This is useful when you have a cell containing combining numbers and text, such as a part number, or several text values separated by commas. It introduces the RIGHT() and LEFT() functions, which are essential text manipulation functions in Excel.
Tables in Microsoft Word are great, but the default settings for tables are sometimes not what you want. In particular, Word will break rows with a lot of text across two pages if it needs to. If you'd rather have Word break tables up between pages so that each row is kept intact and not split across two pages, this lesson will show you how to do it. This lesson covers Microsoft Word 2007, 2010 and 2013 for Windows, and Microsoft Word 2011 for Mac.
Learn how to set up CiviCRM cron jobs in cPanel in Drupal.
If you're using the Autofilter feature, you're probably wondering how to perform calculations on only those values that are being displayed by the filter. The SUBTOTAL() function is the answer.
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().
When you create a large table in Microsoft Word that spans multiple pages, you'll find on the second and subsequent pages that the table headings don't repeat. In this lesson you'll learn how to configure one or more rows of your table to repeat at the top of the page for every page on which your table appears. This lesson applies to tables in Microsoft Word 2010 for Windows and Word 2011 for Mac (as well as Word 2007 for Windows).
This lesson explains how to show or hide branding elements on your Drupal 8 site, including your logo, the site name, and the site slogan. Drupal 8 handles this differently to earlier versions of Drupal.
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.