Spreadsheets Books

Office 2007: The Missing Manual

Chris Grover, Matthew MacDonald, E. Vander Veer

Amazon Price: $23.09 List Price: $34.99 By: Pogue Press Amazon Marketplace: 34 new & used starting at $17.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Software -> Business -> Utilities
Subjects -> Computers & Internet -> Software -> Business -> Accounting -> General

Customer Reviews:
Total reviews: 6 Average rating: 4.0 of 5

Editorial Review:

Quickly learn the most useful features of Microsoft Office 2007 with our easy to read four-in-one guide. This fast-paced book gives you the basics of Word, Excel, PowerPoint and Access so you can start using the new versions of these major Office applications right away. Unlike every previous version, Office 2007 offers a completely redesigned user interface for each program. Microsoft has replaced the familiar menus with a new tabbed toolbar (or "ribbon"), and added other features such as "live preview" that lets you see exactly what each option will look like in the document before you choose it. This is good news for longtime users who never knew about some amazing Office features because they were hidden among cluttered and outdated menus. Adapting to the new format is going to be a shock -- especially if you're a longtime user. That's where Office 2007: The Missing Manual comes in. Rather than present a lot of arcane detail, this quick & friendly primer teaches you how to work with the most-used Office features, with four separate sections covering the four programs. The book offers a walkthrough of Microsoft's redesigned Office user interface before taking you through the basics of creating text documents, spreadsheets, presentations, and databases with:

• Clear explanations
• Step-by-step instructions
• Lots of illustrations
• Plenty of friendly advice

It's a great way to master all 4 programs without having to stock up on a shelf-load of different books. This book has everything you need to get you up to speed fast. Office 2007: The Missing Manual is truly the book that should have been in the box.

Excel Data Analysis for Dummies

Stephen L., CPA, MBA, MS Nelson

Amazon Price: $16.49 List Price: $24.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 55 new & used starting at $7.55

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Spreadsheets
Subjects -> Computers & Internet -> Microsoft -> Databases

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Editorial Review:

So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job.

Using Excel for this kind of stuff is what Excel Data Analysis For Dummies is all about. This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel.

Ready to take Excel to the next level? This plain-English guide covers all of these concepts, and more, to ensure that you’re using Excel to its fullest capacity:

• Harnessing information in lists
• Querying external databases and Web pages tables
• Cleaning data with text functions
• Building and working with PivotTables
• Customizing PivotCharts
• Using the statistics functions
• Understanding Optimization Modeling

If all this talk of statistics and advanced tools makes you light-headed, don’t worry. Excel Data Analysis For Dummies distills the most important fundamentals into everyday language. You’ll find just enough information to help you get your work done – without leaving you gasping for air in a sea of technobabble. It’d be a real shame if you didn’t at least know what bells and whistles Excel has to offer and the basic steps that you need to use them.

Programming Excel with VBA and .NET (Programming)

Jeff Webb, Steve Saunders

Amazon Price: $34.64 List Price: $54.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 38 new & used starting at $24.98

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Development -> VBA
Subjects -> Computers & Internet -> Microsoft -> Development -> Visual Basic -> .Net
Subjects -> Computers & Internet -> Microsoft -> Operating Systems -> Windows - General

Customer Reviews:
Total reviews: 2 Average rating: 5.0 of 5

Editorial Review:

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.

The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).

This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.

With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

Excel 2000 for Windows for Dummies

Greg, PhD Harvey

Amazon Price: $14.95 List Price: $21.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 82 new & used starting at $1.80

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> General
Subjects -> Computers & Internet -> Certification Central -> Office
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 9 Average rating: 3.5 of 5

Editorial Review:

You may not be a dummy, but that doesn't mean you were born knowing how to use spreadsheets. Excel 2000 for Windows for Dummies will bring you up to speed on Microsoft's premillennial package, even if you've never used anything like it before.

A great reference for the beginner and the pressed-for-time, this book is organized as a series of chapters that build from the basics of pointing and clicking and figuring out the different parts of the spreadsheet to more advanced topics like Web-based data entry and macros. Visual learners will find much to love as well--there are screen shots galore and plenty of icons to point you to the most salient items quickly.

Written in characteristic Dummies-style--laid-back and humorous--the text is as nonthreatening as can be; even the most diehard computer-phobes will find themselves chuckling as they (gulp) learn how to enter data. The techno-geeks down the hall might snicker at the bright yellow book on your desk, but you can snicker right back because you know you have better weekends. --Rob Lightner

Microsoft Office Excel 2003 QuickSteps (Quicksteps)

John Cronan

