Loading Events

« All STS Events

  • This event has passed.

STS: Excel 2: Analysis

Tuesday, October 20, 2020 @ 6:00 pm - 8:00 pm

Register

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.

Excel 2: Analysis introduces more advanced analysis tools that can be used to summarize data, perform complex calculations, and maximize the computing power of Microsoft Excel.

Topics covered:

  1. Input Tables
  2. Subtotal
  3. Goal Seek
  4. Solver
  5. Analysis ToolPak


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:

Students looking to improve their Excel skills beyond the basics.


Prerequisites:

Students should already know how to enter and edit data, create functions, and apply calculations in Excel


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:
Tuesday, October 20, 2020
Time:
6:00 pm - 8:00 pm
Cost:
Free
Event Category:
Event Tags:
, , ,

Venue

online

Other

Audience
Students
Primary Trainer
Aarish Mirza
Assistant
Karthik Thatipalli
Tickets are not available as this event has passed.