Marketplace books

Page 1 of 2

Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs

by Elliot Bendoly

Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. Its structure is designed to enhance the skills in Excel of those who have never used it for anything but possibly storing phone numbers, enabling them to reach to a level of mastery that will allow them to develop user interfaces and automated applications.
Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets

by David Hawley, Raina Hawley

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.
Professional Excel Services (Programmer to Programmer)

by Shahar Prish

Professional Excel ServicesWith this unique resource, you'll discover how to unlock the power behind Excel Services in order to effectively utilize server-side spreadsheet calculation and rendering. It walks you through all programming aspects of Excel Services, covering everything from APIs to UDFs (User Defined Functions). You'll quickly gain a strong understanding of what Excel Services is, how to work with it, and how to develop applications using its robust features.
Excel 2007 VBA Programmer's Reference (Programmer to Programmer)

by John Green, Stephen Bullen, Rob Bovey, Michael Alexander

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.
Beginning Excel Services (Programmer to Programmer)

by Liviu Asnash, Eran Megiddo, Craig Thomas

Written by Microsoft’s lead developers of Excel Services, this book shares their insights into the benefits and usage of Excel’s new server technology so that you can solve business problems. You’ll learn what Excel Services is for and how it is used, how to deploy an evaluation copy of the server and effectively administer it, and gain an understanding of how the server works. You’ll also get step-by-step guidelines for using the server in each of the scenarios for which it was designed.
Practical Reporting with Ruby and Rails (Expert's Voice in Open Source)

by David Berube

Business intelligence and real–time reporting mechanisms play a major role in any of today’s forward–looking business plans. With many of these solutions being moved to the Web, the popular Rails framework and its underlying Ruby language are playing a major role alongside web services in building the reporting solutions of tomorrow.
Programming Excel with VBA and .NET

by Jeff Webb, Steve Saunders

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.
Data Analysis Using SQL and Excel

by Gordon S. Linoff

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more.
Excel Pivot Tables Recipe Book: A Problem-Solution Approach

by Debra Dalgleish

Here is the item of choice for any advanced Excel user who seeks recipes for pivot table success. — Midwest Book Review, California Bookwatch Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTablesfrom planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.
Excel 2007: Beyond the Manual (Btm (Beyond the Manual))

by Helen Dixon

Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions. Youll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools.