Intermediate Microsoft Excel for Harvard Ed Portal Members

[Brigid ORourke]

Intermediate Microsoft Excel for Harvard Ed Portal Members

March 7, 2018

9:00am - 4:00pm

This course is intended for Harvard Ed Portal members who wish to begin using higher-level Excel functionality to analyze and present data.

Prerequisites: Beginner Microsoft Excel 2016 or equivalent experience.

 

Course Objectives: Learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

 

Course Outline:

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 PivotCharts

 

 

In addition to the course, participants can attend a Practice Session.

March 9, 2018, 10:00-12:00, Harvard Ed Portal iStudio

 

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

 

**Please note: You must be a member of the Harvard Ed Portal, live in Allston-Brighton or be the parent/guardian of a student who attends the Gardner Pilot Academy to attend this course. The Harvard Ed Portal reserves the right to cancel RSVP for registrants who do not meet these requirements. To learn about membership to go: https://edportal.harvard.edu/

 

Lunch is not served. No need to bring a computer. This course is taught using Ed Portal laptops.