Excel 2007 For Dummies [Paperback]

Greg Harvey (Author)

Book Description

ISBN-10: 0470037377 | ISBN-13: 978-0470037379 | Publication Date: December 26, 2006 | Edition: 1

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here!

If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

You’ll discover how to:

• Rearrange, delete and insert new information
• Keep track of and organize data in a single worksheet
• Transfer data between the sheets of different workbooks
• Create a chart using the data in a worksheet
• Add hyperlinks and graphics to worksheets
• And more!

Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

Editorial Reviews

Review

"...the simple guidance in this book will have you excelling at home or in the office in no time."  (PQ Magazine, November 2007)

From the Back Cover

Navigate Excel with the Ribbon and Office Button

Find out how to create and edit charts, add hyperlinks to worksheets, and more

Here's an excellent way to get the scoop on the cool features of Excel 2007, including the user-friendly interface, Live Preview, and easier collaboration options. You'll soon excel at organizing and maintaining your worksheets, doing "what-if" data analysis, dressing up your charts and graphs, playing with pivot tables, and sharing your stuff. The included four-color insert highlights the Ribbon, new graphics features, and more!

Discover how to

• Create and edit worksheets
• Design database forms
• Save your worksheet as a Web page
• Apply style galleries to spreadsheets
• Work with formulas
• Include graphics in your charts

See all Editorial Reviews

Product Details

• Paperback: 416 pages
• Publisher: For Dummies; 1 edition (December 26, 2006)
• Language: English
• ISBN-10: 0470037377
• ISBN-13: 978-0470037379
• Product Dimensions: 9.3 x 7.4 x 0.9 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (38 customer reviews)
• Amazon Best Sellers Rank: #4,269 in Books (See Top 100 in Books)
  • #49 in Books > Computers & Technology > Software

More About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel Timesaving Techniques For Dummies and Roxio Easy Media Creator For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

Customer Reviews

Most Helpful Customer Reviews

20 of 20 people found the following review helpful:

4.0 out of 5 stars very helpful, February 13, 2008

By 

Cindy L. Harvell "siempreseagull" (Marathon, Fl) - See all my reviews
(REAL NAME)   

This review is from: Excel 2007 For Dummies (Paperback)

This is a good book to get you started working with excel. It takes away the fear factor. It could give better detail on how to build formulas. It is a fairly simple, basic book and does not really deal with formulas as much as it could. It is very good at other aspects though, such as just getting started putting together a spread sheet.

22 of 24 people found the following review helpful:

5.0 out of 5 stars grateful, January 7, 2008

By 

J. Borboa - See all my reviews
(REAL NAME)   

This review is from: Excel 2007 For Dummies (Paperback)

This book came in very handy with the accounting class that I am taking. I had a little knowledge but not much and this book helps alot. I keep it right next to my computer and pull it out and use it on a daily basis. I continue to learn new tricks and shortcuts to make my life easier.

89 of 109 people found the following review helpful:

5.0 out of 5 stars A Quick Way to Find Out What's New, December 21, 2006

By 

John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   

This review is from: Excel 2007 For Dummies (Paperback)

I suppose that you'd be inteested in this book for one of two reasons.

First, you're a newcommer to Excel and want to be hand held from the beginning to get started. I suppose that there must be at least a few people out there who don't know Excel - Well, my mother doesn't, but she's not likely to read this book anyway.

Second, and I suspect most of us fit into this category, we've been using Excel for a lot of years, but at a fairly rudimentary level. We do expense accounts, a few formulas to check things out, maybe use it as a calculator, etc. We don't do things like macros or pivot tables.

Now though, there's a new version of Excel - Excel 2007. It is worth spending the bucks on? What does it have that I might find useful? And I don't want to just see the Microsoft hype, I want a bit more than that. So here for twenty bucks or so is not only a description of what's new, but how to use it.

As best I can tell, the biggest change in Excel 2007 in in its user interface. There's a new look on the screen called the ribbon. This seems to replace all the various toolbars and the like from previous versions with a new layout that puts the bulk of the Excel commands you use only one click away. (The existing File button is replaced by an 'Office' button.) Furthermore, the Ribbon appears to be a dynamic thing. As you are doing something different, for example charting, a different set of frequently used commands appear in the Ribbon. The Ribbon is also easy to customize, so if you're doing a spreadsheet for someone else to use, you can get rid of things that might get them into trouble.

Down inside there are a bunch of other changes. Instead of being limited to a fixed number of columns and rows, how big a sheet you can build is limited only by the memory size. The formatting and fonts area is changed a bunch.

That's just the first chapter of this book. It's a great way to see if the new Excel is for you. And, oh by the way, if you decide that maybe you do want to do a pivot table, it's Chapter 9, and yes, there have been a few changes here as well.