Intermediate

This page introduces some more advanced Excel topics that will help you push your Excel skills even further. All the lessons are about five minutes long (or less) so it won't take long to learn more, and do more.

XLOOKUP is a new function for Excel that will replace VLOOKUP for most Excel users. In this lesson, we look at how XLOOKUP works and provide some practical examples of how to use it. In one function, XLOOKUP provides the same features that VLOOKUP and HLOOKUP offer separately, and is more powerful and easier to use. XLOOKUP also removes the need to use the INDEX/MATCH combination that allows you to work around some of VLOOKUP's shortcomings.

How to create a Pivot Table in Excel

Microsoft Excel

Intermediate

Pivot Tables

Excel's Pivot Table feature is an incredibly powerful tool that makes it easy to tabulate and summarise data in your spreadsheets, particularly if your data changes a lot. This lesson will show you how to create a simple pivot table in Excel to summarize a set of daily sales data for a team of several sales people.

Capture the submission page URL when a Drupal 7 webform is submitted

Drupal Sitebuilding

Intermediate

Webform

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.

Add working days to a date in Excel with non-standard weekend days

Microsoft Excel

Intermediate

Excel Formulas and Functions

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.

Convert a Month name into a number

Microsoft Excel

Intermediate

This lesson shows you a formula to convert a month name into its corresponding number (i.e. Jan = 1, Feb =2, etc).

Use SUMIFS to calculate a running total between two dates

Microsoft Excel

Intermediate

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.

How to reduce the budget on a boosted post in Facebook

Facebook Marketing

Intermediate

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 COUNTIFS to count cells that match multiple criteria

Microsoft Excel

Intermediate

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 check if a cell contains a valid number

Microsoft Excel

Intermediate

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.

Add working days to a date in Excel

Microsoft Excel

Intermediate

Excel Formulas and Functions

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.

You are here