The textbook is the main source of
material for the course. Some supplemental material from other books is
posted to the courseware site. But, there are many, many(many, many,
many)
books on Excel ranging from the
...
for Dummies and
The Complete
Idiot's Guide
to ... , to serious introductory and advanced books and Web
sites. Some of these books are descriptive and indicate "how-to" solve
sets of specific problems (very helpful if you are also trying to
identify a technique along with an Excel implementation of it, thus
saving a lot of time), while others provide extensive tutorials.
Although you probably won't need any of these books for this course,
some of you might want to have a few of these on your bookshelf. Many
are available from
Amazon.com, the UGA
Bookstore, Barnes & Noble and
Borders Bookstore, as well as possibly from the Library. Here are some
books, and
as the need arises, and as we identify additional books and readings,
they
will be posted below. (Note, any prices listed are from Amazon.com as
of the revision date of this page.)
This list is evolving. If you discover some good readings, please let
me know, so I can add them to the list.
The For Dummies Books:
Harvey, Greg, Microsoft Office Excel
2007 for Dummies,
For Dummies (Press), 2007 ($14.95).
Comment: These For Dummies books are generally pretty good, but do vary in quality
by author.
Harvey, Greg, Excel 2007 All-In-One
Desk Reference for Dummies,
For Dummies (Press), 2007 ($19.79).
Comment: These For Dummies books are
generally pretty good, but do vary in quality by author.
Here are the titles for
many of the For Dummies Excel books (in alphabetical order
by author; some are in other
languages; bold means I have used it or previous editions):
Excel
Formulas and Functions For Dummies by Ken
Bluttman and Peter G. Aitken (Paperback - Jan 28, 2005) - Abridged
Microsoft
Office Excel 2go007 Formulas & Functions For Dummies (For
Dummies (Computer/Tech)) by Ken Bluttman and
Peter G. Aitken (Paperback
- Jan 30, 2007)
Excel 2007
For Dummies (For Dummies (Computer/Tech))
by
Greg Harvey (Paperback
- Dec 26, 2006)
Excel 2007
All-In-One Desk Reference For Dummies (For Dummies
(Computer/Tech)) by Greg Harvey (Paperback - Jan 3, 2007)
Excel 2007
Workbook For Dummies (For Dummies (Computer/Tech))
by Greg Harvey (Paperback - Sep 4, 2007)
Excel 2007
Just the Steps For Dummies
(For Dummies (Computer/Tech))
by Diane Koers (Paperback - Feb 12, 2007)
Excel 2007
For Dummies Quick Reference (For Dummies (Computer/Tech))
by John Walkenbach and Colin Banfield (Plastic Comb - Jan 10,
2007)
Excel 2007 VBA Programming For Dummies
(For Dummies (Computer/Tech))
by John Walkenbach
and Jan Karel Pieterse (Paperback - Feb 20, 2007)
Other Languages:
Excel 2007
Formeln Und Funktionen Fur Dummies by Ken
Bluttman, Peter G. Aitken, and Sabine Lambrich (Paperback - May 14, 2008)
Excel 2007
Fur Dummies, Alles in Einem Band (Fur Dummies)
by Greg Harvey, Martina Hesse-Hujber, and Sabine
Lambrich (Paperback
- Nov 7, 2007)
Excel 2007
para torpes/ Excel 2007 for Dummies (Informatica Para Torpes/
Information Technology for Dummies)
by Ana
Martos Rubio (Paperback
- Feb 28, 2007)
Plus:
Excel 2007
Dashboards & Reports For
Dummies (For Dummies (Computer/Tech)) by
Michael
Alexander (Paperback
- Mar 4, 2008)
Excel 2007
Data Analysis For Dummies (For
Dummies (Computer/Tech)) by Stephen L., CPA,
MBA, MS Nelson (Paperback
- Feb 20, 2007)
And, for Office 2007:
Office 2007 For Dummies (For
Dummies (Computer/Tech))
by Wallace Wang (Paperback
- Dec 26, 2006)
Office 2007 All-in-One Desk Reference
For Dummies (For Dummies (Computer/Tech))
by
Peter Weverka (Paperback
- Jan 3, 2007)
Of course, there are many of the For Dummies books for every package within Microsoft
Office 2007. Here are a few.
Word 2007
For Dummies (For Dummies (Computer/Tech))
by
Dan Gookin (Paperback
- Dec 26, 2006)
Word 2007
All-in-One Desk Reference For Dummies (For Dummies
(Computer/Tech)) by Doug Lowe (Paperback - Feb 5, 2007)
Cutting
Edge PowerPoint 2007
For Dummies (For Dummies (Computer/Tech)) by
Geetesh Bajaj (Paperback
- Mar 26, 2007)
PowerPoint
2007 For Dummies (For Dummies (Computer/Tech)) by Doug Lowe (Paperback - Dec 26, 2006)
Access
2007 For Dummies (For Dummies (Computer/Tech)) by Laurie Ulrich Fuller, Ken Cook, and John Kaufeld (Paperback - Dec 26, 2006)
Access
2007 All-in-One Desk Reference For Dummies (For Dummies
(Computer/Tech)) by Alan Simpson, Margaret
Levine Young, Alison Barrows, and April Wells (Paperback - Dec 26, 2006)
Access 2007 Workbook For
Dummies
(For Dummies (Computer/Tech)) by Joseph C.
Stockman (Paperback
- Dec 10, 2007)
Access 2007 VBA Programming For Dummies (For Dummies (Computer/Tech))
by Joseph C. Stockman and Alan Simpson (Paperback - Feb 20, 2007)
Access
2007 Forms & Reports For Dummies (For Dummies
(Computer/Tech)) by Brian Underdahl and Darlene
Underdahl (Paperback
- Jan 10, 2007)
More on Excel 2007 (or earlier
versions):
Microsoft
Excel 2007 Quick Reference Card - Handy Durable Tri-Fold MS
Office Excel 2007 Tip & Tricks Guide. 6 Total Pages. Stores
Easily.
Ultimate Reference for Shortcuts, Tips & Cheats for Microsoft Excel
2007 Spread Sheet Software. (Software Quick Reference Cards) by BrainStorm Inc. (Cards - 2007)
Excel Scientific and Engineering
Cookbook (Cookbooks (O'Reilly)) by David Bourg (Paperback - Jan
17, 2006)
Dodge, Mark and Craig Stinson,
Microsoft
Office
Excel 2007 Inside Out, Microsoft Press, ISBN 0-7356-2321-x
($28.34).
Comment: "Inside Out" ... that
says it all!
Excel 2007
PivotTables Recipes: A Problem-Solution Approach (Expert's Voice
in .Net) by Debra Dalgleish (Paperback - Dec 10, 2007)
Pro Excel
2007 VBA (Expert's Voice in Excel VBA) by Jim DeMarco (Paperback
- Feb 28, 2008)
Microsoft® Office Excel® 2007 Step by Step (Step By Step
(Microsoft)) by Curtis Frye (Paperback - Jan 31, 2007)
Frye, Curtis,
Microsoft Office Excel
2007 Plain & Simple (Plain & Simple Series), Microsoft
Press, 2007, ISBN-10: 0735622914.
Comment: This book goes deeper into Visual Basic for Applications (VBA,
previously
called macros) than
our text does.
Excel Annoyances: How to Fix
the Most
Annoying Things about Your Favorite Spreadsheet (Annoyances) by
Curtis Frye (Paperback - Dec 1, 2004)
GO! with
Microsoft Excel 2007, Volume 1 (Go! Series) by Shelley Gaskin,
Alicia Vargas, and Sally Preston, Prentice Hall (Spiral-bound - Aug 5,
2007), ISBN-10: 0135129869.
GO! with Excel 2007
Comprehensive (Go! Series) by
Shelley Gaskin and Karen Jolly, Prentice Hall (Paperback - Jan 10,
2008), ISBN-10: 0132255596.
Mastering Excel 2007: A
Problem-Solving Approach by James Gips, John Wiley
& Sons, New York (Paperback - Aug 11, 2007)
Comment:
The previous edition has been used as a supplementary text in previous
versions of this course. It is an small
and excellent
reference. I like
all the material on functions. Gips presents simple, excellent examples
of functions. I will definitely use some of this material for examples
of functions.
Exploring Microsoft Office Excel
2007, Comprehensive (2nd
Edition) (Exploring) by Robert T.
Grauer, Judy Scheeren, and Keith Mulbery (Spiral-bound - Feb 2, 2008)
Exploring
Microsoft Office Excel 2007
Volume 1 (Exploring) by Robert T.
Grauer and Judy Scheeren (Paperback - Jun 9, 2007)
Excel 2007
VBA Programmer's Reference (Programmer to Programmer) by John
Green, Stephen Bullen, Rob Bovey, and Michael Alexander (Paperback -
Mar 26, 2007)
Excel Hacks: Tips & Tools for
Streamlining Your Spreadsheets (Hacks) by David Hawley and Raina
Hawley (Paperback - Jun 20, 2007)
Hawley, David, and Raina Hawley, Excel
Hacks:
100 Industrial-Strength Tips
and Tools, O'Reilly, ISBN
0-596-00625-X.
Comment: One hundred helpful
little tricks.
VBA and
Macros for Microsoft Office Excel 2007 (Business Solutions)
by Bill Jelen and Tracy Syrstad (Paperback - Aug 19, 2007)
Charts
and Graphs for Microsoft Office Excel 2007 (Business Solutions)
by Bill Jelen (Paperback - May 4, 2007)
Special
Edition Using Microsoft(R) Office Excel 2007 by Bill Jelen
(Paperback
- Dec 16, 2006)
The
Unofficial Guide to Microsoft Office Excel 2007 (Unofficial
Guide) by Julia Kelly and Curt Simmons (Paperback - Feb 5, 2007)
Excel 2007: The Missing Manual
by Matthew MacDonald (Paperback - Dec 27, 2006)
Teach Yourself VISUALLY Excel 2007
(Teach Yourself VISUALLY (Tech)) by Nancy C. Muir 2007) ISBN-10:
0470045957
Microsoft
Office Excel 2007: Comprehensive Concepts and Techniques (Shelly
Cashman Series) by Gary B. Shelly, Thomas J. Cashman, and Jeffrey J.
Quasney (Paperback - Aug 29, 2007)
Microsoft
Office Excel 2007: Complete Concepts and Techniques (Shelly
Cashman Series) by Gary B. Shelly, Thomas J. Cashman, and Jeffrey J.
Quasney (Paperback - Aug 2007)
Excel 2007
for Scientists and Engineers (Excel for Professionals series) by
Dr. Gerard Verschuuren (Paperback - April 1, 2008)
Excel 2007
Power Programming with VBA (Mr. Spreadsheet's Bookshelf) by John
Walkenbach (Paperback - April 16, 2007)
John
Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr.
Spreadsheet's Bookshelf) by John Walkenbach (Paperback - Jun 25, 2007)
Excel 2007
Formulas (Mr. Spreadsheet's Bookshelf) by John Walkenbach
(Paperback
- Feb 12, 2007)
Excel 2007
Bible by John Walkenbach (Paperback - Jan 3, 2007)
Mr.
Spreadsheet's Excel 2007 Library by John Walkenbach (Paperback -
Jul 30, 2007)
Excel 2007
Charts (Mr. Spreadsheet's Bookshelf) by John Walkenbach
(Paperback
- Oct 1, 2007)
Microsoft® Office Excel® 2007: Data Analysis and Business
Modeling (Bpg -- Other) by Wayne L. Winston (Paperback - May 16,
2007)
Excel 2007
Advanced Report Development by Timothy Zapawa (Paperback - Mar
26, 2007)
In other languages:
Wenn Excel Nervt by
Curtis
Frye (Paperback - Jun 30, 2005)
Excel /
Excel Hacks: Los Mejores Trucos / The Best Tricks (Anaya
Multimedia/O'Reilly) by David Hawley and Raina Hawley (Paperback - Sep
30, 2005)
Excel 2007: Los Mejores Trucos/ the
Best Tricks by Raina Hawley and David Hawley (Paperback - Jan
2008)
Free Online
Tutorials (Do a Web
Search)
TutorViaComputer Free Online
Tutorials from Baycon Group (www.baycongroup.com/tutorials.htm).
Microsoft Office Online (office.microsoft.com/en-us/training/default.aspx).
Mad Marv's Place (I started
here: madmarvonline.com/blog/2007/02/14/excel-tutorial-financial-functions/).
Contextures (I started here: www.contextures.com/xlFunctions03.html).
Links to many online training
programs: Internet 4 Classrooms [I4C] (www.internet4classrooms.com/on-line2.htm).
Links
to many online training programs: EducationOnlineForComputers.com
(www.educationonlineforcomputers.com/links/)
More?
If you find any useful Excel books or tutorials, do bring them to my
attention so I can add them to the list. Thanks!
More General Material Worth Reading
Standage, Tom, The
Victorian Internet: The Remarkable Story of the Telegraph and the
Nineteenth Century's On-line Pioneers, Walker and Company, New
York, 1998, ISBN 10: 0-8027-1604-0.
Recommended
Career and Life Reading:
Honoré, Carl, In Praise of
SLOWNESS: How a Worldwide
Movement is Challenging the Cult of Speed, HarperSanFrancisco, A
Division of HarperCollins Publishers, Inc., New York, ISBN:
0-06-054578-x, 2004.