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
There are a variety of ways to add up the numbers found in two or more cells in Excel. This lesson shows you how to use the SUM function to add up cells, rows and columns of cells in Excel.
9 comments
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.
2 comments
Bounce Rate refers to the number of visitors who come to your site and then leave again without visiting any other pages on your website.
Creating a Table of Contents, or TOC, for a document in Microsoft Word 2011 for Mac is not difficult, but it can be tricky to make it look just like you want it. This lesson takes you through the process of creating a dynamic table of contents that can be easily updated to reflect the content in your document.
Excel is a powerful tool for manipulating large amounts of data. Make sure you know the rules Excel uses when setting up a data spreadsheet.
Creating charts in Excel can be a frustrating process. This lesson starts with the basics, and shows you the simple steps you need to follow to create a basic column or bar chart in Excel.
1 comment
Pages |