Advanced Excel (Pivot Tables and Conditional Formatting)

Overview

This short workshop introduces two useful functions of Excel: Pivot tables and Conditional Formatting. More importantly, we'll discuss how to find materials on new topics in Excel.

Materials

Accessing and using textbooks (Google books, Amazon Look-Inside)

Online materials: 

Finney Learning Systems is an example of a website with lots of free Excel 2003 tutorials (text and video).

Conditional formatting (PDF)

Pivot Tables (PDF)

Pivot Tables (HTML)

Local data source: MOA 

Data on 2009 CNR test results

A series of 3 videos is available on pivot tables. We'll discuss how to view online videos in offline mode.