Salesforce

Outlook Tips and Tricks

LinkedIn

Spring 2016 Questrom Staff Workshops

Google Apps

WordPress

Questrom ITS’ Staff WordPress Workshop covers all your WordPress basics – from creating a page to adding media – and also touches on some of the specifics of the theme used here at Questrom. Fire up your own WordPress site and follow along!

Download the workshop handout here. Questions? Feel free to contact Becky.


This workshop was originally offered in March, 2015. Interested in attending a future offering of this workshop? Click here to let us know!

Advanced PowerPoint 2013

Our Advanced PowerPoint workshop is meant for those who have some PowerPoint experience but are looking to incorporate some more advanced elements into their slide decks. Topics covered include:

  • Formatting
    • Customizing Themes
    • Adding a Footer or Timestamp
    • Using the Questrom Theme
  • Inserting Content
    • Inserting Charts
    • Hyperlinking
    • Embedding Video and Audio
    • Using SmartArt
  • Transitions and Animations
  • Presenting and Sharing your Work
    • Recording Narration
    • Keyboard Shortcuts
For more on Recording Narration in PowerPoint, click here to download the workshop handout and work through it on your own. Additional resources can be found here. Feel free to contact Becky with any questions.

This workshop was originally offered in February 2015. Interested in attending a future offering of this workshop? Click here to let us know!

Intermediate Excel 2013

 

Our Intermediate Excel workshop is great for those familiar to Excel and who are looking to boost their skills. The workshop covers the following topics:

  • V-Lookups
  • Formatting
    • Combining and Separating Data
    • Conditional Formatting
    • Locked and Hidden Cell Formatting
    • Highlighting Formulas and Cell Values
  • Pivot Tables
  • Chart Building
    • Types of Charts
    • Creating a Chart
    • Editing a Chart
    • Inserting Charts into PowerPoint
Download materials for this workshop here: Workshop handout (including exercises) and Excel worksheet for completing exercises. Additional resources can be found here. Feel free to contact Becky with any questions.

This workshop was last offered in August 2015. Interested in attending a future offering of this workshop? Click here to let us know!

Introductory Excel 2013

Our Introductory Excel workshop is great for those brand new to Excel, or who haven’t used Excel in a while. The workshop covers the following topics:

  • General Tips for Using Excel
    • Customizing Excel
    • Printing your Worksheet
    • Getting Help
  • Commonly Used Excel Features
    • Using Functions and Formulas (including sum, concatenate, count, average, and if)
    • Absolute and Relative Cell References
    • Formatting as a Table
    • Freezing Rows and Columns
    • Keyboard Shortcuts
Download materials for this workshop here: Workshop handout (including exercises) and Excel worksheet for completing exercises. Additional resources can be found here. Feel free to contact Becky with any questions.

This workshop was originally offered in Fall 2014. Interested in attending a future offering of this workshop? Click here to let us know!