These online materials are for students in Duke's Global MBA program who are
honing their Excel skills in preparation for their upcoming Decision Models course.

   

Excel review documents (PDF format)

Nutshell Introduction to Excel
A Review of Excel Basics
Excel Efficiencies
Excel Formulas Review
Excel Logic Exercises
Excel Design & Audit Tips
Proficiency Exercises
Data Tables Introduction
Regress Skillbuilding & Quick Guide

 

Additional supporting spreadsheets (Excel 2003 xls format)

Formula Review
IF & Logic Demo
Logic Practice
Bad And Good Formula Techniques
Addressing
3-D References
Charting Basics
Charting Primer I
Charting Primer II
Dfunction Review
Dynamic Range Names
Excel Auditing Tools
Forecasting Tools
Hiding & Protection Notes
Outlining and Grouping
Simple Array Examples
Sorting Cautions
Subtotals
Using Online Help
Transforming Excel Data

 

Recommended Excel Resource Websites

Duke's Fuqua School of Business Excel Review - A compendium of documents, files, links, and recommendations.
Excel User - Practical tips and advice by Charlie Kyd.
The Spreadsheet Page - John Walkenbach's online resource for Excel.
Microsoft Online KnowledgeBase for Excel
Contextures - D. Dalgliesh's Excel resource with examples.
Pioneer Training Blog - Tips, tricks, opinions, and information for business computer users.



 

Spring-Summer 2008

paula dot ecklund at duke dot edu