Excel 2: Analysis introduces more advanced analysis tools that can be used to summarize data, perform complex calculations, and maximize the computing power of Microsoft Excel.

Topics covered:

1. Input Tables
2. Subtotal
3. Goal Seek
4. Solver
5. Analysis ToolPak

Workshop Manual and Class Files:

Training Manual

Class Files

Note: these files are available through the STS Canvas course. If you are not enrolled, click here to enroll

Audience:

Students looking to improve their Excel skills beyond the basics.

Prerequisites:

Students should already know how to enter and edit data, create functions, and apply calculations in Excel

Note: Software Training for Students services are only available to currently registered undergraduate or graduate students of UW-Madison. Faculty, staff and former students are not eligible to attend our training workshops or consultations.