duke                                      engineering                    

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 2010, 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
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)
A Dynamic Chart Example
Excel's Web Query
Excel's Pivot Table, an Unusual Pivot Table Example, and Source Data
SOLVER



Demo File

Excel Workshop.xlsm


Online
Resources

Duke University Fuqua School of Business Excel Review Materials

Chandoo (Purna Duggirala)

Mr. Excel (Bill Jelen)

Tushar Mehta

The Spreadsheet Page (John Walkenbach)

DataPig Technologies (Michael Alexander)


11.12.2011