When you are working with a large spreadsheet in Microsoft Excel, it's easy to find yourself scrolling down or across and losing track of where you are. This lesson explains how to freeze rows and columns (officially known as "Freeze Panes") in Excel 2010 for Windows and Excel 2011 for Mac.
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.
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.
1 comment
A high bounce rate on a website indicates that your visitors are not engaging once they arrive on your website. That means your website isn't as effective as it could be. Find out here how to reduce your bounce rate.
1 comment
This lesson shows you how to create a Table of Contents (TOC) in Microsoft Word. It takes you through the two-step process of creating a table of contents in your document, and also shows you how to automatically update the TOC to reflect the content in your document as it changes.
When creating a chart in Excel, Excel will default to inserting your new chart on the same worksheet that contains the data you created it from. This lesson shows you various options for moving or resizing your chart so it looks how you want it to, where you want it to be.
If you're getting started with Excel, creating formulas is one of the first things you should learn. In this lesson you'll learn how to create simple formulas and calculations in Excel.
13 comments
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.
1 comment
If you have a column of numbers and you want to calculate a running total of the numbers alongside, you can use the SUM() formula combined with a clever use of absolute and relative references.
31 comments
If you have an ecommerce website, you can enable ecommerce tracking in Google Analytics. This gives you detailed (but aggregate) information about sales you make through your online store. Once you have that, you can then track back and examine the analytics data for visits with sales vs visits without sales.
There are two steps to enabling ecommerce tracking in Google Analytics.
This lesson shows you a way to calculate the number of times a single character occurs in a cell in Excel, and provides a real-life example where I needed to split a column of cells containing part numbers into individual components for each part number.
3 comments
Pages |
