Learn how to set up CiviCRM cron jobs in cPanel in Drupal.
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.
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.
The Pivot Table Report Filter adds another dimension to your pivot tables - literally. Rather than all of your data being presented in a flat table, the Report Filter lets you create a pivot table report and then change the data being presented using one or more Report Filters.
This lesson will show you how to rename, reorder and hide the default Product tabs in WooCommerce. It also introduces some of the concepts involved in using the functions.php file in your WordPress theme to override WordPress and WooCommerce code.
Google Analytics allows you to email reports from your account. This enables you to share reports with people who don't have access to your Google Analytics account, including people who are only interested in specific reports from Google Analytics. You can control which format the reports are sent in, and the frequency with which they are emailed. This lesson shows you how to set up email reports from Google Analytics, as well as pointing out a couple of things you should be aware of when setting them up.
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.
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.
If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
If you are working with large tables of data in Excel, you can make your spreadsheet easier to read by formatting alternate rows to be shaded a different colour. There are a number of ways you can achieve this. This lesson shows you a quick and easy way to do it on Excel 2011 for Mac.
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.