Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user.
Whether you're completely new to Excel or an experienced user looking to make the program work better for you, this book will help you incorporate Excel into every aspect of your workflow, from a scratch pad for data-based brainstorming to exploratory analysis with PivotTables, optimizing outcomes with Goal Seek, and presenting your conclusions with sophisticated data visualizations.
Organize and clearly present information in a spreadsheet
Make calculations across a number of worksheets
Change your point of view with sorting, zooming, and filtering
Manipulate numerical data to extract and use just what you need
Leverage Excel as a grid-based layout program
Write formulas for optimal functionality
Nest formulas for more complex operations
Create sophisticated data visualizations with charts and graphs
Use Goal Seek to optimize possible outcomes based on different assumptions
Create summaries from large data sets for exploratory data analysis with PivotTables
We think your time is too valuable to waste struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First Excel uses a visually rich format designed for the way your brain works, rather than a text-heavy approach that will put you to sleep.
Michael Milton is the author of Head First Data Analysis. He has spent most of his career helping nonprofit organizations improve their fundraising by interpreting and acting on the data they collect from their donors.
He has a degree in philosophy from New College of Florida and one in religious ethics from Yale University. He found reading Head First to be a revelation after spending years reading boring books filled with terribly important stuff and is grateful to have the opportunity to write an exciting book filled with terribly important stuff.
When he's not in the library or the bookstore, you can find him running, taking pictures, and brewing beer.
Sincerely, this book does a fair job explaining the basic usage of spreadsheet program and some good practice.
However, I would like to remind people that Excel is not the only spreadsheet program on earth. There are several alternative programs using exactly same paradigm.
Among them, I just want to talk about a free (in sense of beer as well as in sense of speech) program called OpenOffice.org Calc. It is part of OpenOffice.org.
OpenOffice.org (http://www.openoffice.org/) is an office suite supports Windows, Linux, Mac OS X and Solaris. It is free of charge! It contains most features of Microsoft Office, in particular, it can create PDF files. It has its own extensive repository of extensions and templates. It doesn't use Ribbon UI (why bother?). It wouldn't charge you too many disk space.
Moreover, OpenOffice.org is available legally in the form of portable app (http://portableapps.com/). You can put it in your flash driver and use it freely in any Windows computers (with USB support).
The only critical caveat is, it may not always open Microsoft Office files flawlessly. However, if your only need is viewing. Use Microsoft's free viewer or use an online conversion site.
If you have an authorized, relatively new version of Microsoft Office. Please ignore me. Otherwise, you may give OpenOffice.org a try.
I know the words above sounds like AD. But I don't get paid. I'm just trying to point out the very fact that doing things mentioned in this book requires no software purchase.
I expect that there will be odds if you follow this book using OpenOffice.org. To resolve the issue, I will give some notes for OpenOffice.org after I finish reading the entire book.
11/7/2011
4.0
Head First Excel
By ocealot2
from New Orleans, LA
Pros
Easy to understand
Helpful examples
Well-written
Cons
Best Uses
Novice
Student
Comments about O'Reilly Media Head First Excel:
Copy and paste this link for the labs.
http://www.headfirstlabs.com/books/hfexcel/#code
8/31/2011
3.0
Good for the real novices only
By JohnnyB.Bad
from Toronto, Ontario
Pros
Easy to understand
Helpful examples
Cons
Not comprehensive enough
Too basic
Best Uses
Novice
Student
Comments about O'Reilly Media Head First Excel:
Didn't really like the way this book is designed. Too much distractions with the pictures of people and there thought clouds. If you are a real novice, it might interest you and would teach you the basics, but anybody who knows Excel will probably get fed up of it quite quickly.
7/21/2010
4.0
Site links in book don't work
By Fooby
from Australia
About Me Developer
Pros
Easy to understand
Cons
Best Uses
Comments about O'Reilly Media Head First Excel:
Good book, but shame about the site links ... they don't work. Nor does the link suggested in the response to the second reviewer
5/17/2010
(1 of 1 customers found this review helpful)
4.0
helpful, friendly, not Mac-ready (yet)
By AusDoug
from Melbourne, Australia
Pros
Accurate
Easy to understand
Well-written
Cons
Best Uses
Novice
Comments about O'Reilly Media Head First Excel:
I thought the book was very helpful in places. The writing is user-friendly and keeps the reader engaged. The book is easy to read and follow.
I have only two problems with the book:
1. The links within the .pdf don't work, so you need to download the entire file package and load the files from your hard disk. This isn't such a big deal
2. Many of the features aren't included in the Mac versions of Excel yet. This certainly isn't the author's fault, but it does tempt you about all this cool stuff that the Mac version doesn't do
Overall, I'd recommend the book for someone learning Excel (such as me)
5/6/2010
(2 of 5 customers found this review helpful)
1.0
Download links
By Mary S
from Virginia
Comments about O'Reilly Media Head First Excel:
I have been trying to download the forms to no avail. The book is great however the automation links are inept.
Merchant response: We're sorry to hear that trouble with supporting links for turned your review of a "great" book to a negative one-star rating. But we also want to make sure you're able to download the files. If you go to the book's support page http://www.headfirstlabs.com/books/hfexcel/#code, you'll find all files available for download, either individually or all included in a single .zip file. Do make sure that you right-click and choose "Save as..." on the individual links, as just clicking on them will open them as gibberish in a web browser, but Excel will read the file correctly if you first download it to your desktop.
Again, we're sorry to hear you had a disappointing experience with the book and do hope this helps change your feelings about its usefulness.