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.
How to display one random item from a multiple-select relationship field in Pods
This lesson covers a specific scenario with the Pods framework in WordPress where you have two custom post types linked by a multiple-select Relationship field with multiple values. This example describes a Service post type and a Testimonial post type, where you can have multiple Testimonials linked to one Service, and you want to display just one of those testimonials at random each time the Service page is loaded.
How to bulk clean spam posts and comments from your WordPress website
This lesson will show you how to find, flag and remove spam content from your WordPress website. It uses a database search to identify content that contains spam words, and flags them for removal so you can remove them safely via the WordPress admin dashboard.
Add working days to a date in Excel
If you’re using Excel to calculate dates, it is useful to know how to add (or subtract) a certain number of working or business days to a date. This lesson introduces the WORKDAY() function and shows you how to use it.
How to check if a cell contains a valid number
When writing a formula that references other cells, it can sometimes be useful to check that those cells contain a valid value. In this lesson, we’ll look at Excel’s ISNUMBER function as a way of doing this.
Use COUNTIFS to count cells that match multiple criteria
The COUNTIFS function in Excel counts the number of cells in a range that match a set of multiple criteria. COUNTIFS extends the COUNTIF function which only allows one criteria. It is similar to SUMIFS, which will find the sum of all cells that match a set of multiple criteria. This lesson shows you how to use COUNTIFS and provides some practical examples to help you understand how it works.
How to reduce the budget on a boosted post in Facebook
If you boost a post in Facebook, it’s easy to add extra budget to the boosted post, but there is no obvious way to reduce the budget on that post. This lesson provides a quick and simple solution.
Use SUMIFS to calculate a running total between two dates
This lesson shows you how to calculate a running total between two dates in a column of data. An example might be calculating the total sales for the last 30 days up to today. Each row in the spreadsheet will calculate a new total based on the date in that row, counting back a specified number of days.
Convert a Month name into a number
This lesson shows you a formula to convert a month name into its corresponding number (i.e. Jan = 1, Feb =2, etc).
Set up CiviCRM cron for a Drupal site on cPanel
Learn how to set up CiviCRM cron jobs in cPanel in Drupal.
Show or hide the Site Name and Site Slogan in Drupal 8
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.
Additional Info
Join our mailing list
