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.
If you want to learn Microsoft Excel, you're in the right place. There is a lot to learn about Microsoft Excel, and not everything is in the manual. We've got a range of free online lessons on how to get the best out of Excel, starting from the basics right up to advanced subjects. We'll help you to do your job better - with the right Excel skills you could even get a raise or a better job! If you don't see what you want to learn, why not get in touch and suggest a lesson we should write.
This lesson explains how to use Excel's logical operators and logical functions (AND, OR, NOT). These boolean operators can be used in a number of ways, either on their own, or to complement other Excel functions. In many cases, you can even use one of these functions instead of a more complicated function. For example, it is often easy to rewrite an IF statement using either AND or OR. This lesson includes examples of how to do this.
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.
Do you need help with an Excel formula or function? We have lessons on a range of different Excel functions, and the list is growing all the time.