Loading Events

« All STS Events

  • This event has passed.

STS: Excel 2: Functions

Monday, June 15, 2020 @ 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:
Monday, June 15, 2020
Time:
6:00 pm - 8:00 pm
Cost:
Free
Event Category:
Event Tags:
, , , ,

Other

Audience
Students
Primary Trainer
Aarish Mirza
Assistant
Suramay Pidara

Who's Attending

18 people are attending STS: Excel 2: Functions

  • Kristen Huset
  • William George Dunk
  • Jill Hoiting
  • Bailey Albrecht
  • Lindsay Pettit
  • Anna Christina Steffensen
  • Erik Gartland
  • Danny Parker
  • Jonathan McLean
  • Olya
  • Ayal Weiner-Kaplow
  • Daniel Manuel Narcho
  • Edward Zhao
  • Benjamin Abraham Vargas
  • Brenda Owen
  • Junqiao Zhu
  • Matthew L Mulhern
  • Fiona Lee

Register

Tickets are not available as this event has passed.