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