Advanced Excel (Pivot Tables and Conditional Formatting)
Overview
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)
A series of 3 videos is available on pivot tables. We'll discuss how to view online videos in offline mode.