Registration for Intro to Adobe Photoshop Training - Tuesday May 3, 2016

Date: Tuesday May 3, 2016
Time: 10:00-11:15
Location: Frost Library Barker Room A Level

Course Overview

The following material will be covered in this Session:

  • Understand the menu
  • Resize photos
  • Reorient photos
  • Brighten and darken photos
  • Simple photo touch-ups
  • File types and saving

 

 

 

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

Register for Intro to Adobe InDesign Training Workshop

Date: Thursday April 28, 2016
Time: 10:00 a.m. - 11:15 a.m.
Location: Frost Library Barker Room A Level

Course Overview

The following material will be covered in this Session:

  • understand the menu
  • insert text and images into blocks
  • format text
  • manipulate blocks for design
  • file types and file saving

 

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

Full Registration for Microsoft Office Excel 2013 - Intermediate Excel

Date: Tuesday April 26, 2016
Time: 9:00 a.m. - 12:00 noon
Location: Seeley Mudd Room 014 Basement Level

This class session is full with spaces reserved for those who spoke with Denise Orrell and Susan May. We will contact those who expressed interest in registering to confirm your registration as applicable.

Course Overview

The following material will be covered in this Session:

  • named cells and ranges
  • lookup functions
  • logic functions
  • exploring data
  • pivot tables
  • recording macros

Course Outline

Named Cells and Ranges

  • Defining a Name
  • Creating Range Names
  • Using Range Names in Formulas

Lookup Functions

  • VLOOKUP
  • HLOOKUP
  • MATCH

Logic Functions

  • IF-THEN-ELSE
  • OR and AND
  • COUNTIF
  • SUMIF

Exploring Data

  • Using Lists of Data
  • Tables

Pivot Tables

  • Creating a Pivot Table
  • Pivot Table Options
  • Adding Fields
  • Rearranging Fields
  • Field Settings
  • Drilling Down
  • Sorting the Data
  • Report Filter
  • Grouping
  • Calculated Fields
  • Slicers
  • Timelines
  • Pivot charts

Recording Macros

  • Recording Macros
  • Adding Macros to the Quick Access toolbar

Full Registration for Microsoft Office Excel 2013 - Intermediate Excel

Date: Thursday April 14, 2016
Time: 9:00 am - 12:00 pm
Location: Seeley Mudd Room 014 Basement Level

This class session is full.

Course Overview

The following material will be covered in this Session:

  • named cells and ranges
  • lookup functions
  • logic functions
  • exploring data
  • pivot tables
  • recording macros

Course Outline

Named Cells and Ranges

  • Defining a Name
  • Creating Range Names
  • Using Range Names in Formulas

Lookup Functions

  • VLOOKUP
  • HLOOKUP
  • MATCH

Logic Functions

  • IF-THEN-ELSE
  • OR and AND
  • COUNTIF
  • SUMIF

Exploring Data

  • Using Lists of Data
  • Tables

Pivot Tables

  • Creating a Pivot Table
  • Pivot Table Options
  • Adding Fields
  • Rearranging Fields
  • Field Settings
  • Drilling Down
  • Sorting the Data
  • Report Filter
  • Grouping
  • Calculated Fields
  • Slicers
  • Timelines
  • Pivot charts

Recording Macros

  • Recording Macros
  • Adding Macros to the Quick Access toolbar

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.

Date: Tuesday july 28, 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 - 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.

This session has a limit of 20 people, after that no more submissions will be accepted. Please make sure to register or cancel if you can no longer attend so we can adjust the lunch order as needed. Thank you!

This session is full to capacity as of Wed July 15. No further registrations can be accepted.

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: