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 @ WIC. Click the workshop name to register.

Microsoft Excel: Basics
Wednesday 3/17, 5:00pm - 6:00pm
Please check the individual session descriptions for more details. Learn how to create spreadsheets, enter and format data, use mathematical calculations, and more. This is a basic course, addressed to users with no previous experience with the software.
Microsoft Excel: Basics
Monday 3/22, 12:00pm - 1:30pm
Please check the individual session descriptions for more details. This class will cover the basics of Excel and is therefore best suited for users with no previous experience with Excel.
Microsoft Excel: Charts and Graphs
Saturday 3/27, 2:00pm - 3:30pm
Please check the individual session descriptions for more details. We will focus on Excel features for graphs and charts. We will discuss multiple axes, formatting data, choosing chart type, adding notes and images, and customizing your charts. We will discuss how to export charts to other formats including Word, PowerPoint and PDF. This is a hands-on workshop.

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