Registration for Lunch and Learn Session - Advanced Excel

The following material will be covered in this Session:

  • Logical (If-Then-Else) and Error functions
  • Time and Date functions
  • Lookup functions
  • Text functions
  • use functions to perform more complex calculations in Excel
  • differences between using interactive Excel (clicking one’s way through the ribbon to perform tasks) and programmatic Excel (using functions to automate repetitive tasks)
  • using text functions to prepare data that has been imported into Excel or entered in a format that is not immediately usable.

Registration for Lunch and Learn Session - Excel Data Analysis

The following material will be covered in this Session:

  • use of tables
  • filtering, sorting, subtotals
  • Pivot Tables to analyze data

Date: TUesday july 21, 2015
Time: 12:00 pm - 1:30 pm
Location: frost library barker room a level

lunch will be provided.

This session has a firm limit of 12 people. You must register to attend and please cancel in advance if you can't make it so another person can take the spot.

This session is full, no more registrations are possible.

Registration for Lunch and Learn Session - Outlook Email and Calendar Tips & Tricks

The following material will be covered in this Session:

  • Learn about the Outlook interface
  • Methods for handling email including sorting, searching, folders, quick steps, and rules spreadsheets into worksheets
  • Working with calendars including rescheduling and recurring appointments
  • Sharing calendars and using snapshots to share calendar data

Date: Thursday july 16, 2015
Time: 12:00 pm - 1:30 pm
Location: frost library barker room a level

lunch will be provided.

Registration for Lunch and Learn Session - Excel Tips & Tricks

The following material will be covered in this Session:

  • Useful shortcuts
  • Group spreadsheets into worksheets
  • 3D formulas
  • Conditional formatting
  • What's new in Office 2013

Date: Wednesday july 8, 2015
Time: 12:00 pm - 1:30 pm
Location: frost library barker room a level

lunch will be provided.

Please fill in the following and submit if you wish to attend this class:

Registration for Lunch and Learn Session - Google Calendar

The following material will be covered in this Session:

  • Create events
  • Set appointment slots
  • Schedule a meeting
  • Collaborating with others using shared calendars and delegating
  • Syncing a calendar

Date: TUesday june 23, 2015
Time: 12:00 pm - 1:30 pm
Location: frost library barker room a level

lunch will be provided.

Please fill in the following and submit if you wish to attend this class:

Validation
Enter the characters shown in the image or use the speaker icon to get an audio version.

Registration for Lunch and Learn Session - Google Drive and Docs

The following material will be covered in this Session:

  • Logging into Amherst Google Apps for Education
  • Basics of Google Drive
  • Basics of Google Docs
  • Collaborating with others using Drive and Docs

Date: Wednesday june 17, 2015
Time: 12:00 pm - 1:30 pm
Location: frost library barker room a level

lunch will be provided.

Please fill in the following and submit if you wish to attend this class:

Training is an educational process. People can learn new information, re-learn and reinforce existing knowledge and skills, and most importantly have time to think and consider what new options can help them improve their effectiveness at work. Effective trainings convey relevant and useful information that inform participants and develop skills and behaviors that can be transferred back to the workplace.

Pages