spreadsheets

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

• 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.

Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf)

• 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

Management Science: The Art of Modeling with Spreadsheets, Excel 2007 Update

The update to the second edition of Management Science: The Art of Modeling with Spreadsheets by Steve Powell and Ken Baker is revised to be compatible with Microsoft Excel 2007. Like the original second edition, the text expands upon the essential skills needed to develop real expertise in business modeling.  In principle, two students could work side by side in a course, one using the Second Edition and relying on Excel 2003, the other using the Update Edition and relying on Excel 2007. They will be able to learn the same skills, as both versions of the book are self-contained.

Managerial Decision Modeling with Spreadsheets and Student CD Package (2nd Edition)

Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Management Science, Revised (with Interactive Video Skillbuilder CD-ROM, Microsoft ... 2007, Crystal Ball Pro Printed Access Card)

Cliff Ragsdale is an innovator of the spreadsheet teaching revolution and is highly regarded in the field of management science. The revised fifth edition of SPREADSHEET MODELING AND DECISION ANALYSIS retains the elements and philosophy that has made its past editions so successful. New topics have been added as well as examples that are relevant to decision making in today's business world. This version of SPREADSHEET MODELING AND DECISION ANALYSIS has been updated for use with Microsoft® Office Excel® 2007. It provides succinct instruction in the most commonly used management science techniques and shows how these tools can be implemented using the most current version of Excel® for Windows. This text also focuses on developing both algebraic and spreadsheet modeling skills.

John Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr. Spreadsheet's Bookshelf)

John Walkenbach comments on the new Excel: "I've been using Excel for over 15 years, and Excel 2007 is by far the most significant upgrade ever. For starters, we've got a new user interface, new open file formats, a larger worksheet grid, better use of memory and CPUs, new functions, and more templates. Dig a bit deeper and you'll find worksheet tables, 100 levels of undo, easier formula construction, better-looking charts, unlimited color choices, SmartArt, a handy page layout view, new conditional formatting options, new collaboration features, a very useful compatibility checker, workbook themes—and even 'skins' so you can change the look of the entire program."

John Walkenbach's Favorite Excel 2007 Tips & Tricks consists of a series of non-trivial tips and tricks that cover all aspects of Excel. Tips are improved ways of maximizing the power of Excel to create robust applications. Tricks are shortcuts that will speed up application development with Excel.

John's favorites include tips and tricks on dealing with function arguments, creating "impossible" charts, pivot tables, taming the new Ribbon, why use a UserForm, how to create add-ins in Excel 2007, absolute vs. relative references, changing data entry orientation, overcoming the 7-level nesting limit, dynamic chart data, sorting on more than three columns, entering fake data for testing purposes, custom functions, and much more.

Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf)

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets (Hacks)

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary.

Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

• Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
• Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform.
• Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
• Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them.
• Create customized charts -- tweak and combine Excel's built-in charting capabilities.
• Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
• Make the most of macros -- including ways to manage them and use them to extend other features.
• Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

Spreadsheet Modeling and Decision Analysis (with CD-ROM and Microsoft Project 2003 120 day version)

Valuable software, realistic examples, and fascinating topics . . . everything you need to master the most widely used management science techniques using Microsoft® Excel™ is right here! Learning to make decisions in today's business world takes training and experience. Cliff Ragsdale--the respected innovator in the field of management science--is an outstanding guide to help you learn the skills you need, use Microsoft Excel for Windows to implement those skills, and gain the confidence to apply what you learn to real business situations. SPREADSHEET MODELING AND DECISION ANALYSIS gives you step-by-step instructions and annotated screen shots to make examples easy to follow. Plus, interesting sections called The World of Management Science show you how each topic has been applied in a real company.

Spreadsheet Modeling for Business Decisions w/St CD, @RISK & Crystal Ball Access Cards

Spreadsheet Modeling for Business Decisions focuses on five fundamental topics of business decision modeling; emphasizing the effective communication of results to the appropriate business decision maker. The topics include spreadsheet modeling, data management and modeling, simulation and linear regression modeling, and decision making under uncertainty. The text strives to educate managers in the process of becoming more effective and efficient problem solvers by providing the most important and useful topics within business decision models while at the same time preparing students to apply those topics to real-world problems, to integrate the use of common software packages into their analysis and solutions, and to prepare written and verbal conclusions from that analysis.