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: Charts and Graphs
Saturday 12/5, 2:00pm - 3:30pm
This popular spreadsheet package provides significant data analysis and graphing capabilities. 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 Excel: Pivot Tables
Monday 12/14, 11:00am - 12:00pm
This popular spreadsheet package provides significant data analysis and graphing capabilities. We will explore Pivot Tables in Excel - a powerful way to analyze large datasets. We will use Adobe Connect Pro for the online session. This is our first online workshop. We recommend a headset with microphone for participation but you can also participate on any computer with speakers,

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

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.