Pivot Tables in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning.

The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!) errors and is often combined with an IF statement to provide an alternate action if an error is generated.

Learn to create labels you can use for mailings and export from Excel to Word.

The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph.

A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, "Where did all my numbers go?" or same question, "Where did all of those ####### come from and why are they in my spreadsheet?" The problem is the number trying to be displayed in a particular cell does not have enough width to display properly. To clear up the problem we just need to make the column wider.