Books about Spreadsheet from Amazon.com

Color(s) - White. Holds - Up to 2 lbs.. Length [Nom] - 1 in. Mounting Application - Double-Sided Adhesive. Permanent/Removable/Repositionable - Permanent.
Price: $11.94 [Notify me when price goes down.]

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file..
Price: $21.45 [Notify me when price goes down.]

* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features
* Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss
* The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more
* Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information
* Explores Excel programming for those who want advanced information
* CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak.
Price: $19.87 [Notify me when price goes down.]

Every time you turn around, you run into Excel. It’s on your PC at work. It’s on your PC at home. You get Excel files from your boss. Wouldn’t you like to understand this powerful Microsoft Office spreadsheet program, once and for all? Now, you can crunch financial data, add sparkle to presentations, convert static lists of numbers into impressive charts, and discover what all the shouting’s about regarding databases, formulas, and cells. You may even decide that getting organized with a good spreadsheet is downright useful and fun!

Flip open Excel 2003 For Dummies, and you’ll quickly start getting the basics of Excel in plain English. Written for the rest of us, this down-to-earth book gently shows you how to:

• Create a spreadsheet from scratch
• Apply the basics of formatting cells
• Take on database forms—even add records—and prevail
• Get organized and stay that way
• Save worksheets as Web pages for your company intranet

In a clear and easy-to-understand style, veteran software trainer and technology writer Greg Harvey explains the basics of worksheets and workbooks, how to enter data and work with formulas, and how to print your masterpieces. When you’re feeling very bold, he’ll have you adding comments and pictures, saving files with security protection, and learning to zip between multiple worksheets in a workbook with ease. And there’s much more:

• Clip and save the Top Ten Beginner Basics of Excel 2003
• Pay heed to the Top Ten Commandments of Excel 2003
• Impress your colleagues by creating a company org chart
• Re-open those documents and add or edit new data with aplomb
• Move between these sheets without trouble
• Decipher and take charge of helpful tools and commands such as Sort, Filter, Format Cells, and PivotTable

You’ll finally be able to stop pestering the Excel experts in your office. Become your own expert with the friendly and down-to-earth practical instruction you’ll find in Excel 2003 For Dummies..
Price: $11.77 [Notify me when price goes down.]

Maximize the power of the leading small business financial software

Set up a comprehensive small business financial management system with QuickBooks 2008 and the expert advice in this official guide. Filled with practical information, this book explains how to perform essential business tasks and customize QuickBooks for your needs. Track finances, manage payroll, process invoices, monitor inventory, manage sales and expenses, and much more. Run your small business easily and efficiently--regardless of your industry or growth level--using the real-world tips, techniques, and shortcuts in this authoritative guide to QuickBooks 2008.

• Configure and customize QuickBooks for your business
• Log transactions quickly and accurately
• Manage accounts payable and receivable
• Manage customers and vendors
• Monitor inventory
• Track employee hours and manage payroll
• Reconcile bank accounts
• Set up and manage budgets
• Create standard or customized business reports
• Analyze business performance

.
Price: $18.78 [Notify me when price goes down.]

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file..
Price: $27.04 [Notify me when price goes down.]

Product Description
Still the top-selling software suite for Mac users, Microsoft Office has been improved and enhanced to take advantage of the latest Mac OS X features. You'll find lots of new features in Office 2008 for Word, Excel, PowerPoint and Entourage, but not a page of printed instructions to guide you through the changes. Office 2008 for Macintosh: The Missing Manual gives you the friendly, thorough introduction you need, whether you're a beginner who can't do more than point and click, or a power user who's ready to tackle a few advanced techniques.

To cover Word, Excel, PowerPoint and Entourage, this guide gives you four superb books in one -- a separate section each for program! You can manage your day and create professional-looking documents, spreadsheets, and presentations in no time. Office 2008 has been redesigned so that the windows, toolbars, and icons blend in better with your other Mac applications. But there are still plenty of oddities. That's why this Missing Manual isn't shy about pointing out which features are gems in the rough -- and which are duds. With it, you'll learn how to:

• Navigate the new user interface with its bigger and more graphic toolbars
• Use Word, Excel, PowerPoint, and Entourage separately or together
• Keep track of appointments and manage daily priorities with the My Day feature
• Create newsletters, flyers, brochures, and more with Word's Publishing Layout View
• Build financial documents like budgets and invoices with Excel's Ledger Sheets
• Get quick access to all document templates and graphics with the Elements Gallery
• Organize all of your Office projects using Entourage's Project Center
• Scan or import digital camera images directly into any of the programs
• Customize each program with power-user techniques

With Office 2008 for Macintosh: The Missing Manual, you get objective and entertaining instruction to help you tap into all of the features of this powerful suite, so you can get more done in less time.

'Why Should I Upgrade to Office 2008 for Macintosh?'
Author Jim Elferdink talks about what's new in Office 2008 for Macintosh. If you're still using Office 2004, you'll find some great reasons to upgrade. Jim also fills you in on some cool features that Office for Windows can't match, and why you may not need to invest in iWork!

