Summer Lunch and Learn Sessions for Google Apps, Outlook and Excel

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: