Microsoft Office Excel 2016 Beginner Level - Introduction to Excel

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

Microsoft Office Excel 2016 Intermediate Level - Excel Data Analysis

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

Microsoft Office 2013/2016 Mail Merge with Word and Excel

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

Microsoft Office 2013/2016 Excel Intermediate Level Introduction to PowerPivot

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

Microsoft Office Excel 2016 Tips, Tricks and Shortcuts

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

Microsoft Office 2013/2016 Word Tips, Tricks and Shortcuts

You must register to attend this workshop. If no register option is available below the class is full.

Validation
CAPTCHA Image

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

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
CAPTCHA Image

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
CAPTCHA Image

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