Loading Events

« All STS Events

  • This event has passed.

STS: Excel 2: Functions

Friday, October 29, 2021 @ 6:00 pm - 8:00 pm

Register

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:
Friday, October 29, 2021
Time:
6:00 pm - 8:00 pm
Cost:
Free
Event Category:
Event Tags:
, , , ,

Venue

Room 2257, College Library (Helen C. White Hall)
600 N Park St.
Madison, WI United States

Other

Audience
Students
Primary Trainer
Vinayak Malik

Who's Attending

13 people are attending STS: Excel 2: Functions

  • Annika Baur
  • Anna Laugen
  • Indrani Dey
  • Emily O'Neil
  • Weizheng Wang
  • Haoran Liu
  • Peihan Shu
  • Nicole Salata
  • Kayla Thrane
  • Zhuoer Wang
  • Laura Stoesz
  • Vincent Hsieh
  • Meg Taylor

Register

Tickets are not available as this event has passed.