Head First Excel
A learner's guide to spreadsheets
Publisher: O'Reilly Media
Final Release Date: March 2010
Pages: 448

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.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaHead First Excel
 
3.2

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

60%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (4)

Cons

No Cons

Best Uses

  • Novice (3)

Reviewed by 5 customers

Displaying reviews 1-5

Back to top

(1 of 1 customers found this review helpful)

 
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

     
    3.0

    Good for the real novices only

    By JohnnyB.Bad

    from Toronto, Ontario

    Verified Reviewer

    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.

     
    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

        (1 of 1 customers found this review helpful)

         
        4.0

        helpful, friendly, not Mac-ready (yet)

        By AusDoug

        from Melbourne, Australia

        Verified Reviewer

        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)

          (2 of 7 customers found this review helpful)

           
          1.0

          Download links

          By Mary S

          from Virginia

          Verified Reviewer

          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.

          Displaying reviews 1-5

          Back to top

           
          Buy 2 Get 1 Free Free Shipping Guarantee
          Buying Options
          Immediate Access - Go Digital what's this?
          Ebook:  $27.99
          Formats:  DAISY, ePub, Mobi, PDF
          Print & Ebook:  $38.49
          Print:  $34.99