Intermediate Microsoft Excel


Friday, September 15, 2017, 9:00am to 3:00pm


Harvard Ed Portal, 224 Western Ave., Allston

This course is intended for individuals who wish to begin the higher-level Excel functionality to analyze and present data.

Prerequisites: Microsoft Excel for Beginners or equivalent knoweldge

Workshop Objectives: Create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, Pivot Charts and data filtering.


  1. Customizing the Excel Environment
  2. Creating Advanced Formulas
  3. Analyzing Data with Functions and Conditional Formatting
  4. Organizing and Analyzing Datasets and Tables
  5. Visualizing Data with Basic Charts
  6. Analyzing Data with PivotTables, Slicers, and Pivot Charts

In addition to the course, participants can attend two Practice Sessions:

September 19, 2017, 10:00am-12:00pm, Harvard Ed Portal iStudio
September 21, 2017, 10:00am-12:00pm, Harvard Ed Portal iStudio

Participants will be guided through activities to practice what they learned in the course.  

Related Programs:

Microsoft Excel for Beginners
Microsoft Word for Beginners
Intermediate Microsoft Word
Microsoft Powerpoint for Beginners