This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge...

"Allman has written an excellent sequel to his first book Modeling Structured Finance Cash Flows with Microsoft Excel, providing a simple guide on how to deconstruct cash flows through modeling and understanding...

In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA) for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with...

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen...

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate...

While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual...

The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal...

Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you’ll find complete details on Excel VBA programming and application development—from the fundamentals to advanced techniques. Then, you’ll get 21 real-world projects, complete with working...

When an application is part of the Microsoft Office suite, it's sure to be a leader in its field. In the realm of desktop database management, Access is top dog with millions of users. But this is one dog that can bite. Although Access is a powerful, relational tool with the fetching talents of a Labrador, it's not an easy beast...

Eight previous editions of fans ranging from novices to Autodesk insiders can't be wrong. This bestselling, comprehensive guide is your best, one-stop, go-to guide for everything you'll need to master AutoCAD. Whether you're an AutoCAD veteran exploring what's new or a novice...

• The Root of Power Programming;
• Manipulating and Presenting Data;
• Extending Access with Interoperability;
• Adding the...