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