Excel Tricks


Production Template Overview

An overview of an MS-Excel template for importing, processing, and presenting data. The template was designed for timecourse data and trends. There are Macros scripted to automatically import the raw data. In addition, from the template, there's a Macro that opens up a database file and pastes in the summary data.

Graphing Utility Explained

Descibes an interactive way to organize and present data. There are 4 groups and each can have up to 8 conditions graphed. The axes variables can be picked using a pulldown menu; the titles of the Chart, and X and Y axis can als be named.

Macros Explained

More details and examples on how the Macros are used in the template. There a some macros that populate teh record sheet, and one that pulls data from external excel sheets. In addition, a description of how a macro is used to open and copy to an external database.