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

    Best Uses

    • Novice (3)

    Reviewed by 5 customers

    Sort by

    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