Amazon Price: $11.55 List Price: $16.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 34 new & used starting at $3.86

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Programming -> Software Design, Testing & Engineering -> Software Development
Subjects -> Computers & Internet -> Microsoft -> Operating Systems -> Windows - General
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel

Customer Reviews:
Total reviews: 6 Average rating: 5.0 of 5

Great Tool 5 out of 5 stars.
12 of 12 people found this review helpful.

I don't use Excel all the time. But when I do I don't have time to troubleshoot problems.

This hands-on, user friendly book has helped me conquer Excel. The text is readable and well organized. The visuals are clean and fully support the instructions.

I found that you can start from the beginning and teach yourself EXCEL with simple step by step instructions or you can flip straight to your topic of interest and further build your skills. This is a great tool for all levels of expertise.

Great for my users 5 out of 5 stars.
12 of 14 people found this review helpful.

I manage a medium-sized network and support a large number of fairly savvy users. That is, most users know how to do their specific tasks very well and are willing to learn new things. But they are not willing to sit down with a book full of dense text. This is where the "Quick Steps" books come in handy. I keep a number of these books on hand and when a user requests assistance, I give them one of the books with the appropriate page bookmarked. Steps are outlined in full color with lots of pictures and pointers and tips. Additional information is set off in side boxes so users can learn more if they choose. What I have found is that once a user completes a task successfully, they get fairly excited about the experience and browse the book to learn more. The books really stimulate users to experiment with things they would not normally bother to learn. And that is where this book excels. It is a "browser." Users don't feel like they need to start at the beginning and read through to the end. I get lots of grumbles when I ask for the book back so I can pass it on to others.

This book is also great for new users. I tell them to spend a few hours working through the steps, which are easy to follow and can be done at a fairly fast pace. Most users think the full color layout is fun to work through. The down-side is that like any book, space is limited, especially with the fully-illustrated format, so you're obviously not going to find everything in these books, but I do feel they contain a good balance of material and are appropriate for corporate libraries.

Marty (the concept author for the Quick Steps series) and I are fellow writers and that is how I learned about these books. I must say that they have helped my users enormously and relieved my support task. Hey, it's the 21st century. Anyone working in an office should know how to work with operating systems and common applications. Most people can do that if they have easily accessible references and refresher material like these books. Thanks to Marty for developing the "Quick Steps" concept and to McGraw-Hill for publishing this series.

Editorial Review:

Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don’t break the flow of the quick steps themselves.

Microsoft Office 2000 8-in-1 Step by Step (Step By Step (Microsoft))

Catapult Inc., Perspection Inc., ActiveEducation

List Price: $44.99 By: MSOFT - Model: 1-57231-984-4 Amazon Marketplace: 45 new & used starting at $1.12

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> General
Subjects -> Computers & Internet -> Hardware -> PCs
Subjects -> Computers & Internet -> Programming -> General

Customer Reviews:
Total reviews: 5 Average rating: 4.0 of 5

Great initial investment pursuant to MOUS certification 4 out of 5 stars.
20 of 23 people found this review helpful.

My goal for 2001 is to obtain the MOUS certificate at the Master level. I have used MS products with the concentration of my experience centering on Word and Excel. I have used Access sporadically and with intermediate level performance. My experience with PowerPoint leaves much to be desired since I mainly use the wizards. My funds are limited so I wanted an all-inclusive reference (with CD Rom for practice) which would provide a basis for my study. I bought the book from another source (please forgive me oh mighty Amazon) and in terms of area concentration I would say it is intense concentration on beginning information, greater than average concentration on intermediate knowledge and average concentration on advanced applications. This is not a problem - I plan to buy books which center completely on each package as I master the foundation of each package. I would disagree with anyone who states that this is not for the advanced user, with constant upgrades and education there is no way anyone can ever retain each ounce of minutiae that can be acquired; this book is an excellent refresher. For the beginning or intermediate it is an excellent basis for further study.

Editorial Review:

OFFICE 2000 8 IN 1 STEP BY STEP

Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel

Bill Jelen

Amazon Price: $22.45 List Price: $24.95 Usually ships in 24 hours By: Holy Macro! Books Amazon Marketplace: 18 new & used starting at $15.48

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Spreadsheets
Subjects -> Computers & Internet -> General
Subjects -> Computers & Internet -> Software -> Spreadsheets -> General

Customer Reviews:
Total reviews: 5 Average rating: 5.0 of 5

A Book on What's New In Excel 2007 5 out of 5 stars.
5 of 12 people found this review helpful.

I think there are two reasons for buying a book on Excel 2007.

First, of coure, is if you are new to Excel. I suppose that there are some people out there who don't know Excel. If you're one of these, this is not the book for you.

