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]
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.
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.