If you want to learn Excel, this lesson covers ten important things that we think you need to know if you are going to use Excel effectively. Even if you've been using Excel for a while, check this lesson out to make sure you have the basics covered.
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.
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.
1 comment
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.
1 comment
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.
79 comments
Content Marketing is one of the best long-term strategies for sustainably increasing your website traffic. As Google gets better at separating good quality content from bad , and penalising sites that don't follow its quality guidelines (Google Panda and Penguin), it has become ever more important to ensure that the content on your website is of good quality. This lesson will show you how to use Google Analytics to analyse which pages people are landing on, which keywords they used in the search that brought them to your website, and how to generate actionable insights that can help you improve your content and increase your traffic.
Learn how to control the display of the page title on different pages of your Drupal 8 website.
If you have formatted a cell and want to use the same formatting for another cell or cells, you can easily copy the formatting from that cell to as many additional cells as you like.
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.
2 comments
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.
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.
12 comments
Pages |