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