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