"6 Great Excel Tricks for You to Discover Some Excel 2003 Functionality."
Here are the 6 Amazing Excel Tricks that you shouldn't miss:
1.) Hiding Duplicate Records As Easy As 1-2-3!
One of the most common mistakes users make in preparing a report or sorting data is including duplicate entries. A built-in filter in Excel will take care of this problem. Follow these steps:
Excel will now hide any duplicate records in the selected range.
Custom Views is a tool in Excel that lets you assign a name to a particular sheet layout so you can recall it for later viewing. Making good use of custom views can save a great deal of time. For example, you can eliminate repetitive hiding, resizing, filtering, and other changes for producing various printed reports. Each set of options can be saved as a view. Then, all you need to do is apply the view before you print.
To access the feature:
When adding a view, you have the option of including print settings, hidden rows and columns, and filter settings. The new view even remembers where the active cell was when the view was saved, so when you open that view, it will "jump" to the spot in your sheet that corresponds to that view.
Excel has a 30-argument limit for statistical functions. It's easy to get around, though, if you group some of your arguments within parentheses.
Instead of entering AVG(A1,A2,A3 ,A33), you can enter AVG((A1,A2,A3)A4 ,A33), and Excel will accept the grouped arguments as a single argument within the formula.
Conditional formatting refers to the ability to format a cell based on the contents of the cells. Conditional formatting makes it easy to highlight certain values so that they stand out visually. For example, you may set up conditional formatting so that if a formula returns a negative value, the cell background displays yellow, etc.
The best part is that conditional formatting is easy to set up. Just click the cells you'd like to format and select Format | Conditional Formatting. The Conditional Formatting dialog box lets you set up the conditions by which the formatting of the cell will occur. You pick the operator (between, equal to, less than, etc.) and the value or range of values. Click Format to open the Format Cells dialog box, where you can select the colors and styles to be used.
Each cell can have several conditional formats. For example, you might say that if a certain cell's value is between 10 and 30, the text should be bolded red on a yellow background.
A workbook can be shared so that different peoples can access the same file at the same time. But it's a fact that shared workbooks generate more errors than workbooks with only one owner. Here's one way to flag errors as they occur:
Now, when someone enters an error, it will be flagged with your selected color.
Working in a complex worksheet, you may have encountered that annoying "#DIV/0!" error when the divisor of your formula is a zero. Using the IF function, you can create your own message for display when you divide by zero.
The IF function will be like this:
=IF (DIVISOR = 0,"Your Desired Text", DIVIDED/DIVISOR)
The IF function evaluates the first parameter (DIVISOR = 0). If it's TRUE, it displays the second parameter ("Your Desired Text") in the cell. If it's FALSE, the function displays the third parameter (DIVIDED/DIVISOR) in the cell.
Recommended Books:Click on the image to view the details of the book.
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |