Excel Training

The Weigle Information Commons offers several excellent workshops on Microsoft Excel, ranging from introductory to more specialized levels of instruction. Below are the currently scheduled workshops @ the WIC and the Biomedical Library. Click the workshop name to register.

[an error occurred while processing this directive]

Lynda.com
The WIC and Biomedical Library also have on-site access to Lynda.com, a software training and tutorial video library. When in one of those locations, you can view excellent video tutorials for a range of software products, including Excel.

Lynda.com video tutorials for Excel


Microsoft's Excel Courses
Microsoft also offers online tutorials on its website. These cover a number of subjects, including how to import data, create PivotTables and charts, and write formulas.

Microsoft Excel 2007 courses
Microsoft Excel 2003 courses


Quick Excel Tips

Creating a Simple Pivot Table ~Debra Dalgleish
This resource provides simple instructions on how to create a basic Pivot Table in Excel. There is also a short, 3-minute video.

Importing a text file into Excel ~Joseph Rubin
Simple 3-step instructions for importing a text file into Excel. Note: When importing pipe-delimited reports, be sure to choose the pipe character | (shift + backslash) as the delimiter.

Excel Function Dictionary ~Peter Noneley
This page lists the purpose of over 150 Excel functions. The .zip file available for download contains a spreadsheet that also offers tips on and examples of Excel functions.