STS: Excel 2: Functions
March 27 @ 6:00 pm - 8:00 pm
This workshop expands on the material in Excel 1 and introduces a wider array of built-in functions to make working with data easier.
- 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:
Note: these files are available through the STS Canvas course. If you are not enrolled, click here to enroll
Anyone looking to expand their proficiency with functions in Excel
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.