duke

Seminar
The Power of Excel

Purpose

Demonstrate some of the power of Excel and show a few of its many features. This presentation is intended as an introduction to entice you to learn more Excel rather than as a training session for any particular feature or function of the software.

Platform

Excel 2007, Windows operating system

Audience

Pratt students and invitees. No prior experience is necessary.

Topics

What is Excel?
Excel Components
Resources
Formats
Data Samples 1-4
Function Basics
The IF Function (and Alternatives)
The SUMPRODUCT Function
The Name Manager
Checkbox (dynamic chart)
Demo: Name, Sort, Subtotal, Conditionally Format
Demo: Text-to-Columns, Remove Duplicates, Import
VLOOKUP with Controls Example
INDEX with Controls Example
Conditional Formatting Overview & in Context
The Data Table and an Automated Version
Summary Sparklines (and detailed source data)
Data Validation (and source lists)
More Dynamic Charting
Excel's Web Query
Excel's Pivot Table, an Unusual Pivot Table Example, and Source Data
SOLVER
Bonus: Visual Cool


Demo File

Excel Workshop.xlsm

Online
Resources

Duke University Fuqua School of Business Excel Review Materials

Excel Hero (Daniel Ferry)

Chandoo (Purna Duggirala)

Mr. Excel (Bill Jelen)

Tushar Mehta

The Spreadsheet Page (John Walkenbach)

DataPig Technologies (Michael Alexander)

11.16.2010

compubeast