> Excel Tools

Using the Clipboard Viewer in Excel 2007
This article shows you how to use the clipboard in Excel to simplify re-entering frequently used data.

How To Use the Excel Freeze Pane Feature
When working with large spreadsheets, the headings at the top of the page and down the side of the sheet disappear when you scroll too far to the right. To avoid this problem, use Excel's freeze panes feature. This tutorial shows you how to "freeze" those sections of the screen containing titles so that they remain visible at all times.

How to Use the Excel Flowchart Template
Create colorful and informative flowcharts in Excel using this free template from Microsoft. The template works in all versions from Excel 97 on. Read the article to find out how easy it is to download and use this flowchart template.

Excel Timeline Template
Among the templates offered for free by Microsoft is one for creating a timeline in Excel. This template works in all versions from Excel 97 on. This article walks through how to download and use the timeline template in Excel.

Customizing Excel Auto Fill
Auto Fill is a very handy feature in Excel. It allows you to quickly add commonly used data to your spreadsheets. This article will show you how easily you can customize the lists of data that can be added.

How to Change the Sheet Tab Color of Excel Spreadsheets
In Microsoft Excel 2003 it is possible to color code the tabs of individual worksheets. Color coding the tabs of worksheets that contain related data often makes it easier to find specific information in large spreadsheet files. This article shows you how easy it is to quickly change worksheet tab colors.

Goal seeking AV Tutorial
Goal Seeking is a useful Excel command for asking "what if" type questions by varying the data in a formula to achieve different results. This site has a very clear and straightforward Audio Visual tutorial that takes you through a step by step example of using Goal Seeking.

Excel Tools, Tutorials, and Templates Page
Looking for Excel templates? add-ins? tutorials? or other tools? Then this site is a good place to start. It contains hundreds of links on a range of Excel-related topics. The topics are organized by subjects with Genetics, Earth Science, and Statistics being just a few of the ones listed. You must register (free) with the site before accessing the links.