This workshop expands on the material in Excel 1 and introduces a wider array of built-in functions to make working with data easier.

Topics include:

• Logical functions including COUNT and COUNTIF
• Lookup, array, and summary functions
• Text formatting
• Linking data between workbooks and worksheets
• Formulas tab
• Keyboard shortcuts

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:

Anyone looking to expand their proficiency with functions in Excel

Prerequisites:

Some previous experience with Excel is important for understanding how functions work

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.