Techshop Workshops

Introductory Excel

Skills covered include:

Overview of the Ribbon (Excel’s Menu)
Basic Functions (Average, Count, Product, STDEV, etc.)
Formatting (Charting, Printing, Autofill, Reference Cells, Format Painter)

Intermediate Excel

Skills covered include:

Formulas (If, And, Or, etc.)
Lookups
Solver
Net Present Value
Basic tables and graphs

Advanced Excel

Topics covered include:

Monte Carlo simulation
VLookup
Regression analysis
MACROS
Pivot tables

Introduction to Qualtrics

Skills covered include:

What is Qualtrics and what can it do?
Creating and Editing a Survey
Writing Good Survey Questions
Collaborating with Others
Distributing a Survey
Viewing and Exporting Survey Results

Introduction to R

Skills covered include:

Importing data
Creating and transforming variables
Creating graphs
Regression analysis

About Tech Shop Workshops

Questrom ITS’ Tech Shop Workshops are run by an intrepid group of student trainers! Workshops are free and open to the BU community. We welcome your feedback on our workshops, and any suggestions you might have for other workshops we could offer. Contact Janai Mungalsingh or Carla Villeneuva with comments, questions, and suggestions.

Introductory Excel

Intermediate Excel

Advanced Excel

Introduction to Qualtrics

Introduction to R

About Tech Shop Workshops

Questrom Helpdesk