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.

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

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:

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