What are the best new features that will make folks want to upgrade to Office 2008?
Publishing Layout view. If you use Word to create formatted documents like letters and brochures, you'll find it so much easier to do now in the new Publishing Layout view than in the old Page Layout view. Publishing Layout view is actually quite similar to Pages; both are very usable. It's a huge boon for Word people—if you haven't bought Pages, now you won't have to!
MyDay. I really enjoy Entourage's MyDay feature. Assuming you're not working on a laptop that doesn't have screen space to spare, I recommend keeping MyDay open in the corner of your screen. That's what I do! It helps me keep track of my appointments and schedule. If you've got appointments every 20 minutes or just a lot going on in your day, it's great to have it all at a glance. It also helps you remember to go pick up the kids. (And you can feel superior to your Windows friends. There's nothing resembling MyDay in Office for Windows.) Project Center. Entourage's Project Center has been streamlined and beautified for 2008, but it's still very underutilized. It takes a little extra effort to learn, but once you've got it up and running, if you're doing any kind of a project that involves Office documents or even files from other programs, it's a great timesaver. It lets you keep shortcuts to all these documents, plus email related to the project, in one window. The Project Center makes it easy to categorize email, contacts, notes, and documents. Things don't get lost, and you don't have to worry about Mac OS X labels and other ways to categorize things. (Office for Windows also has nothing like the Project Center.)
Formula Builder. In Excel, one of the greatest new features is the formula builder. If you use Excel much for formulas at all, especially more complicated ones, it's really a timesaver. It helps you get those things created and working much faster than you could do before.
Elements Gallery. The Elements Gallery concept is really great because it carries over from one program to the other, gives the programs a consistent feel. If you're using a lot of templates or AutoShapes, you'll find it a quick way to get at all that stuff. You could do all these things before, but it was a lot harder to find what you were looking for.

So, are there any disadvantages to upgrading to Office 2008?
Publishing Layout view can be frustratingly slow on G4 Macs, especially when you're trying to move layout elements around onscreen. I would only use it on an Intel Mac. The same caveat holds true for PowerPoint; it's hard to move things around. But the rest of the suite works great on faster G4 machines.
Office 2008 uses the same new, XML-based file format as Office 2007 for Windows. It's great not to have to worry when someone with Office 2007 on a PC sends you something. Office 2008 can open those documents right up. But now when you send documents to Mac folks who haven't upgraded, they won't be able to open them! Once you upgrade to Office 2008, you've got to be aware that not everyone else has, and (unless you have a real need to use the XML format) set your Save options (in Preferences) to the older format so there won't be problems with your attachments.
Then there's the macro problem. Any macros you wrote in earlier versions of Office use the Visual Basic programming language (VBA), and they won't work in Office 2008! If you've written a lot of macros for yourself, you'll have to stick with Office 2004 until you have time to rewrite them in AppleScript.

What do you like best about Office 2008 for Macintosh: The Missing Manual?
I'm happy with the way this book turned out. I think it covers everything you need to use this really powerful suite of programs for all your work. One chapter I'm particularly fond of, and which I think is missing from every other PowerPoint book I've looked at, is Chapter 15—Planning Great Presentations. It helps you prepare for your presentation and shows you how to use PowerPoint for its true purpose. PowerPoint isn't doing the presentation—you are. You're the star of the show! Unfortunately, too many people think it's the other way around..
Price: $18.89 [Notify me when price goes down.]

Excel provides an easy-to-use, powerful spreadsheet environment that helps you handle calculations and data more effectively. With Microsoft Office Excel 2007 Step by Step, youll learn all the ins and outs of working with Excel features, including the exciting new interface for this latest version of Office. This information-packed guide provides numbered steps and hands-on examples that show you how to get the most out of Excel. With this book, youll learn how to work with tools to make worksheet entry faster, make your Excel documents more attractive, present information visually with charts, sorting and filtering data, publish documents on the Web, and lots more. The companion CD provides all exercise source files so that you get hands-on with Excel right away..
Price: $15.33 [Notify me when price goes down.]

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.

This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:

• An introduction to the VBA language
• A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it
• The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder
• The essential VBA language elements, including comments, variables and constants, and labels
• Working with Range objects and discovering useful Range objective properties and methods
• Using VBA and worksheet functions, including a list and examples
• Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop
• Automatic procedures and Workbook events, including a table and event-handler procedures
• Error-handling and bug extermination techniques, and using the Excel debugging tools
• Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks
• Customizing the Excel toolbars
• Using VBA code to modify the Excel menu system
• Creating worksheet functions and working with various types of arguments
• Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities

Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with:

• A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes
• Information to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to know

What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment..
Price: $13.32 [Notify me when price goes down.]

"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA."
—Loren Abdulezer, Author of Excel Best Practices for Business

Everything you need to know about:

• Creating stellar UserForms and custom dialog box alternatives
• Working with VBA subprocedures and function procedures
• Incorporating event-handling and interactions with other applications
• Building user-friendly toolbars, menus, and help systems
• Manipulating files and Visual Basic® components
• Understanding class modules
• Managing compatibility issues

Feel the power of VBA and Excel

No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes

• Trial version of the author's award-winning Power Utility Pak
• Over one hundred example Excel workbooks from the book

System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements..
Price: $26.96 [Notify me when price goes down.]