Second, and I expect far more common comes in two versions. (1) you know and use Excel and are wondering if it is worth while to spend the money to pay for an upgrade, and if it is worth while to spend the time and effort to learn the new features. (2) you have the new Excel and are looking at the 'RIBBON' and wondering what to do with it.

In either of these cases this is the book for you. It's a small book on what's new in Excel 2007, it skipps all the beginning stuff like 'what is a spreadsheet.' It starts with the Ribbon. What else, that's the biggest change. And from there it goes on to the other major changes into what Microsoft did with Excel in this revision.

This little book could save you an awful lot of time and effort.

Editorial Review:

In this addendum to Learn Excel from Mr. Excel, the amazing new features offered in Excel 2007 are introduced. Revealing the features that make this new version the best new release of Excel since 1997, this guide provides the necessary information to teach users to quickly unleash the powerful new features in Excel 2007, create incredible-looking charts, customize color themes to match their corporate logo, utilize data-visualization tools, and learn Pivot Table improvements.

Microsoft Office Excel 2007 for Windows (Visual QuickStart Guide)

Maria Langer

Amazon Price: $17.59 List Price: $21.99 Usually ships in 24 hours By: Peachpit Press Amazon Marketplace: 38 new & used starting at $9.34

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Operating Systems -> Windows - General
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Spreadsheets

Editorial Review:

Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web. For the first time in years there is a lot to learn to make the most of this powerful new update. To take advantage of all of the new features in this powerful program (and to do so quickly), users need this Visual QuickStart Guide. In these pages, veteran author and trusted Excel teacher Maria Langer provides step-by-step instructions for the full gamut of Excel tasks: from worksheet basics like editing, using functions, formatting cells, and adding graphics objects, to more advanced topics like creating charts, working with databases, and Web publishing. As with all Visual QuickStart Guide books, clear, concise instructions and lots of visual aids make learning easy and painless.

Excel 2002 for Dummies

Greg, PhD Harvey

Amazon Price: $14.95 List Price: $21.99 Usually ships in 24 hours By: For Dummies Amazon Marketplace: 49 new & used starting at $0.64

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Operating Systems -> Windows - General
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Spreadsheets

Customer Reviews:
Total reviews: 1 Average rating: 4.0 of 5

Editorial Review:

Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that.

One look at the Excel 2002 screen (with all its boxes, buttons, and tabs), and you realize how much stuff is going on there. Excel 2002 For Dummies will help you make some sense out of the rash of icons, buttons, and boxes that you're going to be facing day after day. And when you ready to go beyond spreadsheet basics, this guide will also introduce you to

• Conjuring up charts
• Inserting graphics
• Designing a database
• Converting spreadsheets into Web pages

Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you'll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel. This down-to-earth guide covers all these topics and more:

• Creating a spreadsheet from scratch
• Document recovery
• Formatting fundamentals
• Making corrections (and how to undo them)
• Retrieving data from your spreadsheets
• Protecting your documents
• Demystifying formulas

Now, even if your job doesn't involve creating worksheets with a lot of fancy financial calculations or lah-dee-dah charts, you probably have plenty of things for which you could and should be using Excel. For instance, you may have to keep lists of information or maybe even put together tables of information for your job. Excel is a great list keeper and one heck of a table maker. You can use Excel anytime you need to keep track of products that you sell, clients who you service, employees who you oversee, or you name it.

Excel 2002 Bible

John Walkenbach, Brian Underdahl

Amazon Price: $29.19 List Price: $39.99 Usually ships in 24 hours By: Wiley Amazon Marketplace: 47 new & used starting at $9.89

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Microsoft -> Applications -> Excel
Subjects -> Computers & Internet -> Microsoft -> Spreadsheets
Subjects -> Computers & Internet -> General

Customer Reviews:
Total reviews: 5 Average rating: 4.5 of 5

Not a bible, more like a quick review 2 out of 5 stars.
56 of 63 people found this review helpful.

Having used Excel for a number of years and various other Excel guides, I have been disappointed each time I have tried to use this book.

The worst feature? The index. Any reference book should be able to point you to where you want to go, but with only one description of most functions -- and you have to guess at which word the author will choose to pick for the index -- you're often spending more time trying to figure out the "bible" than you would if you were just fiddling with Excel on your own.

So if you're looking for a guidebook for Excel, my opinion is to find a different book, perhaps one of the Que "Special Edition" series instead.

Editorial Review:

Microsoft Excel 2002 Bible delivers comprehensive, authoritative coverage of what you need to know about Excel. Learn to go beyond entering data and applying simple formulas. Microsoft Excel 2002 Bible empowers you to tap the enormous potential of Excel. This volume shows how to use Excel effectively on the Internet or intranet. It's an excellent all-in-one reference for anyone who uses Excel, from novices to experts.