Loading Events

« All STS Events

  • This event has passed.

STS: Excel 2: Functions

Wednesday, February 5, 2020 @ 6:00 pm - 8:00 pm

Register

Attending STS Sessions Online

All Software Training for Students workshops sessions are currently being delivered remotely via Zoom. Our room can be accessed from the following link:

https://go.wisc.edu/stszoom

To attend the workshops, we recommend the following:

  1. Enroll in the STS Canvas Course (if you are not already enrolled)
  2. After enrolling, click the following link to join our Zoom room
  3. Recommended: Download the Class Files before attending your scheduled workshop.

IMPORTANT: The entire Microsoft Office Suite is free for all UW-Madison students to download on up to 5 devices. To do so, go to this website, sign in with your school email, and from the “Install Office” menu from the right side, click on “Office 365 Apps” to prompt the download. We recommend you download the software a day before your scheduled workshop.

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.

Details

Date:
Wednesday, February 5, 2020
Time:
6:00 pm - 8:00 pm
Cost:
Free
Event Category:
Event Tags:
, , , ,

Venue

Room B1144A, DeLuca Biochemistry Building
420 Henry Mall
Madison, WI United States

Other

Audience
Students
Primary Trainer
Joe Kirschnik
Assistant
David Berman
Tickets are not available as this event has passed.