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.
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.
Mailchimp is a hugely popular email marketing platform, and for good reason. It's easy to use, and is free if your list is under 2000 subscribers. Yet a lot of people aren't using it effectively. Here are three things you might be doing wrong.
This lesson provides a detailed step-by-step guide to creating an email campaign in Mailchimp. It focuses on creating a Regular campaign and shows you the steps you need to take, and the best practices you should use, all the way through to actually sending your email campaign.
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.
When printing in Excel 2010 for Windows, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page.
In this lesson, we look at a specific example where you have a table of sales data, and you need to find out the name of the person who had the highest sales for the month. It's one of those things that seems like it should be easy until you actually try to do it. The solutions we present here are not the only way of achieving this, but the do have the advantage of solving the problem with a single formula. The methods here could also be used for a variety of other applications as well.
One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it's easy, and you don't need to wait as long as I did.
COUNTBLANK allows you to count the number of empty or blank cells in a range in Excel. This lesson shows you how to use COUNTBLANK, and also shares a couple of things to watch out for when you use COUNTBLANK in an Excel formula.
The MATCH() function allows you to find the position of a value in a list. For example, in a list of weekdays starting with Monday, MATCH() would return a value of 3 for Wednesday. This lesson explains how to use the MATCH() function in Microsoft Excel, explains where you might use it, and provides a real world example of the MATCH() function in action.
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.
If you need a free option to create a PDF of a Microsoft Office document, your options will depend on which version of Microsoft Office you are using.
In this lesson, we cover how to print an Excel spreadsheet with page numbers on each page. Excel has changed a lot over the years, but one thing that hasn't changed is the way that you insert page numbers into a spreadsheet. Unfortunately, Excel 2010 does not make it easy to find the options for doing this. This lesson covers the basics of inserting page numbers as well as providing an overview of some more advanced options.
If you have a spreadsheet with time values that have been added to the spreadsheet as text values, you need the TIMEVALUE function. This will allow you to convert the text values into valid time values. A common scenario where this might be useful is when you've been provided data to import into Excel, and the times in the imported data are not recognised by Excel as valid times.